Wednesday, June 5, 2013

DB2 JDBC Driver. How to set default schema name?

Popular question "How to set default schema name creating connection to DB2 database?".

Answer is here:  http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/ad/rjvdsprp.htm

You cannot specify schema name in connection string but you always can add some extra parameters.
So you should use extended driver parameter currentSchema=your_schema_name.

No comments:

Post a Comment