Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQLcl project stage changelog.xml includes comments before tables

david schleis16 hours ago

I am using SQLcl version: 25.4.2.0 build: 25.4.2.37.1654

I am following the Jeff Smith'g getting started with SQLcl project post (https://www.thatjeffsmith.com/archive/2025/05/getting-started-with-sqlcl-projects/)

All seems well, but as a result of the stage command, the dist/releases/next/changes/new-project-01/stage.changelog.xml file begins:

<?xml version="1.0" encoding="UTF-8"?>
<databaseChangeLog xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog
http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-4.3.xsd">
<include file="dirname/comments/customer_survey.sql" relativeToChangelogFile="true"/> <!-- action="create" -->
<include file="dirname/comments/customer_survey_answer.sql" relativeToChangelogFile="true"/> <!-- action="create" -->
<include file="dirname/tables/customer_survey.sql" relativeToChangelogFile="true"/>
<include file="dirname/tables/customer_survey_answer.sql" relativeToChangelogFile="true"/>
<include file="dirname/tables/list_of_values.sql" relativeToChangelogFile="true"/>
...

You will notice that the first 2 include files are the comments for the tables defined in the next 2 include files, while the comment file for the last table is included at the end of the changelog.xml file but does not have the <!-- action="create" --> comment like the 2 early lines have.

History of commands used:

project init -name PerfEval -schemas all_schema -verbose
project config set -name export.setTransform.emitSchema -value false -verbose
project export  -objects CUSTOMER_SURVEY,CUSTOMER_SURVEY_ANSWER, CUST_SURVEY_PROJ_PERSON_V,…
project stage -branch-name new-project -verbose
Comments
Post Details
Added 16 hours ago
0 comments
7 views