aspose file tools*
The moose likes JDBC and the fly likes JDBC/Oracle access problem Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of JavaScript Promises Essentials this week in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "JDBC/Oracle access problem" Watch "JDBC/Oracle access problem" New topic
Author

JDBC/Oracle access problem

Saket Barve
Ranch Hand

Joined: Dec 19, 2002
Posts: 229
Hello,

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.

Regards,
Saket
Bhavin Sanghani
Ranch Hand

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

go through following link...HTH

http://www.oracle.com/technology/tech/java/sqlj_jdbc/htdocs/jdbc_faq.htm

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..

-bhavin
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JDBC/Oracle access problem