[Pljava-dev] execute pl/java function

From: william(dot)ferreira at airbus(dot)com (FERREIRA William (COFRAMI))
To:
Subject: [Pljava-dev] execute pl/java function
Date: 2005-02-15 15:46:29
Message-ID: 1904E3EB39448246A7ECB76DF34A70B00143B407@TOCOMEXC03
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pljava-dev

hi

i downloaded pl/java for postgresql 8.0 and install it.
i wrote 2 functions and i would like to call them by a function :

this is my call :
select adoc_java.flushInFile('c:\\toto.txt', 'titi');

in result i got this error and i don't understand why:
ERROR: java.lang.ClassNotFoundException: com.xxxxxx.adoc.util.ADOCFileUtil

here is my installation sequence :
SELECT sqlj.install_jar('file:///Opt/PostgreSQL/8.0.0/pljava/ADOC_JAVA.jar',
'javapa', true);
SELECT sqlj.set_classpath('adoc_java', 'javapa');

if somebody can help me
thanks in advance

William Ferreira

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20050215/e265c98d/attachment.html>

Responses

Browse pljava-dev by date

  From Date Subject
Next Message Thomas Hallgren 2005-02-15 17:38:11 [Pljava-dev] execute pl/java function
Previous Message Victor 2005-02-14 19:11:20 [Pljava-dev] java.sql.SQLException: ERROR: could not load library "/usr/local/pgsql/lib/libpljava.so": libjvm.so