tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Gregor Schneider" <rc4...@googlemail.com>
Subject Re: Tomcat DB2 JDBC issue
Date Fri, 16 Nov 2007 15:43:27 GMT
Hi Andrew,

I've just checked the DB2-JDBC-Drivers:

You'll need two files:

1. db2jcc_license_cu.jar
2. db2jcc.jar

Both files should be somewhere on your copy of DB2 or you should be
able to download them via the IBM-website.
If you're running Db2 on OS390/zOS, you'll need a certain APAR first -
the DB2-docs should give you some information here.

Copy those files to $CATALINA_HOME/common/lib

Then, create your data-pool in your context.xml-file of the application:

<?xml version='1.0' encoding='utf-8'?>
<Context>
  <Resource
    auth="Container"
    description="DB Connection for..."
    name="jdbc/IndexYOUR_DS_NAME"
    type="javax.sql.DataSource"
    factory="org.apache.commons.dbcp.BasicDataSourceFactory"
    driverClassName="com.ibm.db2.jcc.DB2Driver"
    username="YOUR_USER
    password="YOUR_PASSWORD"
    url="jdbc:db2://<host>:<port>/<database>"
    maxIdle="30"
    maxWait="10000"
    maxActive="10"
    validationQuery="SELECT 1"
    testOnBorrow="true"
    testWhileIdle="true"
    timeBetweenEvictionRunsMillis="10000"
    minEvictableIdleTimeMillis="28800"
    poolPreparedStatements="true"
    removeAbandoned="true"
    removeAbandonedTimeout="300"
    logAbandoned="false"/>
</Context>

Don't know if "validationQuery="SELECT 1" works for DB2 - if not,
replace it with a working one.

Cheers

Gregor








On Nov 16, 2007 9:22 AM, Gregor Schneider <rc46fi@googlemail.com> wrote:
> It's quite some time since my last experience with DB2, however, maybe
> this gives you a start:
>
> There are multiple jdbc-drivers available for DB2.
>
> Obviously, youÄre using a class3-JDBC-driver, meaning that this is not
> a plain java-driver but needs some middleware to connect to DB2
> (DB2-Connect).
>
> However, DB2 also is offering a class4-JDBC-driver that does not make
> use of any such middleware.
>
> We're also using this driver in some client's environments.
>
> When I'm in the office later on, I'll lookup the name and the jdbc-url
> and let you guys know.
>
> Cheers
>
> Gregor
> --
> what's puzzlin' you, is the nature of my game
> gpgp-fp: 79A84FA526807026795E4209D3B3FE028B3170B2
> gpgp-key available @ http://pgpkeys.pca.dfn.de:11371
>



-- 
what's puzzlin' you, is the nature of my game
gpgp-fp: 79A84FA526807026795E4209D3B3FE028B3170B2
gpgp-key available @ http://pgpkeys.pca.dfn.de:11371

---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message