Websphere 5.1 orac database access problem

[Ratan Kumar]

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?

Thanks Ratan

[Brian Hennessy]

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.