agora inbox for pljava-dev@postgresql.org  

help / color / mirror / Atom feed

[Pljava-dev] java.lang.ClassNotFoundException: org.postgresql.pljava.example.Users
6+ messages / 0 participants
[nested] [flat]

* [Pljava-dev] java.lang.ClassNotFoundException: org.postgresql.pljava.example.Users
@ 2005-03-31 17:17  
  0 siblings, 1 reply; 6+ messages in thread

From:  @ 2005-03-31 17:17 UTC (permalink / raw)

Hi... How can i to run the listSupers() function that is write at userguide 
?
When i type select listSupers() the follow message is showed "
java.lang.ClassNotFoundException: org.postgresql.pljava.example.Users,".
And i try set examples.jar, at Classpath bus doens?t working...
I just to run the example:

" CREATE FUNCTION getsysprop(VARCHAR)
  RETURNS VARCHAR
  AS 'java.lang.System.getProperty'
  LANGUAGE java;

SELECT getsysprop('user.home');"

This function is working ok!

Please, help me...
Antonio Carlos

My enviromment

CLASSPATH=
%CLASSPATH%;deploy.jar;..\jdbc\postgresql-8.0.309.jdbc2.jar;pljava.jar;C:\Arquivos
de programas\PostgreSQL\8.0\pljava\examples.jar

PATH=
C:\j2sdk1.4.2_05\bin;C:\j2sdk1.4.2_05\jre\bin\client;

_________________________________________________________________
Chegou o que faltava: MSN Acesso Gr?tis. Instale J?! 
http://www.msn.com.br/discador





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

* [Pljava-dev] java.lang.ClassNotFoundException: org.postgresql.pljava.example.Users
@ 2005-03-31 18:18  
  parent: 
  0 siblings, 1 reply; 6+ messages in thread

From:  @ 2005-03-31 18:18 UTC (permalink / raw)

Antonio Carlos de Andrade Brito wrote:

> Hi... How can i to run the listSupers() function that is write at 
> userguide ?
> When i type select listSupers() the follow message is showed "
> java.lang.ClassNotFoundException: org.postgresql.pljava.example.Users,".
> And i try set examples.jar, at Classpath bus doens?t working...
> I just to run the example:
>
> " CREATE FUNCTION getsysprop(VARCHAR)
>  RETURNS VARCHAR
>  AS 'java.lang.System.getProperty'
>  LANGUAGE java;
>
> SELECT getsysprop('user.home');"
>
> This function is working ok!
>
> Please, help me...
> Antonio Carlos
>
> My enviromment
>
> CLASSPATH=
> %CLASSPATH%;deploy.jar;..\jdbc\postgresql-8.0.309.jdbc2.jar;pljava.jar;C:\Arquivos 
>
> de programas\PostgreSQL\8.0\pljava\examples.jar
>
> PATH=
> C:\j2sdk1.4.2_05\bin;C:\j2sdk1.4.2_05\jre\bin\client;
>
You need to load the examples.jar into the database using 
sqlj.install_jar. Start psql and enter the following commands:

SELECT 
sqlj.install_jar('file:/C:/Arquivos%20de%20programas/PostgreSQL/8.0/examples.jar', 
'samples', true);
SELECT sqlj.set_classpath('public', 'samples');

That should do it but you should adjust your CLASSPATH also. The 
PostgreSQL backend (the postmaster) should see a CLASSPATH where *only* 
the pljava.jar is listed. Since you use a 8.0, you can set this 
classpath in the postgresql.conf file. The client programs you use 
should *never* see the pljava.jar and they don't need to see 
examples.jar since it's loaded into the database. So, in 
postgresql.conf, enter:

custom_variable_classes = 'pljava'
pljava.classpath = '<full path to pljava.jar>'

The full path must use escaped backslashes, i.e. '\\' since 
postgresql.conf will treat backslash as an escape in itself.

Regards,
Thomas Hallgren





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

* [Pljava-dev] java.lang.ClassNotFoundException: org.postgresql.pljava.example
@ 2005-03-31 18:30  
  parent: 
  0 siblings, 1 reply; 6+ messages in thread

From:  @ 2005-03-31 18:30 UTC (permalink / raw)

Thomas, the first setep ok... 
sqlj.install_jar('file:/C:/Arquivos%20de%20programas/PostgreSQL/8.0/examples.jar',
>'samples', true);

But, when i try SELECT sqlj.set_classpath('public', 'samples'); the follow 
ERROR message is showed "ERROR:  java.sql.SQLException: No such jar: 
samples"

Antonio Carlos



>From: Thomas Hallgren <thhal at mailblocks.com>
>To: Antonio Carlos de Andrade Brito <acabhgg at hotmail.com>
>CC: pljava-dev at gborg.postgresql.org
>Subject: Re: [Pljava-dev] 	java.lang.ClassNotFoundException: 
>org.postgresql.pljava.example.Users
>Date: Thu, 31 Mar 2005 20:18:53 +0200
>
>Antonio Carlos de Andrade Brito wrote:
>
>>Hi... How can i to run the listSupers() function that is write at 
>>userguide ?
>>When i type select listSupers() the follow message is showed "
>>java.lang.ClassNotFoundException: org.postgresql.pljava.example.Users,".
>>And i try set examples.jar, at Classpath bus doens?t working...
>>I just to run the example:
>>
>>" CREATE FUNCTION getsysprop(VARCHAR)
>>  RETURNS VARCHAR
>>  AS 'java.lang.System.getProperty'
>>  LANGUAGE java;
>>
>>SELECT getsysprop('user.home');"
>>
>>This function is working ok!
>>
>>Please, help me...
>>Antonio Carlos
>>
>>My enviromment
>>
>>CLASSPATH=
>>%CLASSPATH%;deploy.jar;..\jdbc\postgresql-8.0.309.jdbc2.jar;pljava.jar;C:\Arquivos
>>
>>de programas\PostgreSQL\8.0\pljava\examples.jar
>>
>>PATH=
>>C:\j2sdk1.4.2_05\bin;C:\j2sdk1.4.2_05\jre\bin\client;
>>
>You need to load the examples.jar into the database using sqlj.install_jar. 
>Start psql and enter the following commands:
>
>SELECT 
>sqlj.install_jar('file:/C:/Arquivos%20de%20programas/PostgreSQL/8.0/examples.jar', 
>'samples', true);
>SELECT sqlj.set_classpath('public', 'samples');
>
>That should do it but you should adjust your CLASSPATH also. The PostgreSQL 
>backend (the postmaster) should see a CLASSPATH where *only* the pljava.jar 
>is listed. Since you use a 8.0, you can set this classpath in the 
>postgresql.conf file. The client programs you use should *never* see the 
>pljava.jar and they don't need to see examples.jar since it's loaded into 
>the database. So, in postgresql.conf, enter:
>
>custom_variable_classes = 'pljava'
>pljava.classpath = '<full path to pljava.jar>'
>
>The full path must use escaped backslashes, i.e. '\\' since postgresql.conf 
>will treat backslash as an escape in itself.
>
>Regards,
>Thomas Hallgren
>

_________________________________________________________________
Chegou o que faltava: MSN Acesso Gr?tis. Instale J?! 
http://www.msn.com.br/discador





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

* [Pljava-dev] java.lang.ClassNotFoundException:	org.postgresql.pljava.example
@ 2005-03-31 18:34  
  parent: 
  0 siblings, 2 replies; 6+ messages in thread

From:  @ 2005-03-31 18:34 UTC (permalink / raw)

Antonio Carlos de Andrade Brito wrote:

> Thomas, the first setep ok... 
> sqlj.install_jar('file:/C:/Arquivos%20de%20programas/PostgreSQL/8.0/examples.jar', 
>
>
>> 'samples', true);
>
>
> But, when i try SELECT sqlj.set_classpath('public', 'samples'); the 
> follow ERROR message is showed "ERROR:  java.sql.SQLException: No such 
> jar: samples"

In that case, something must have gone wrong with sqlj.install_jar and 
'samples' was the name you used as the second argument to install_jar. 
Did you get an error when you executed the sqlj.install_jar?

- thomas





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

* [Pljava-dev] java.lang.ClassNotFoundException: org.postgresql.pljava.example
@ 2005-03-31 18:37  
  parent: 
  1 sibling, 0 replies; 6+ messages in thread

From:  @ 2005-03-31 18:37 UTC (permalink / raw)


No,
any error...

Antonio
>From: Thomas Hallgren <thhal at mailblocks.com>
>To: Antonio Carlos de Andrade Brito <acabhgg at hotmail.com>
>CC: pljava-dev at gborg.postgresql.org
>Subject: Re: [Pljava-dev] 
>java.lang.ClassNotFoundException:	org.postgresql.pljava.example
>Date: Thu, 31 Mar 2005 20:34:17 +0200
>
>Antonio Carlos de Andrade Brito wrote:
>
>>Thomas, the first setep ok... 
>>sqlj.install_jar('file:/C:/Arquivos%20de%20programas/PostgreSQL/8.0/examples.jar',
>>
>>
>>>'samples', true);
>>
>>
>>But, when i try SELECT sqlj.set_classpath('public', 'samples'); the follow 
>>ERROR message is showed "ERROR:  java.sql.SQLException: No such jar: 
>>samples"
>
>In that case, something must have gone wrong with sqlj.install_jar and 
>'samples' was the name you used as the second argument to install_jar. Did 
>you get an error when you executed the sqlj.install_jar?
>
>- thomas
>

_________________________________________________________________
Chegou o que faltava: MSN Acesso Gr?tis. Instale J?! 
http://www.msn.com.br/discador





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

* [Pljava-dev] java.lang.ClassNotFoundException: org.postgresql.pljava.example
@ 2005-03-31 18:42  
  parent: 
  1 sibling, 0 replies; 6+ messages in thread

From:  @ 2005-03-31 18:42 UTC (permalink / raw)

Ok... Ok... You are right!!!
I?m dropped e create again, the javates and now is right..
Thanks..

Antonio Carlos

>From: Thomas Hallgren <thhal at mailblocks.com>
>To: Antonio Carlos de Andrade Brito <acabhgg at hotmail.com>
>CC: pljava-dev at gborg.postgresql.org
>Subject: Re: [Pljava-dev] 
>java.lang.ClassNotFoundException:	org.postgresql.pljava.example
>Date: Thu, 31 Mar 2005 20:34:17 +0200
>
>Antonio Carlos de Andrade Brito wrote:
>
>>Thomas, the first setep ok... 
>>sqlj.install_jar('file:/C:/Arquivos%20de%20programas/PostgreSQL/8.0/examples.jar',
>>
>>
>>>'samples', true);
>>
>>
>>But, when i try SELECT sqlj.set_classpath('public', 'samples'); the follow 
>>ERROR message is showed "ERROR:  java.sql.SQLException: No such jar: 
>>samples"
>
>In that case, something must have gone wrong with sqlj.install_jar and 
>'samples' was the name you used as the second argument to install_jar. Did 
>you get an error when you executed the sqlj.install_jar?
>
>- thomas
>

_________________________________________________________________
MSN Messenger: converse online com seus amigos .  
http://messenger.msn.com.br





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

end of thread, other threads:[~2005-03-31 18:42 UTC | newest]

Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-03-31 17:17 [Pljava-dev] java.lang.ClassNotFoundException: org.postgresql.pljava.example.Users 
2005-03-31 18:18 ` 
2005-03-31 18:30   ` [Pljava-dev] java.lang.ClassNotFoundException: org.postgresql.pljava.example 
2005-03-31 18:34     ` [Pljava-dev] java.lang.ClassNotFoundException:	org.postgresql.pljava.example 
2005-03-31 18:37       ` [Pljava-dev] java.lang.ClassNotFoundException: org.postgresql.pljava.example 
2005-03-31 18:42       ` [Pljava-dev] java.lang.ClassNotFoundException: org.postgresql.pljava.example 

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