Two Laptop Bag
The moose likes JDBC and Relational Databases and the fly likes JDBC/Oracle access problem Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "JDBC/Oracle access problem" Watch "JDBC/Oracle access problem" New topic

JDBC/Oracle access problem

Saket Barve
Ranch Hand

Joined: Dec 19, 2002
Posts: 229

I am trying to access a networked machine through the following JDBC code. I have checked the SID, port, user name and password. The same parameters work smoothly when I use Toad for DB access but fails here.

Here is the error:

I tried replacing the IP address with the machine name but that wouldn't work either.

Bhavin Sanghani
Ranch Hand

Joined: Dec 17, 2003
Posts: 67
Hi Saket,

go through following link...HTH

secondly, in JDBC url paste ur tns entry (google it for proper format)...

also, there could be some version related issues...different format of JDBC url is proposed from Oracle to use Oracle JDBC driver...just check it out..

I agree. Here's the link:
subject: JDBC/Oracle access problem
It's not a secret anymore!