generateChangeLog will add a cacheSize parameter to the sequences SQL, but it is no longer supported
Description
Environment
CentOS 5.6 with oracle XE 10g
Activity
Show:
Details
Details
Reporter
David Neto
David NetoComponents
Fix versions
Affects versions
Priority
Created August 2, 2017 at 10:00 AM
Updated August 3, 2017 at 10:09 AM
Running the following script as a sysdba:
java -jar liquibase --driver=oracle.jdbc.OracleDriver --classpath=liquibase-core-3.5.3.jar:ojdbc6-11.2.0.3.jar --changeLogFile=db.changelog.xml --url="jdbc:oracle:thin:@<address>:1521:xe" --username="sys as sysdba" --password=<password> --liquibaseSchemaName=<schema> generateChangeLog
to generate a database changelog ( as described here http://www.liquibase.org/documentation/existing_project.html ), will return an invalid XML for sequences if the CACHE value is set in said sequence, since the cacheSize parameter does not seem to be supported anymore:
<changeSet author="example (generated)" id="1501146627229-1"> <createSequence cacheSize="20" cycle="false" incrementBy="1" maxValue="999999999999999999999999999" minValue="1" ordered="false" sequenceName="SQ_EXAMPLE" startValue="3881"/> </changeSet>
This is an invalid changeset if you try to run it again.