Java EE (Java Enterprise Edition) General Discussion

Hi,

I am using WebSphere 5.1 Application server and DB2 v8.1.0 and Windows 2000 advanced server OS

While tring ot create Datasource with the DB2 Universal JDBC Driver Provider (XA) I select Driver type 2 as I require Distributed Transaction between two databases in my J2EE application.

While tring to Test Connection for the created datasource following Error comes.

Test Connection failed for datasource NFPD on server dmgr at node staging1Manager with the following exception: java.lang.Exception: com.ibm.db2.jcc.b.SqlException: Failure in loading T2 native library db2jcct2. View JVM logs for further details. null

I tried searching the net and found that this Driver uses some shared Library of the OS for talking to the database. It looks for the db2jcct2.dll. I have downloaded the file and put it in the required directory and restarted the machine. But it still doesnt work.

This Driver works perfectly on local machine where I use db2 v8.1.7 and WebSphere 5.1

The application does not work with the Universal Driver type 4

Can anyone plese help me find a proper solution to this problem.

Thanks and regards
Prakash Anand