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

[Drav S. <hol...@re...>]

Won Takemura wrote:
> 1.       Does SQuirreL work with OID?

That's really dependant on the jdbc driver, and not squirrel (as far
as I understand it)

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

You should be able to use the thin driver.

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

The OCI specification states the URL should be of the form:

jdbc:oracle:thin:@ldap://<OID server name>:<OID port>/<DB SID or Service Name>,cn=OracleContext,dc=<yourdomain>

So:

jdbc:oracle:thin:@ldap://hdsoid.ute.company.com:3060/dbname,cn=OracleContext,dc=ute,dc=company,dc=com

> 4.       Any other configuration files / environment variables needed?

I would imagine ORACLE_HOME, and possibly TNS_ADMIN

Regards

D.