• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Websphere 5.1 orac database access problem

 
Ratan Kumar
Ranch Hand
Posts: 67
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 57
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic