Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

generateChangeLog will add a cacheSize parameter to the sequences SQL, but it is no longer supported

Description

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.

Environment

CentOS 5.6 with oracle XE 10g

Activity

Show:

Details

Reporter

Components

Fix versions

Affects versions

Priority

Created August 2, 2017 at 10:00 AM
Updated August 3, 2017 at 10:09 AM
Configure

Flag notifications