wood burning stoves 2.0*
The moose likes Websphere and the fly likes Websphere 5.1 orac database access problem Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Products » Websphere
Bookmark "Websphere 5.1 orac database access problem" Watch "Websphere 5.1 orac database access problem" New topic
Author

Websphere 5.1 orac database access problem

Ratan Kumar
Ranch Hand

Joined: Jul 19, 2006
Posts: 67
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

Joined: Oct 24, 2005
Posts: 57
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.
 
Don't get me started about those stupid light bulbs.
 
subject: Websphere 5.1 orac database access problem
 
Similar Threads
Naming Exception happened when trying to connect to Oracle in Sun One Application Ser
MSSQL Server datasource wont commit
InjectionException
Datasource JNDI Lookup in WSAD from standalone app
InjectionException