-
1. Re: JBOSS - DB2
cherold Mar 29, 2004 7:48 AM (in response to filth)Hi
I'm using DB2 8.1.4 with jboss 3.2.3.
I#m using the JCC type 4 driver because we found this to be faster than appdriver and much easier to install.
Therefor you need the files:
db2jcc.jar
and may be one or both of these
db2jcc_license_cisuz.jar db2jcc_license_cu.jar
It works fine in our case.
good luck
regards Christian
<local-tx-datasource>
<jndi-name>db2</jndi-name>
<connection-url>jdbc:db2://IP:PORT/NAME</connection-url>
<driver-class>com.ibm.db2.jcc.DB2Driver</driver-class>
<user-name>??</user-name>
??
<min-pool-size>3</min-pool-size>
<max-pool-size>10</max-pool-size>
<blocking-timeout-millis>5000</blocking-timeout-millis>
<idle-timeout-minutes>15</idle-timeout-minutes>
<transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
</local-tx-datasource> -
2. Re: JBOSS - DB2
mjaplin Jun 6, 2005 1:49 PM (in response to filth)The DB2 Type 2 driver requires the URL to be in the fomat jdbc:db2:clientname, where client name is the name of the database as it is configured on your local machine using the DB2 client configuration utility.
The jdbc:db2:machine:port/name format only works for the new Type 4 driver found in the 8.1 JAR.