?
Solved

Websphere DataSource issue on AIX

Posted on 2005-03-04
2
Medium Priority
?
2,661 Views
Last Modified: 2013-12-10
Hi
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
ngujja




0
Comment
Question by:ngujja
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 

Author Comment

by:ngujja
ID: 13462100
never mind. i found the solution.

copying libdb2jdbc.so to /AppServer/bin/ helps.

Please close this question and refund. do not delete, it might be useful to somebody.
0
 
LVL 2

Accepted Solution

by:
Lunchy earned 0 total points
ID: 13462836
Closed, 500 points refunded.
Lunchy
Friendly Neighbourhood Community Support Admin
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Configure Web Service (server application) I. Configure security for Web Services methods First, we need to protect Session bean which implements the service: 1. Open EJB deployment descriptor (ejb-jar.xml) in the EJB project that contains you…
Most of the developers using Tomcat find it easy to configure the datasource in Server.xml and use the JNDI name in the code to get the connection.  So the default connection pool using DBCP (or any other framework) is made available and the life go…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Suggested Courses

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question