File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Websphere and the fly likes WebSphere DB2 Connection Pool Setup Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Soft Skills this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Products » Websphere
Bookmark "WebSphere DB2 Connection Pool Setup" Watch "WebSphere DB2 Connection Pool Setup" New topic
Author

WebSphere DB2 Connection Pool Setup

Keith Tingle
Greenhorn

Joined: Jan 12, 2004
Posts: 22
Hi-
I am using a trial version of WebSphere on a p620 series here at the office.
IBM WebSphere Application Server, 5.0.1
Build Number: ptf1031801trial
Build Date: 5/7/03
I have a licsensed version of DB2 UDB-EE up and running on the same machine, and I would like to connect my web application to the DB instance.
The DB2 Universal JDBC Driver Provider Classpath is defined as follows, I basically have every jar in the ${DB2_INSTALL}/java directory in the classpath, in this order;
${DB2_JDBC_DRIVER_PATH}/db2java.zip
${DB2_JDBC_DRIVER_PATH}/db2jcc_license_cu.jar
${DB2_JDBC_DRIVER_PATH}/db2jcc_license_cisuz.jar
${DB2_JDBC_DRIVER_PATH}/db2jcc.jar
Any attempt by my servlets to obtain a datasource results in the following;
com.ibm.db2.jcc.a.SqlException: The version of the IBM Universal JDBC driver in use is not licensed for connectivity to DB2 for Unix/Windows databases. To connect to this DB2 server, please obtain a licensed copy of the IBM DB2 Universal Driver for JDBC and SQLJ. An appropriate license file db2jcc_license_*.jar for this target platform must be installed to the application classpath. Connectivity to DB2 for Unix/Windows databases is enabled by any of the following license files: { db2jcc_license_cu.jar, db2jcc_license_cisuz.jar }
All of the resource key/value pairs are set up and I actually have the same settings working from my WebSphere Studio environment. Meaning I am able to run my servlets against the DB2 instance from my client machine just fine.
So the driver seems to be asking for files that are already provided in the classpath....
Any thoughts would be appreciated!
[ January 12, 2004: Message edited by: Keith Tingle ]

SCJP - 8/31/2004
Keith Tingle
Greenhorn

Joined: Jan 12, 2004
Posts: 22
Ok. a WS restart fixed everything.
Is that normal? Seems like config changes wouldn't require a restart.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: WebSphere DB2 Connection Pool Setup