agora inbox for pljava-dev@postgresql.org
help / color / mirror / Atom feedSubject: [Pljava-dev] java.lang.ClassNotFoundException: org.postgresql.pljava.example
Date: Thu, 31 Mar 2005 15:30:58 -0300
Message-ID: <BAY12-F175DF89374147EA5261F91A6470@phx.gbl> (raw)
In-Reply-To: <424C3F0D.4020906@mailblocks.com>
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
view thread (6+ messages) latest in thread
Message-ID: <BAY12-F175DF89374147EA5261F91A6470@phx.gbl>
Permalink: ../BAY12-F175DF89374147EA5261F91A6470@phx.gbl/
Also on: postgresql.org/message-id/BAY12-F175DF89374147EA5261F91A6470@phx.gbl
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pljava-dev@postgresql.org
Subject: Re: [Pljava-dev] java.lang.ClassNotFoundException: org.postgresql.pljava.example
In-Reply-To: <BAY12-F175DF89374147EA5261F91A6470@phx.gbl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox