Help coderanch get a
new server
by contributing to the fundraiser
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Websphere 5.1 orac database access problem

 
Ranch Hand
Posts: 67
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Ranch Hand
Posts: 57
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Wink, wink, nudge, nudge, say no more, it's a tiny ad:
We need your help - Coderanch server fundraiser
https://coderanch.com/t/782867/Coderanch-server-fundraiser
reply
    Bookmark Topic Watch Topic
  • New Topic