[Squirrel-sql-users] Oracle HDS-OID Connection String

[Won T. <won...@fe...>]

I am using SQuirrreL with Oracle 11g .

The connection string looks like this:
jdbc:oracle:thin:@host.corp.company.com:1521:dbname

We are changing over to use Oracle OID and LDAP service names.

The DBA team has provided me this information for use with an Oracle client:

Also you will need the following files in Oracle_home/network/admin directory or where your current tnsnames.ora is.

Create ldap.ora file with the following entries
DIRECTORY_SERVERS= (hdsoid.ute.company.com:3060:3131)
DEFAULT_ADMIN_CONTEXT = "dc=ute,dc=company,dc=com"
DIRECTORY_SERVER_TYPE = OID


In the sqlnet.ora file add following:
NAMES.DIRECTORY_PATH= (LDAP,TNSNAMES)


QUESTIONS:

1.       Does SQuirreL work with OID?

2.       Can I still use the thin driver or do I need to update?

3.       What would the connection string look like given the information above?

4.       Any other configuration files / environment variables needed?

I would prefer to use SQuirreL rather than have to install a Oracle client.