Eclipse Community Forums - RDF feed
https://www.eclipse.org/forums/
Eclipse Community ForumsOracle - Old syntax for connection string when using Database Development perspective
https://www.eclipse.org/forums/index.php/mv/msg/369477/901817/#msg_901817
I'm having some issues using the database development perspective for our Oracle database. The wizard asks for an SID which is part of the old syntax for connecting. I would like to use the service name instead but the wizard does not allow you to do so and it greys out the input box for the connection url so I can't do it manually.
Essentially, I'd like to do this:
jdbc:oracle:thin:@//HOST:PORT/SERVICE
But it generates this:
jdbc:oracle:thin:@HOST:PORT:SID
Is there a file I can go into and correct the connection url? It won't let me connect with the generated connection url.
Thanks!]]>Doug Busley2012-08-14T16:52:38-00:00Re: Oracle - Old syntax for connection string when using Database Development perspective
https://www.eclipse.org/forums/index.php/mv/msg/369477/901819/#msg_901819
Stephan
]]>Stephan Herrmann2012-08-14T16:55:57-00:00Re: Oracle - Old syntax for connection string when using Database Development perspective
https://www.eclipse.org/forums/index.php/mv/msg/369477/901820/#msg_901820
Thanks, I figured I might be posting in the wrong spot. Could you point me to the right forum?
Thanks.]]>Doug Busley2012-08-14T17:03:50-00:00Re: Oracle - Old syntax for connection string when using Database Development perspective
https://www.eclipse.org/forums/index.php/mv/msg/369477/901823/#msg_901823
Doug Busley wrote on Tue, 14 August 2012 19:03
Thanks, I figured I might be posting in the wrong spot. Could you point me to the right forum?
You didn't even tell which wizard you are using.
What Eclipse features are you using? EclipseLink? Web Tools? I don't know who provides a database development perspective.
If you really don't know which component contributes that functionality, open the wizard hit Alt-Shift-F1 and it will tell you which classes implement the wizard. From the package names you should be able to deduce more information.
HTH,
Stephan
]]>Stephan Herrmann2012-08-14T17:18:49-00:00Re: Oracle - Old syntax for connection string when using Database Development perspective
https://www.eclipse.org/forums/index.php/mv/msg/369477/901827/#msg_901827
To fix the problem I had use the Oracle Other Driver instead of the Oracle Thin Driver.]]>Doug Busley2012-08-14T17:28:13-00:00