jdbc on hp with oracle 8.1.6 drivers

From: <x3x3_at_my-deja.com>
Date: 2000/07/25
Message-ID: <8ll96j$fsg$1@nnrp1.deja.com>#1/1

Hello,

On nt I have jdk1.2.2, oracle 8.1.6 driver with classes111.zip which can connect to oracle database on hp machine. Now I go to hp unix m/c and try to run with classes111.zip with hp jdk 1.18 I am unable to get it to work. It either gives sql exception (connection refused) or when I use connect string with all parentheses like one in tnsnames.ora it says sid information is missing. I am using same form of url as on nt.

any clue?

please reply miten_s_mehta_at_hotmail.com

Here is url style works on nt and not on hp.

String url = "jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=
(PROTOCOL=TCP)(HOST=hpat537.atl.hp.com)(PORT=1521)))(CONNECT_DATA=
(SERVICE_NAME=QPDEV)))";

String query = "SELECT * FROM transaction";

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Jul 25 2000 - 00:00:00 CDT