Skip to Main Content

Oracle Database Discussions

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!

JDBC connection strings

434168Oct 15 2007 — edited Oct 15 2007
We're having a problem connecting to one of our databases using JDBC thin. There seem to be two formats for the connection strings:

jdbc:oracle:thin:@opctest.deq.state.ms.us:1522:TEST8131

jdbc:oracle:thin:@//opctest.deq.state.ms.us:1522/TEST8131

From a java app, the first throws an "Io exception: Invalid connection string format, a valid format is: "//host:port/service_name" " error; the second throws a TNS-12514: TNS:listener does not currently know of service requested in connect descriptor error.

What confuses me more is that if I test this string from a JSP page:

jdbc:oracle:thin:@opctest.deq.state.ms.us:1522:test8131

it connects fine.

The environment is Oracle9i on Red Hat, running MTS. Java app is running on WinXP. Anyone have an idea what's going on?

Thanks,
Harry
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 12 2007
Added on Oct 15 2007
2 comments
712 views