Is there a way to set defaultSchemaName when using Servlet Listener?

General Discussion
1

I was wondering if there is a way to set the defaultSchemaName value when loading changesets via the servlet listener? What I would like is to reliably control the schema the liquibase tables are created in. I could not see an option for this in the manual.

Cheers,
Christian

2

There isn’t currently.  The best option is probably to copy the ServletListener code and call setDefaultSchemaName on the liquibase object created in there.

Nathan

3

The issue I had was for a DB2 deployment. I was able to get around the issue by creating a DB2JccConfiguration.properties file and putting it into the same class path as my change sets. Inside that file I added the following:

db2.jcc.override.currentSchema=MYSCHEMA

For anyone interested in other properties a good article can be found at http://www.db2ude.com/?q=node/75

Cheers,
Christian.

4

Glad you found a solution, thanks for letting us know.

Nathan