I’m trying to use Liquibase to extract the DDL from a DB2 Database. The Database has several schemas (say A, B, C, D, E) but the user I have to log in with is not the owner of any of those schemas (although they do have the appropriate grants to access them).
General internet wisdom suggested that suffixing the JDBC url with :currentSchema=; should work but when I try this Liquibase still seems to use the connecting user’s default schema.
For reference here is the full command I am using (in this example I am trying to set the currentSchema to EM3:
./liquibase --driver=com.ibm.db2.jcc.DB2Driver \ --classpath=/usr/local/java/maven-repository/com/ibm/db2/db2jcc/9.7.1/db2jcc-9.7.1.jar \ --changeLogFile=em3db.xml \ --url=“jdbc:db2://tmmdb4511.berserkgibbons.com:60001/EM3CORDB:currentSchema=EM3;” \ --username=em3appdb \ --password=thisisobviouslynottherealpassword \ generateChangeLog
Has anyone managed to get this working? If not is it worth me raising as a bug in JIRA? I’d be happy to see if I can make time to write a patch if someone could point me in the right direction in terms of code areas to look at.