agora inbox for pljava-dev@postgresql.org  

help / color / mirror / Atom feed

[Pljava-dev] execute pl/java function
3+ messages / 0 participants
[nested] [flat]

* [Pljava-dev] execute pl/java function
@ 2005-02-15 15:46  
  0 siblings, 2 replies; 3+ messages in thread

From:  @ 2005-02-15 15:46 UTC (permalink / raw)

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;



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* [Pljava-dev] execute pl/java function
@ 2005-02-15 17:38  
  parent: 
  1 sibling, 0 replies; 3+ messages in thread

From:  @ 2005-02-15 17:38 UTC (permalink / raw)

FERREIRA William (COFRAMI) wrote:

> 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' 
> <file:///Opt/PostgreSQL/8.0.0/pljava/ADOC_JAVA.jar%27>, 'javapa',  true);
> SELECT sqlj.set_classpath('adoc_java', 'javapa');
>
> if somebody can help me
> thanks in advance
>
I assume that you somehow have issued a commit after the 
sqlj.install_jar and sqlj.set_classpath commands?

If you have, then the same apply as in any Java environment. Either 
you've misspelled the name of the class (or package) or you don't have a 
compiled class file by that name in the jar file. Do a jar -tf on the 
jar file and verify that the class really is in there. Also verify that 
the class is public.

Hope this helps,

Thomas Hallgren








^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* [Pljava-dev] execute pl/java function
@ 2005-02-15 17:38  
  parent: 
  1 sibling, 0 replies; 3+ messages in thread

From:  @ 2005-02-15 17:38 UTC (permalink / raw)

FERREIRA William (COFRAMI) wrote:
> in result i got this error and i don't understand why:
> ERROR:  java.lang.ClassNotFoundException: com.xxxxxx.adoc.util.ADOCFileUtil
> 

I'm sorry I couldn't resist: what is with the xxxxxx in the class name 
above ?

-- 
Radu-Adrian Popescu
CSA, DBA, Developer
Aldrapay MD
Aldratech Ltd.
+40213212243
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 3206 bytes
Desc: S/MIME Cryptographic Signature
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20050215/3d1833b0/attachment.bin;



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

end of thread, other threads:[~2005-02-15 17:38 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-02-15 15:46 [Pljava-dev] execute pl/java function 
2005-02-15 17:38 ` 
2005-02-15 17:38 ` 

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox