[Pljava-dev] cannot set the classpath to a specific jar to get an external connection

From: fluca1978 at infinito(dot)it (Luca Ferrari)
To:
Subject: [Pljava-dev] cannot set the classpath to a specific jar to get an external connection
Date: 2010-06-03 08:52:32
Message-ID: 201006031052.33192.fluca1978@infinito.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pljava-dev

Hi all,
not sure if what I'd like to do is possible, but I'd like to use JDBC within a
pl/java function to extract data from another database (something similar to
dbilink). However if I try to change the connection to another URL rather that
"jdbc:default:connection" I got an error saying there is no suitable driver,
so I tried to add explicitly the postgresql jar to the schema, but the
following fails:

select sqlj.set_classpath('public',
'/java/jars/postgresql-8.4-701.jdbc4.jar');
ERROR: java.sql.SQLException: No such jar:
/java/jars/postgresql-8.4-701.jdbc4.jar

So my questions are:
1) what am I missing in setting the classpath?
2) is it possible to open a connection to another database cluster?

Thanks,
Luca

Responses

Browse pljava-dev by date

  From Date Subject
Next Message Roberts, Jon 2010-06-03 12:15:30 [Pljava-dev] cannot set the classpath to a specific jar to get anexternal connection
Previous Message Luca Ferrari 2010-06-03 06:41:03 [Pljava-dev] problem deploying pljava