Websphere DataSource issue on AIX
Posted on 2005-03-04
I have WAS 5.0.2 AIX 5.3 and DB2 7.3. I had no problem creating Data Source on Windows. But Iam unable to create a successful DataSource on AIX.
Iam using DB2 Legacy CLI-based Type 2 JDBC Driver, the same I used on Windows. Iam sure all the details I have given are correct; username, password, driver location. Everytime I click on Test Connection it gives me the following error.
Test Connection failed for datasource atfDataSource on server server1 at node cltrsdev01 with the following exception: java.sql.SQLException: java.lang.UnsatisfiedLinkError: SQLConnect.
The database is created by atfinst1 user, and WebSphere server is run by root, is this a problem?
Somebody told me the Test Connection sometimes does not work, but my application cannot connect to DB either.
Appreciate your help