Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Eclipse Database Connection with Oracle 12c JDBC Driver

Peter551059Jul 2 2018 — edited Jul 2 2018

Hello.

I have Luna Service Release 2 (4.4.2) and Database Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production.

I have problem to create DB connection.

Oracle Connection profile use Oracle Thin Driver only with SID (not Service name).

When I want to add New Driver Definition there are only 8 to 11 System versions of Oracle Thind Driver.

I have downloaded ojdbc7.jar to make new connection but still I cannot use Service name instead SID. Connection url then is jdbc:oracle:thin:@server:1521:db not jdbc:oracle:thin:@server:1521/db.

I have tried to update Connection URL manually in Driver's properties but I have no luck. Driver still uses wrong template

Please help me how to make connection to Oracle 12c Database in Eclipse.

Thank you in advance.

This post has been answered by Peter551059 on Jul 2 2018

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 30 2018

Added on Jul 2 2018

#java-database-connectivity-jdbc

1 comment

7,848 views