Issue with SID vs ServiceName for jdbc connection to Oracle

dBase, Calc, CSV, MS ACCESS, MySQL, PostgrSQL, OTHER
Post Reply
kminder
Posts: 1
Joined: Thu Oct 16, 2008 9:45 pm

Issue with SID vs ServiceName for jdbc connection to Oracle

Post by kminder »

I'm trying to connect to an Oracle database. The JDBC URL that I use in other application looks like this.
jdbc:oracle:thin:@//mydbhostname:1521/mydbservicename
This is fundamentally different than the URL
jdbc:oracle:thin:@//mydbhostname:1521:mydbsid
Note the slash vs the colon separating the last component.
If I create a new connection using the wizard everything goes fine. It connects and I can work as expected. However if I restart and attempt to load the connection information from the registered .odb file several things are wrong.
1) It thinks the ServiceName is a SID and so tries to reconstruct the URL with a colon.
2) It messes up the "Name of the Oracle database" which it thinks is "1521/mydbservicename"
3) It messes up the "Host Name" which it thinks is "//mydbhostname"
I couldn't figure out how to file a bug so I hope this finds a developer who can fix it.
OOo 3.0.X on Ms Windows XP
Tiberius
Posts: 1
Joined: Fri Oct 16, 2009 2:31 pm

Re: Issue with SID vs ServiceName for jdbc connection to Oracle

Post by Tiberius »

Same Problem here. Even when I select "JDBC" instead of "Oracle JDBC" and enter the complete jdbc connection string myself, I always get the same error message, always with a connection discriptor in colon notation.

I can not use the SID because we use Oracle Connection Manager and the CMAN only knows ServiceName's, no SID's.
OpenOffice 3.0.1 - Ubuntu 9.0.4
Post Reply