Tuesday, February 15, 2011

Eclipse unable to create a DBConnection

The custom JDBC URL is:

jdbc:oracle:thin:@ldap://oid.acme:389/BLABLA,cn=OracleContext,dc=pr,dc=acme,dc=be

In SQL Developer you can specify a custom URL;

In Eclipse, no way, you must enter the individual fields and no matter what, it keeps appending a ":" after 389

The only workaround is to create a dummy connection, then edit the SID in the "Database Connections" "properties".... a terrible hack for a terrible product (Eclipse)

You should set this:

SID=389/BLABLA,cn=OracleContext,dc=pr,dc=acme,dc=be
HOST=ldap
PORT NUMBER=//oid.acme

No comments: