|
Home > Archive > WebSphere Application Server > August 2005 > UnsatisfiedLinkError: xaConnect - WAS 5.1, JDBC Providers
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
UnsatisfiedLinkError: xaConnect - WAS 5.1, JDBC Providers
|
|
|
| Problem Description ? we are unable to connect via a JDBC provider from within WebSphere to a DB2 database.
We have created the JDBC Provider, defined the classpath to the Type 2 driver and license files, set the WebSphere environment variable for the DB2_JDBC_DRIVER_PATH. The application ID for WebSphere has access to the DB2 instance home.
Troubleshooting ?
We have successfully connected to the database using DB2 connect from the server, as well as using a simple JDBC.
We have re-installed the DB2 Enterprise JDBC Driver ? all three files necessary for connectivity exist
We have tried copying over the three files (db2java.zip, db2jcc_license_cu.jar, db2jcc_license_cisuz.jar) from another installation
We have tried to re-create the JDBC provider ? both XA and non XA, as well as Class 2 and Class 4 drivers
We have defined the DB2_JDBC_DRIVER_PATH WebSphere variable
Here is the necessary information
AIX 5.3 ML02
WebSphere 5.1.1.2
DB2 Database version 7.1.1 (located remotely on z/OS thru DB2 Connect gateway)
DB2LEVEL on the AIX server is DB21085I Instance "db2clnt" uses "32" bits and DB2 code release "SQL08022" with level identifier "03030106". Informational tokens are "DB2 8.1.1.88", "s050422", "U800789", and FixPak "9". Product is installed at "/usr/opt/
db2_08_01".
The CLASSPATH for the JDBC driver has been set
/home/db2clnt/sqllib/java/db2java.zip
/home/db2clnt/sqllib/java/db2jcc_license_cu.jar
/home/db2clnt/sqllib/java/db2jcc_license_cisuz.jar
| |
| Ken Hygh 2005-08-30, 6:01 pm |
| robertlennie@gmail.com wrote:
>Problem Description ? we are unable to connect via a JDBC provider from within WebSphere to a DB2 database.
>We have created the JDBC Provider, defined the classpath to the Type 2 driver and license files, set the WebSphere environment variable for the DB2_JDBC_DRIVER_PATH. The application ID for WebSphere has access to the DB2 instance home.
>
>Troubleshooting ?
>
>We have successfully connected to the database using DB2 connect from the server, as well as using a simple JDBC.
>We have re-installed the DB2 Enterprise JDBC Driver ? all three files necessary for connectivity exist
>We have tried copying over the three files (db2java.zip, db2jcc_license_cu.jar, db2jcc_license_cisuz.jar) from another installation
>We have tried to re-create the JDBC provider ? both XA and non XA, as well as Class 2 and Class 4 drivers
>We have defined the DB2_JDBC_DRIVER_PATH WebSphere variable
>
>
>Here is the necessary information
>
>AIX 5.3 ML02
>
>WebSphere 5.1.1.2
>
>DB2 Database version 7.1.1 (located remotely on z/OS thru DB2 Connect gateway)
>
>DB2LEVEL on the AIX server is DB21085I Instance "db2clnt" uses "32" bits and DB2 code release "SQL08022" with level identifier "03030106". Informational tokens are "DB2 8.1.1.88", "s050422", "U800789", and FixPak "9". Product is installed at "/usr/opt
/db2_08_01".
>
>The CLASSPATH for the JDBC driver has been set
>/home/db2clnt/sqllib/java/db2java.zip
>/home/db2clnt/sqllib/java/db2jcc_license_cu.jar
>/home/db2clnt/sqllib/java/db2jcc_license_cisuz.jar
>
>
>
What error do you get? from what code?
Ken
|
|
|
|
|