Connecting to oracle enterprise 11 from eclipse with Service Name

Question

I would like to connect to Oracle 11g Enterprise DB from eclipse as part of JPA Project. I have service name, U/P and Hostname. But the option provided for me in eclipse is SID, which I do not have.

I use SQL Developer to connect to database and it works perfectly. I am not sure how to connect from eclipse with Service Name. any help? I tried to give Service Name for SID. It didn't work.

Jar I am using is ojdbc14.jar. Not sure if this is the right Jar.

Answer 1

You can use "Generic JDBC" connection profile and specify url directly: jdbc:oracle:thin:@//host:port/service_name