users@glassfish.java.net

Re: DB2 Connection Pool DriverType 2 HowTo

From: <glassfish_at_javadesktop.org>
Date: Fri, 10 Aug 2007 07:17:05 PDT

For me DriverType 2 is working fine on Windows, following the next steps:

Need first to install DB2 client runtime
"DB2_runtime_lite_ALL_LANG_setup.exe"

Then setup a tcp node remote and db

db2cmd /c /w /i db2 catalog tcpip node dbInstance remote hostname server 50000 remote_instance dbInstance

db2cmd /c /w /i db2 catalog db DB2MyDB as DB2MyDB at node dbInstance authentication server


"DOMAIN.XML"

    </jdbc-connection-pool>
    <jdbc-connection-pool allow-non-component-callers="false" connection-validation-method="auto-commit" datasource-classname="com.ibm.db2.jcc.DB2ConnectionPoolDataSource" fail-all-connections="false" idle-timeout-in-seconds="300" is-connection-validation-required="false" is-isolation-level-guaranteed="false" max-pool-size="32" max-wait-time-in-millis="60000" name="DB2MyDB" non-transactional-connections="false" pool-resize-quantity="2" res-type="javax.sql.ConnectionPoolDataSource" steady-pool-size="8">
      <description>Type 2</description>
      <property name="DriverType" value="2"/>
      <property name="user" value="user"/>
      <property name="password" value="password"/>
      <property name="databaseName" value="DB2MyDB"/>
      <property name="deferPrepares" value="False"/>
    </jdbc-connection-pool>
[Message sent by forum member 'pmarc' (pmarc)]

http://forums.java.net/jive/thread.jspa?messageID=230473