понедельник, 25 мая 2015 г.

вторник, 5 мая 2015 г.

Db2 LUW 10.5 JDBC driver properties

Db2 JDBC driver for LUW has a lot of properties. Description  one can find on http://www-01.ibm.com/support/knowledgecenter/SSEPGG_10.5.0/com.ibm.db2.luw.apdv.java.doc/src/tpc/imjcc_r0052607.html.

One useful property I was needed is "currentSchema" . It specifies the default schema name that is used to qualify unqualified database objects in dynamically prepared SQL statements. The value of this property sets the value in the CURRENT SCHEMA special register on the database server. The schema name is case-sensitive, and must be specified in uppercase characters.

In WebSphere Application Server this properties  can be found in "Custom properties" section of the datasource.