Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQLException: Invalid Oracle URL Specified

843854Nov 21 2002 — edited Nov 24 2002

I'm attempting to connect to an Oracle 7.34 database using the OCI driver, but keep getting an SQLException: "Invalid Oracle URL Specified". The connection string I'm using is:
Connection conn = DriverManager.getConnection("jdbc:oracle:oci7@192.23.28.69:1520:OWDYCE98","CNS","N02133002");
I know the URL, port number and database SID are correct, and these match those in the tnsnames.ora file. I can successfully use the tnsnames.ora file to connect to this database using another program (ie. BrioQuery). Is there something wrong with my syntax?

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 22 2002

Added on Nov 21 2002

#java-database-connectivity-jdbc

4 comments

6,497 views