IBM® Data Server Driver for JDBC and SQLJ properties define how the connection to a particular data source should be made. Most properties can be set for a DataSource object or for a Connection object.
IBM Data Server Driver for JDBC and SQLJ property names are case-sensitive.
If you specify a property name that does not exist, the IBM Data Server Driver for JDBC and SQLJ does nothing with the property setting, and does not issue an error.
String url =
"jdbc:db2://sysmvs1.stl.ibm.com:5021/STLEC1" +
":user=dbadm;password=dbadm;" +
"traceLevel=" +
(com.ibm.db2.jcc.DB2BaseDataSource.TRACE_ALL) + ";";
Connection con =
java.sql.DriverManager.getConnection(url);