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

Show: Today's Messages :: Show Polls :: Message Navigator

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

Tue, 14 August 2012 17:12

Doug Busley

Messages: 5
Registered: August 2012

Junior Member

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!

Report message to a moderator