Steffen E.

Greenhorn
+ Follow
since Jan 09, 2009
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Steffen E.

Hi,

I like to know I can integrate a DB2 9.5 data source into WebSphere Application Server - ND, 6.0.2.17 on a Solaris system.

My problem is that I get no connection but this exception:
com.ibm.db2.jcc.a.SqlException: DatabaseMetaData information is not known for server DB2/SUN64SQL09050 by this version of JDBC driver

I defined a new data source (new DB2, DB2 Universal JDBC Driver Provider, Connection pool data source) with this classpath:
${DB2_JDBC_9.5_DRIVER_PATH}
${DB2_JDBC_9.5_DRIVER_PATH}/db2cc.jar
${DB2_JDBC_9.5_DRIVER_PATH}/db2jcc_license_cu.jar
But nothing in the field “Native Library Path”.
Then I defined a new version 4 data source (required by my project). When I test the connection, WAS returns “successful”. But our application throws the exception above.

The problem seems to be that WebSphere includes old DB2 drivers by default. They overrule the new ones. It only works when I integrate the jars into my ear file and change the Class loader mode to "Parent Last". But this solution is not allowed for this application. So I search another solution.

Do I have to change the libraries that are loaded by this class loader: “WAS Bootstrap Extension Class Loader”?

I like to use the class loader mode "Parent First". When I view the class loaders (Enterprise Applications > My Application > my EJB > View Module Class Loader ) the order of the class loaders is JDK Extension Loader, JDK Application Class Loader, WAS Bootstrap Extension Class Loader, WAS Protection Class Loader.

WAS Bootstrap Extension Class Loader loads many libraries. Among them are those:
file:/opt/IBM/WebSphere/AppServer/lib/db2Interfaces.jar
file:/opt/IBM/WebSphere/AppServer/cloudscape/lib/db2j.jar
file:/opt/IBM/WebSphere/AppServer/cloudscape/lib/
file:/opt/IBM/WebSphere/AppServer/cloudscape/lib/db2jcc.jar
file:/opt/IBM/WebSphere/AppServer/cloudscape/lib/db2jcc_license_c.jar
file:/opt/IBM/WebSphere/AppServer/cloudscape/lib/db2jcview.jar
file:/opt/IBM/WebSphere/AppServer/cloudscape/lib/db2jnet.jar
file:/opt/IBM/WebSphere/AppServer/cloudscape/lib/db2jtools.jar
file:/opt/IBM/WebSphere/AppServer/cloudscape/lib/jh.jar
file:/opt/IBM/WebSphere/AppServer/cloudscape/lib/otherJars/db2cc.jar
file:/opt/IBM/WebSphere/AppServer/universalDriver/lib/db2jcc_license_cu.jar
I think that’s the problem. But I haven’t found out how I can change that.

Does someone know how I can change the libraries the WAS Bootstrap Extension Class Loader loads? Can anybody tell me a simpler solution to integrate DB2 9.5 datasources in WAS6?

Thanks in advance!

Kind regards,
Steffen
11 years ago