From: acabhgg at hotmail.com (Antonio Carlos de Andrade Brito)
Date: Thu, 31 Mar 2005 15:30:58 -0300
Subject: [Pljava-dev] java.lang.ClassNotFoundException:
	org.postgresql.pljava.example
In-Reply-To: <424C3F0D.4020906@mailblocks.com>
Message-ID: <BAY12-F175DF89374147EA5261F91A6470@phx.gbl>

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