generatechangelog oracle fails with lowercase schema name

Description

when running the command generatechangelog on an existing oracle database with a lowercase user/schema name liquibase fails to find any results and returns an empty changelog xml file.

From what I can tell, the cause of this is that liquibase is changing the user/schema name to all caps, which in oracle fails to match in the existing database and the select statements return zero results. I've tried encapsulating the user name in quotes, which doesn't help at all. If I explicitly set the schema name using the defaultschemaname property, either with or without quotes, then liquibase will find and output the sequences, but nothing else.

liquibase command:

liquibase --changeLogFile="origChangeLog.xml" --logLevel="debug" generateChangeLog

liquibase properties:

#Liquibase.properties driver: oracle.jdbc.OracleDriver url: jdbc:oracle:thin:@localhost:1521:XE username: "dbuser" password: ***

debug log results:

liquibase --changeLogFile="origChangeLog.xml" --logLevel="debug" generateChangeLog DEBUG 9/16/14 1:26 PM:liquibase: Connected to "dbuser"@jdbc:oracle:thin:@localhost:1521:XE DEBUG 9/16/14 1:26 PM:liquibase: Setting auto commit to false from true DEBUG 9/16/14 1:26 PM:liquibase: Executing QUERY database command: SELECT SEQUENCE_NAME FROM ALL_SEQUENCES WHERE SEQUENCE_OWNER = 'DBUSER' INFO 9/16/14 1:26 PM:liquibase: origChangeLog.xml exists, appending DEBUG 9/16/14 1:26 PM:liquibase: MissingObjectChangeGenerator type order: liquibase.structure.core.Catalog liquibase.structure.core.Schema liquibase.structure.core.Sequence liquibase.structure.core.StoredProcedure liquibase.structure.core.Table liquibase.structure.core.Column liquibase.structure.core.PrimaryKey liquibase.structure.core.ForeignKey liquibase.structure.core.UniqueConstraint liquibase.structure.core.Index liquibase.structure.core.View DEBUG 9/16/14 1:26 PM:liquibase: UnexpectedObjectChangeGenerator type order: liquibase.structure.core.Catalog liquibase.structure.core.ForeignKey liquibase.structure.core.Schema liquibase.structure.core.StoredProcedure liquibase.structure.core.UniqueConstraint liquibase.structure.core.View liquibase.structure.core.Table liquibase.structure.core.PrimaryKey liquibase.structure.core.Column liquibase.structure.core.Index liquibase.structure.core.Sequence DEBUG 9/16/14 1:26 PM:liquibase: ChangedObjectChangeGenerator type order: liquibase.structure.core.Catalog liquibase.structure.core.ForeignKey liquibase.structure.core.Schema liquibase.structure.core.Sequence liquibase.structure.core.StoredProcedure liquibase.structure.core.Table liquibase.structure.core.Column liquibase.structure.core.PrimaryKey liquibase.structure.core.Index liquibase.structure.core.UniqueConstraint liquibase.structure.core.View INFO 9/16/14 1:26 PM:liquibase: No changes found, nothing to do Liquibase 'generateChangeLog' Successful

Environment

running an oracle database on linux and using liquibase form the terminal

Activity

Show:

Details

Reporter

Affects versions

Priority

Created September 18, 2014 at 3:24 PM
Updated September 18, 2014 at 3:24 PM