Database link and JDBC

Giganews Newsgroups
Subject: Database link and JDBC
Posted by:  thanksdu…@hotmail.com
Date: 19 Jan 2004

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 ?

Replies