I have created the Oracle datasource in WSAD IE 5.1
datasource : mydb database name: mydb jndi name : jdbc/mydb servername : myserver.mydomain.com port no : 1522 URL : jdbc racle:thin:@myserver.mydomain.com:1522:mydb
Now when I try to run the application on Websphere 5.1 Integration Test Environment, I get the following exception trace:
J2CA0122I: Resource reference jdbc/mydb could not be located, so default values of the following are used: [Resource-ref settings] ....
Begin backtrace for nested exception java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
Can anybody tell me,what is the problem and how I can solve that?
posted 9 years ago
Hi Ratan The J2CA0122I message I think is just a warning if you perform a JNDI lookup without a resource being defined in your deployment descriptor as a resource-ref. (using ENC java:comp/env/your_resource_ref_name).
The SQL exception you've experienced ,are you sure that the port number for Oracle is correct its normally 1521 and you have it as 1522. Maybe you configured this at installation but it might be worth performing a netstat -a on the host machine running the Oracle DB.