Eclipse Community Forums: DTP » Oracle - Unable to use new syntax connection string when using Database Development Perspective

Home » Eclipse Projects » DTP » Oracle - Unable to use new syntax connection string when using Database Development Perspective

Oracle - Unable to use new syntax connection string when using Database Development Perspective [message #901821]

Tue, 14 August 2012 13:12

Eclipse User

Hello Everyone,

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!

Re: Oracle - Unable to use new syntax connection string when using Database Development Perspective [message #901826 is a reply to message #901821]

Tue, 14 August 2012 13:24