Database link and JDBC

From: Paul <thanksdude_at_hotmail.com>
Date: 19 Jan 2004 02:00:28 -0800
Message-ID: <a1a15e72.0401190200.26217ea6@posting.google.com>

Hello all,

I 'm working with 2 databases Oracle v9.2 : DB1 and DB2. I setup a database link from DB1 to DB2. I've created a SP which joins between tableA from DB1 and tableB from DB2.
This sp works fine from an sql+ session on the DB1 server. However, when I'm executing this sp via JDBC (oracle thin driver) from a java app, it triggers an SQLException : ORA-12154 TNS. Could not resolve service name error.
The error line number points to the line in the procedure where tableA and tableB are joined ...

Any ideas ? Received on Mon Jan 19 2004 - 04:00:28 CST