|Oracle DB URL failure, must have slash [message #651828]
||Tue, 01 February 2011 18:04
| David Balažic
Registered: July 2009
Using Eclipse J2EE Helios SR-1 I opened the Database Development perspective and created a new database connection.
I selected type Oracle and the Oracle Thin driver version 10 , file ojdbc14.jar.
The problem is that in the general Properties dialog, the username, password, server, ort, SID are entered separated and the program combines them to an URL in the form jdbc:oracle:thin:@servername:1521:SID
And this URL does not work. The error upon connecting is :
java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
Using Java code, I can connect if the URL is changed to have a slash between port and SID instead of colon, like this:
DriverManager.getConnection("jdbc:oracle:thin:@servername:1521/SID", "user", "pass");
But in the DB Development wizard (or in the Properties dialog) it is not possible to specify the URL manually.
What to do?
Am I overlooking something?
Powered by FUDForum
. Page generated in 0.01625 seconds