Re: JAVA CONNECTIONS

From: Peter Sylvester <peters_at_mitre.org>
Date: Mon, 12 Sep 2005 17:03:38 -0400
Message-ID: <4325ED2A.8050303@mitre.org>

Dick,

To expand upon Carel-Jan, you need to change the JDBC URL to be something like "jdbc:oracle:oci:@MyTnsAlias". You'll also need to have the OCI library directory in your PATH (Windoze) or LD_LIBRARY_PATH (*nix).
You may need some other environmental stuff, like ORACLE_HOME and TNS_ADMIN as well.

Most Java folk tend to use the "thin" driver, as it needs no other client side libraries or environment, just the host, port and SID, which go right into the URL string.

--Peter

--

http://www.freelists.org/webpage/oracle-l Received on Mon Sep 12 2005 - 16:08:35 CDT