File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/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 Android Security Essentials Live Lessons this week in the Android 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
 
 
subject: JDBC/Oracle access problem
 
Similar Threads
SQLException: invalid arguments in call??
invalid driver designator error ..please help
SQLException: invalid arguments in call??
PROBLEMS IN CONNECTING TO ORACLE
How to verify JDBC version using oracle thin driver