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

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 12 2007

Added on Oct 15 2007

#general-database-discussions

2 comments

712 views