depreciated DB2 classes

General discussion on the JZOS batch launcher and toolkit
Post Reply
mwilliam
Posts: 37
Joined: Mon Oct 11, 2004 3:21 pm

depreciated DB2 classes

Post by mwilliam »

Hello,
I have noticed as with of DB2 version 9 that the class com.ibm.db2.jcc.DB2DataSource has been depreciated. :(
I was wondering what other alternative Data Source
Class I could use instead? And does this mean that
the data source factory com.ibm.db2.jcc.DB2DataSourceFactory has depreciated as well?
dovetail
Site Admin
Posts: 2022
Joined: Thu Jul 29, 2004 12:12 pm

Post by dovetail »

According to this APAR, IBM recommends using DB2SimpleDataSource:

http://www-01.ibm.com/support/docview.w ... wg1PK93123

In our latest t:Z Quickstart of Tomcat z/OS package, we use Tomcat's pooling datasource wrapper on top of DB2's DriverManager:

Code: Select all

    <Resource name="jdbc/db2-type2" auth="Container" 
              type="javax.sql.DataSource"
              description="DB2 type-2 JDBC pooled DataSource"
              maxActive="20" maxIdle="3" maxWait="10000"
              removeAbandoned="true" removeAbandonedTimeout="60" 
              logAbandoned="true"
              validationQuery="SELECT IBMREQD FROM SYSIBM.SYSDUMMY1"
              driverClassName="com.ibm.db2.jcc.DB2Driver"
              url="jdbc:db2:&db2Loc;"  />
Post Reply