Problem connecting to an Oracle DB via TNS.

[cardy]

What is the syntax for connecting to an Oracle DB using TNS. The only way I have managed to get it to work so far is by including the full description from the tnsnames.ora file for the database I am trying to connect to in the URL e.g.
sqlj.url=jdbcracle:thin(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(COMMUNITY=UNIXTCP)(PROTOCOL=TCP)(HOST=kings)(PORT=1521)))(CONNECT_DATA=(SID=cam02dev)))

This entry is called cam02dev (same as the SID) in my tnsnames.ora file so why can't I just say
sqlj.url=jdbcracle:thincam02dev

I've also tried oci8 instead of thin and it still won't connect.

The error message I get is
java.sql.SQLException: No suitable driver

 

[guenter]

you can use :

'_connection = DriverManager.getConnection ( "jdbcracle:thinhostnameortBname", "user", "password"'

hostname: dns-name or ip-address
port: port of your DB Listener
DB-Name: SID !!! ( not network alias)

but it seems to me you are talking about 2 different things.
first: with this syntax you are going to use the THIN-Driver which in turn does not need a TNS resolve because it is an thin driver.
( which means you would not need a oracle client installation ( no tnsnames.ora !))
the tradeoff of this driver type is that is real slow !

second: you can use an Oracle OCI-Driver ( Oracle Call Interface ) which uses an existing Oracle Client installation ( this means an TNS Connection ).
This Dirver is faster than the thin-driver !

guenter




guenter
guenter.porzer@oekb.co.at