JDBC connection strings
434168Oct 15 2007 — edited Oct 15 2007We'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