agora inbox for pljava-dev@postgresql.org  
help / color / mirror / Atom feed
[Pljava-dev] [Fwd: Unable to load class org/postgresql/plsql/internal/Backend]
14+ messages / 0 participants
[nested] [flat]

* [Pljava-dev] [Fwd: Unable to load class org/postgresql/plsql/internal/Backend]
@ 2005-06-07 23:11  
  0 siblings, 1 reply; 14+ messages in thread

From:  @ 2005-06-07 23:11 UTC (permalink / raw)


-------------- next part --------------
An embedded message was scrubbed...
From: Michael Judd <michael.judd at jaztek.co.uk>
Subject: Unable to load class org/postgresql/plsql/internal/Backend
Date: Tue, 07 Jun 2005 23:46:25 +0100
Size: 1232
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20050608/105ec05e/attachment.mht;



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

* [Pljava-dev] [Fwd: Unable to load class	org/postgresql/plsql/internal/Backend]
@ 2005-06-07 23:16  
  parent: 
  0 siblings, 2 replies; 14+ messages in thread

From:  @ 2005-06-07 23:16 UTC (permalink / raw)

Michael

You said you were having trouble installing plsql. Do you mean pljava?

Be sure you also have LD_LIBRARY_PATH set with the same values.

Once the library path is established in both places (LD_LIBRARY_PATH) 
and postgresql.conf) I found that restarting postgres before trying to 
install pljava solved the problem.

Michael Judd wrote:

>
> ------------------------------------------------------------------------
>
> Subject:
> Unable to load class org/postgresql/plsql/internal/Backend
> From:
> Michael Judd <michael.judd at jaztek.co.uk>
> Date:
> Tue, 07 Jun 2005 23:46:25 +0100
> To:
> pljava-dev at gborg.postgresql.org
>
> To:
> pljava-dev at gborg.postgresql.org
>
>
>Hi,
>
>I'm having trouble installing plsql and I'm getting the following:
>
>Unable to load class org/postgresql/plsql/internal/Backend using
>CLASSPATH '-Djava.class.path=/opt/pgsql/pljava/build.pljava.jar'
>
>when issuing the command to pgsql:
>
>SELECT sqlj.install_jar('file://opt/pgsql/lib/sqlj.jar','sqlj',true);
>
>I have checked that:
>- pljava.jar is in /opt/pgsql/pljava/build
>- sqlj.jar is in  /opt/pgsql/lib
>
>in my postgres.conf I have dynamic_library_path = '/opt/pgsql/lib:
>$libdir' where libpljava.so, plpgsql.so resides.
>
>my paths are:
> - postgres /opt/pgsql
> - pljava /opt/pgsql/pljava
> - data /opt/pgsql/pg_data
>
>Fedora Core 3 x86_64smp
>
>I've double checked that Backend is located in the jar exactly where it
>is supposed to be - so the error being displayed doesn't seem to point
>in the 'right' direction.
>
>Any ideas ?
>
>
>
>
>
>  
>
>------------------------------------------------------------------------
>
>_______________________________________________
>Pljava-dev mailing list
>Pljava-dev at gborg.postgresql.org
>http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>  
>

-- 
Vince Clark
Global Era
The freedom of open source.
(303) 493-6723
(303) 455-2409 fax
vclark at globalera.com <mailto:vclark at globalera.com>
www.globalera.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20050607/28c2dbc4/attachment.html;



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

* [Pljava-dev] [Fwd: Unable to load class	org/postgresql/plsql/internal/Backend]
@ 2005-06-08 00:27  
  parent: 
  1 sibling, 1 reply; 14+ messages in thread

From:  @ 2005-06-08 00:27 UTC (permalink / raw)

Hi,

At your recommendation I changed my LD_LIBRARY_PATH (via /etc/profile)
to /usr/java/jdk1.5.0_03/jre/lib:/usr/java/jdk1.5.0_03/jre/lib/server:/usr/java/jdk1.5.0_03/jre/lib/native_threads:/opt/pgsql/lib
This now matches my dynamic_library_path in postgresql.conf
in /opt/pgsql/pg_data (or should I use this in my pljava.classpath ?

I'm still getting exactly the same problem.

Thanks for your help.



On Tue, 2005-06-07 at 17:16 -0600, Vince Clark wrote:
> Michael
> 
> You said you were having trouble installing plsql. Do you mean pljava?
> 
> Be sure you also have LD_LIBRARY_PATH set with the same values. 
> 
> Once the library path is established in both places (LD_LIBRARY_PATH)
> and postgresql.conf) I found that restarting postgres before trying to
> install pljava solved the problem.
> 
> Michael Judd wrote: 
> > 
> > 
> > ____________________________________________________________________
> > 
> > Subject:  Unable to load class org/postgresql/plsql/internal/Backend
> > From:  Michael Judd <michael.judd at jaztek.co.uk>
> > Date:  Tue, 07 Jun 2005 23:46:25 +0100
> > To:  pljava-dev at gborg.postgresql.org
> > To:  pljava-dev at gborg.postgresql.org
> > 
> > Hi,
> > 
> > I'm having trouble installing plsql and I'm getting the following:
> > 
> > Unable to load class org/postgresql/plsql/internal/Backend using
> > CLASSPATH '-Djava.class.path=/opt/pgsql/pljava/build.pljava.jar'
> > 
> > when issuing the command to pgsql:
> > 
> > SELECT sqlj.install_jar('file://opt/pgsql/lib/sqlj.jar','sqlj',true);
> > 
> > I have checked that:
> > - pljava.jar is in /opt/pgsql/pljava/build
> > - sqlj.jar is in  /opt/pgsql/lib
> > 
> > in my postgres.conf I have dynamic_library_path = '/opt/pgsql/lib:
> > $libdir' where libpljava.so, plpgsql.so resides.
> > 
> > my paths are:
> >  - postgres /opt/pgsql
> >  - pljava /opt/pgsql/pljava
> >  - data /opt/pgsql/pg_data
> > 
> > Fedora Core 3 x86_64smp
> > 
> > I've double checked that Backend is located in the jar exactly where it
> > is supposed to be - so the error being displayed doesn't seem to point
> > in the 'right' direction.
> > 
> > Any ideas ?
> > 
> > 
> > 
> > 
> > 
> >   
> > 
> > ____________________________________________________________________
> > 
> > _______________________________________________
> > Pljava-dev mailing list
> > Pljava-dev at gborg.postgresql.org
> > http://gborg.postgresql.org/mailman/listinfo/pljava-dev
> >   
> 
> -- 
> Vince Clark 
> Global Era 
> The freedom of open source. 
> (303) 493-6723 
> (303) 455-2409 fax 
> vclark at globalera.com 
> www.globalera.com






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

* [Pljava-dev] [Fwd: Unable to load	class	org/postgresql/plsql/internal/Backend]
@ 2005-06-08 01:08  
  parent: 
  0 siblings, 2 replies; 14+ messages in thread

From:  @ 2005-06-08 01:08 UTC (permalink / raw)

Here is my dynamic_library_path in postgresql.conf
dynamic_library_path = 
'/usr/lib64/:/home/java/j2sdk1.4.2/jre/lib/amd64/server/'

Note that I am running an AMD64 so things will look slightly different. 
The key in this line is that this path points to a directory that 
contains a file called libjvm.so. In some JVM's I have seen that file 
under jre/lib/client (rather than /server)

Here is what my LD_LIBRARY_PATH looks like:
LD_LIBRARY_PATH=/usr/lib64/:/home/java/j2sdk1.4.2/jre/lib/amd64/server/ 
export LD_LIBRARY_PATH

In my case the pljava build placed pljava.so.1.1 in /usr/lib64 and 
created soft links with the proper file name of pljava.so

Also, you may run into another problem once you get past the library 
path issue. I was unable to install pljava using a 1.5.x JDK. I ended up 
using Blackdown 1.4.2. It has something to do with being able to spawn a 
VM from within Postgres. I don't remember exactly.

Finally, I'm serious about restarting postgres. I did two installations 
where the path settings were right but I had to restart postgres before 
I could successfully add pljava as a language in the database.

Michael Judd wrote:

>Hi,
>
>At your recommendation I changed my LD_LIBRARY_PATH (via /etc/profile)
>to /usr/java/jdk1.5.0_03/jre/lib:/usr/java/jdk1.5.0_03/jre/lib/server:/usr/java/jdk1.5.0_03/jre/lib/native_threads:/opt/pgsql/lib
>This now matches my dynamic_library_path in postgresql.conf
>in /opt/pgsql/pg_data (or should I use this in my pljava.classpath ?
>
>I'm still getting exactly the same problem.
>
>Thanks for your help.
>
>
>
>On Tue, 2005-06-07 at 17:16 -0600, Vince Clark wrote:
>  
>
>>Michael
>>
>>You said you were having trouble installing plsql. Do you mean pljava?
>>
>>Be sure you also have LD_LIBRARY_PATH set with the same values. 
>>
>>Once the library path is established in both places (LD_LIBRARY_PATH)
>>and postgresql.conf) I found that restarting postgres before trying to
>>install pljava solved the problem.
>>
>>Michael Judd wrote: 
>>    
>>
>>>____________________________________________________________________
>>>
>>>Subject:  Unable to load class org/postgresql/plsql/internal/Backend
>>>From:  Michael Judd <michael.judd at jaztek.co.uk>
>>>Date:  Tue, 07 Jun 2005 23:46:25 +0100
>>>To:  pljava-dev at gborg.postgresql.org
>>>To:  pljava-dev at gborg.postgresql.org
>>>
>>>Hi,
>>>
>>>I'm having trouble installing plsql and I'm getting the following:
>>>
>>>Unable to load class org/postgresql/plsql/internal/Backend using
>>>CLASSPATH '-Djava.class.path=/opt/pgsql/pljava/build.pljava.jar'
>>>
>>>when issuing the command to pgsql:
>>>
>>>SELECT sqlj.install_jar('file://opt/pgsql/lib/sqlj.jar','sqlj',true);
>>>
>>>I have checked that:
>>>- pljava.jar is in /opt/pgsql/pljava/build
>>>- sqlj.jar is in  /opt/pgsql/lib
>>>
>>>in my postgres.conf I have dynamic_library_path = '/opt/pgsql/lib:
>>>$libdir' where libpljava.so, plpgsql.so resides.
>>>
>>>my paths are:
>>> - postgres /opt/pgsql
>>> - pljava /opt/pgsql/pljava
>>> - data /opt/pgsql/pg_data
>>>
>>>Fedora Core 3 x86_64smp
>>>
>>>I've double checked that Backend is located in the jar exactly where it
>>>is supposed to be - so the error being displayed doesn't seem to point
>>>in the 'right' direction.
>>>
>>>Any ideas ?
>>>
>>>
>>>
>>>
>>>
>>>  
>>>
>>>____________________________________________________________________
>>>
>>>_______________________________________________
>>>Pljava-dev mailing list
>>>Pljava-dev at gborg.postgresql.org
>>>http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>>>  
>>>      
>>>
>>-- 
>>Vince Clark 
>>Global Era 
>>The freedom of open source. 
>>(303) 493-6723 
>>(303) 455-2409 fax 
>>vclark at globalera.com 
>>www.globalera.com
>>    
>>
>
>  
>

-- 
Vince Clark
Global Era
The freedom of open source.
(303) 493-6723
(303) 455-2409 fax
vclark at globalera.com <mailto:vclark at globalera.com>
www.globalera.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20050607/74be5cd4/attachment.html;



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

* [Pljava-dev] Re: [Fwd: Unable to load class org/postgresql/plsql/internal/Backend]
@ 2005-06-08 06:29  
  parent: 
  0 siblings, 1 reply; 14+ messages in thread

From:  @ 2005-06-08 06:29 UTC (permalink / raw)

Michael,
If you get so far that a complaint about "Unable to load class" is 
issued, then your LD_LIBRARY_PATH and dynamic_library_path are both 
correct. Your problem is in the CLASSPATH. It ends with 
"build.pljava.jar", i.e. you have a dot before pljava.jar. It should end 
with "build/pljava.jar".

Regards,
Thomas Hallgren


Vince Clark wrote:
> Michael
> 
> You said you were having trouble installing plsql. Do you mean pljava?
> 
> Be sure you also have LD_LIBRARY_PATH set with the same values.
> 
> Once the library path is established in both places (LD_LIBRARY_PATH) 
> and postgresql.conf) I found that restarting postgres before trying to 
> install pljava solved the problem.
> 
> Michael Judd wrote:
> 
>>
>> ------------------------------------------------------------------------
>>
>> Subject:
>> Unable to load class org/postgresql/plsql/internal/Backend
>> From:
>> Michael Judd <michael.judd at jaztek.co.uk>
>> Date:
>> Tue, 07 Jun 2005 23:46:25 +0100
>> To:
>> pljava-dev at gborg.postgresql.org
>>
>> To:
>> pljava-dev at gborg.postgresql.org
>>
>>
>>Hi,
>>
>>I'm having trouble installing plsql and I'm getting the following:
>>
>>Unable to load class org/postgresql/plsql/internal/Backend using
>>CLASSPATH '-Djava.class.path=/opt/pgsql/pljava/build.pljava.jar'
>>
>>when issuing the command to pgsql:
>>
>>SELECT sqlj.install_jar('file://opt/pgsql/lib/sqlj.jar','sqlj',true);
>>
>>I have checked that:
>>- pljava.jar is in /opt/pgsql/pljava/build
>>- sqlj.jar is in  /opt/pgsql/lib
>>
>>in my postgres.conf I have dynamic_library_path = '/opt/pgsql/lib:
>>$libdir' where libpljava.so, plpgsql.so resides.
>>
>>my paths are:
>> - postgres /opt/pgsql
>> - pljava /opt/pgsql/pljava
>> - data /opt/pgsql/pg_data
>>
>>Fedora Core 3 x86_64smp
>>
>>I've double checked that Backend is located in the jar exactly where it
>>is supposed to be - so the error being displayed doesn't seem to point
>>in the 'right' direction.
>>
>>Any ideas ?
>>
>>
>>
>>
>>
>>  
>>
>>------------------------------------------------------------------------
>>
>>_______________________________________________
>>Pljava-dev mailing list
>>Pljava-dev at gborg.postgresql.org
>>http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>>  
>>
> 
> -- 
> Vince Clark
> Global Era
> The freedom of open source.
> (303) 493-6723
> (303) 455-2409 fax
> vclark at globalera.com <mailto:vclark at globalera.com>
> www.globalera.com
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/pljava-dev






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

* [Pljava-dev] Re: [Fwd: Unable to load class org/postgresql/plsql/internal/Backend]
@ 2005-06-08 06:29  
  parent: 
  1 sibling, 1 reply; 14+ messages in thread

From:  @ 2005-06-08 06:29 UTC (permalink / raw)

Michael,
If you get so far that a complaint about "Unable to load class" is 
issued, then your LD_LIBRARY_PATH and dynamic_library_path are both 
correct. Your problem is in the CLASSPATH. It ends with 
"build.pljava.jar", i.e. you have a dot before pljava.jar. It should end 
with "build/pljava.jar".

Regards,
Thomas Hallgren


Vince Clark wrote:
> Michael
> 
> You said you were having trouble installing plsql. Do you mean pljava?
> 
> Be sure you also have LD_LIBRARY_PATH set with the same values.
> 
> Once the library path is established in both places (LD_LIBRARY_PATH) 
> and postgresql.conf) I found that restarting postgres before trying to 
> install pljava solved the problem.
> 
> Michael Judd wrote:
> 
>>
>> ------------------------------------------------------------------------
>>
>> Subject:
>> Unable to load class org/postgresql/plsql/internal/Backend
>> From:
>> Michael Judd <michael.judd at jaztek.co.uk>
>> Date:
>> Tue, 07 Jun 2005 23:46:25 +0100
>> To:
>> pljava-dev at gborg.postgresql.org
>>
>> To:
>> pljava-dev at gborg.postgresql.org
>>
>>
>>Hi,
>>
>>I'm having trouble installing plsql and I'm getting the following:
>>
>>Unable to load class org/postgresql/plsql/internal/Backend using
>>CLASSPATH '-Djava.class.path=/opt/pgsql/pljava/build.pljava.jar'
>>
>>when issuing the command to pgsql:
>>
>>SELECT sqlj.install_jar('file://opt/pgsql/lib/sqlj.jar','sqlj',true);
>>
>>I have checked that:
>>- pljava.jar is in /opt/pgsql/pljava/build
>>- sqlj.jar is in  /opt/pgsql/lib
>>
>>in my postgres.conf I have dynamic_library_path = '/opt/pgsql/lib:
>>$libdir' where libpljava.so, plpgsql.so resides.
>>
>>my paths are:
>> - postgres /opt/pgsql
>> - pljava /opt/pgsql/pljava
>> - data /opt/pgsql/pg_data
>>
>>Fedora Core 3 x86_64smp
>>
>>I've double checked that Backend is located in the jar exactly where it
>>is supposed to be - so the error being displayed doesn't seem to point
>>in the 'right' direction.
>>
>>Any ideas ?
>>
>>
>>
>>
>>
>>  
>>
>>------------------------------------------------------------------------
>>
>>_______________________________________________
>>Pljava-dev mailing list
>>Pljava-dev at gborg.postgresql.org
>>http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>>  
>>
> 
> -- 
> Vince Clark
> Global Era
> The freedom of open source.
> (303) 493-6723
> (303) 455-2409 fax
> vclark at globalera.com <mailto:vclark at globalera.com>
> www.globalera.com
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/pljava-dev





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

* [Pljava-dev] [Fwd: Unable to load	class	org/postgresql/plsql/internal/Backend]
@ 2005-06-08 07:08  
  parent: 
  1 sibling, 2 replies; 14+ messages in thread

From:  @ 2005-06-08 07:08 UTC (permalink / raw)

pljava placed my pljava.so.1.1 in /opt/pgsql/lib so I've used that
instead of your /usr/lib64

I still have the same issue.  I have restarted - I'm running it in a
shell at the moment and I've closed the shell to ensure that the
environment is reset and the started up postgres again with:

pg_ctl start -D /opt/pgsql/pg_data -l /var/log/pgsql.log -o "-i"

The log file confirms this.

The problem may well be as you suggest java 1.5

I'll try blackdown as I'm on dual opterons (amd64 too) which is the
reason I didn't go with java1.4 to start.

Thanks again for you help.

Mike

On Tue, 2005-06-07 at 19:08 -0600, Vince Clark wrote:
> Here is my dynamic_library_path in postgresql.conf
> dynamic_library_path =
> '/usr/lib64/:/home/java/j2sdk1.4.2/jre/lib/amd64/server/'
> 
> Note that I am running an AMD64 so things will look slightly
> different. The key in this line is that this path points to a
> directory that contains a file called libjvm.so. In some JVM's I have
> seen that file under jre/lib/client (rather than /server)
> 
> Here is what my LD_LIBRARY_PATH looks like:
> LD_LIBRARY_PATH=/usr/lib64/:/home/java/j2sdk1.4.2/jre/lib/amd64/server/ export LD_LIBRARY_PATH
> 
> In my case the pljava build placed pljava.so.1.1 in /usr/lib64 and
> created soft links with the proper file name of pljava.so
> 
> Also, you may run into another problem once you get past the library
> path issue. I was unable to install pljava using a 1.5.x JDK. I ended
> up using Blackdown 1.4.2. It has something to do with being able to
> spawn a VM from within Postgres. I don't remember exactly.
> 
> Finally, I'm serious about restarting postgres. I did two
> installations where the path settings were right but I had to restart
> postgres before I could successfully add pljava as a language in the
> database.
> 
> Michael Judd wrote: 
> > Hi,
> > 
> > At your recommendation I changed my LD_LIBRARY_PATH (via /etc/profile)
> > to /usr/java/jdk1.5.0_03/jre/lib:/usr/java/jdk1.5.0_03/jre/lib/server:/usr/java/jdk1.5.0_03/jre/lib/native_threads:/opt/pgsql/lib
> > This now matches my dynamic_library_path in postgresql.conf
> > in /opt/pgsql/pg_data (or should I use this in my pljava.classpath ?
> > 
> > I'm still getting exactly the same problem.
> > 
> > Thanks for your help.
> > 
> > 
> > 
> > On Tue, 2005-06-07 at 17:16 -0600, Vince Clark wrote:
> >   
> > > Michael
> > > 
> > > You said you were having trouble installing plsql. Do you mean pljava?
> > > 
> > > Be sure you also have LD_LIBRARY_PATH set with the same values. 
> > > 
> > > Once the library path is established in both places (LD_LIBRARY_PATH)
> > > and postgresql.conf) I found that restarting postgres before trying to
> > > install pljava solved the problem.
> > > 
> > > Michael Judd wrote: 
> > >     
> > > > ____________________________________________________________________
> > > > 
> > > > Subject:  Unable to load class org/postgresql/plsql/internal/Backend
> > > > From:  Michael Judd <michael.judd at jaztek.co.uk>
> > > > Date:  Tue, 07 Jun 2005 23:46:25 +0100
> > > > To:  pljava-dev at gborg.postgresql.org
> > > > To:  pljava-dev at gborg.postgresql.org
> > > > 
> > > > Hi,
> > > > 
> > > > I'm having trouble installing plsql and I'm getting the following:
> > > > 
> > > > Unable to load class org/postgresql/plsql/internal/Backend using
> > > > CLASSPATH '-Djava.class.path=/opt/pgsql/pljava/build.pljava.jar'
> > > > 
> > > > when issuing the command to pgsql:
> > > > 
> > > > SELECT sqlj.install_jar('file://opt/pgsql/lib/sqlj.jar','sqlj',true);
> > > > 
> > > > I have checked that:
> > > > - pljava.jar is in /opt/pgsql/pljava/build
> > > > - sqlj.jar is in  /opt/pgsql/lib
> > > > 
> > > > in my postgres.conf I have dynamic_library_path = '/opt/pgsql/lib:
> > > > $libdir' where libpljava.so, plpgsql.so resides.
> > > > 
> > > > my paths are:
> > > >  - postgres /opt/pgsql
> > > >  - pljava /opt/pgsql/pljava
> > > >  - data /opt/pgsql/pg_data
> > > > 
> > > > Fedora Core 3 x86_64smp
> > > > 
> > > > I've double checked that Backend is located in the jar exactly where it
> > > > is supposed to be - so the error being displayed doesn't seem to point
> > > > in the 'right' direction.
> > > > 
> > > > Any ideas ?
> > > > 
> > > > 
> > > > 
> > > > 
> > > > 
> > > >   
> > > > 
> > > > ____________________________________________________________________
> > > > 
> > > > _______________________________________________
> > > > Pljava-dev mailing list
> > > > Pljava-dev at gborg.postgresql.org
> > > > http://gborg.postgresql.org/mailman/listinfo/pljava-dev
> > > >   
> > > >       
> > > -- 
> > > Vince Clark 
> > > Global Era 
> > > The freedom of open source. 
> > > (303) 493-6723 
> > > (303) 455-2409 fax 
> > > vclark at globalera.com 
> > > www.globalera.com
> > >     
> > 
> >   
> 
> -- 
> Vince Clark 
> Global Era 
> The freedom of open source. 
> (303) 493-6723 
> (303) 455-2409 fax 
> vclark at globalera.com 
> www.globalera.com






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

* [Pljava-dev] Re: [Fwd: Unable to load class org/postgresql/plsql/internal/Backend]
@ 2005-06-08 07:21  
  parent: 
  0 siblings, 0 replies; 14+ messages in thread

From:  @ 2005-06-08 07:21 UTC (permalink / raw)

Apologies.  The list post included the typo you identified but the
system actually had the "/" as expected.

I'm following up on the issue about sun's 1.5 jvm and trying with
balckdown 1.4 (amd64 ) - unless there's some other solution?

Thanks for you help.

Mike

On Wed, 2005-06-08 at 08:29 +0200, Thomas Hallgren wrote:
> Michael,
> If you get so far that a complaint about "Unable to load class" is 
> issued, then your LD_LIBRARY_PATH and dynamic_library_path are both 
> correct. Your problem is in the CLASSPATH. It ends with 
> "build.pljava.jar", i.e. you have a dot before pljava.jar. It should end 
> with "build/pljava.jar".
> 
> Regards,
> Thomas Hallgren
> 
> 
> Vince Clark wrote:
> > Michael
> > 
> > You said you were having trouble installing plsql. Do you mean pljava?
> > 
> > Be sure you also have LD_LIBRARY_PATH set with the same values.
> > 
> > Once the library path is established in both places (LD_LIBRARY_PATH) 
> > and postgresql.conf) I found that restarting postgres before trying to 
> > install pljava solved the problem.
> > 
> > Michael Judd wrote:
> > 
> >>
> >> ------------------------------------------------------------------------
> >>
> >> Subject:
> >> Unable to load class org/postgresql/plsql/internal/Backend
> >> From:
> >> Michael Judd <michael.judd at jaztek.co.uk>
> >> Date:
> >> Tue, 07 Jun 2005 23:46:25 +0100
> >> To:
> >> pljava-dev at gborg.postgresql.org
> >>
> >> To:
> >> pljava-dev at gborg.postgresql.org
> >>
> >>
> >>Hi,
> >>
> >>I'm having trouble installing plsql and I'm getting the following:
> >>
> >>Unable to load class org/postgresql/plsql/internal/Backend using
> >>CLASSPATH '-Djava.class.path=/opt/pgsql/pljava/build.pljava.jar'
> >>
> >>when issuing the command to pgsql:
> >>
> >>SELECT sqlj.install_jar('file://opt/pgsql/lib/sqlj.jar','sqlj',true);
> >>
> >>I have checked that:
> >>- pljava.jar is in /opt/pgsql/pljava/build
> >>- sqlj.jar is in  /opt/pgsql/lib
> >>
> >>in my postgres.conf I have dynamic_library_path = '/opt/pgsql/lib:
> >>$libdir' where libpljava.so, plpgsql.so resides.
> >>
> >>my paths are:
> >> - postgres /opt/pgsql
> >> - pljava /opt/pgsql/pljava
> >> - data /opt/pgsql/pg_data
> >>
> >>Fedora Core 3 x86_64smp
> >>
> >>I've double checked that Backend is located in the jar exactly where it
> >>is supposed to be - so the error being displayed doesn't seem to point
> >>in the 'right' direction.
> >>
> >>Any ideas ?
> >>
> >>
> >>
> >>
> >>
> >>  
> >>
> >>------------------------------------------------------------------------
> >>
> >>_______________________________________________
> >>Pljava-dev mailing list
> >>Pljava-dev at gborg.postgresql.org
> >>http://gborg.postgresql.org/mailman/listinfo/pljava-dev
> >>  
> >>
> > 
> > -- 
> > Vince Clark
> > Global Era
> > The freedom of open source.
> > (303) 493-6723
> > (303) 455-2409 fax
> > vclark at globalera.com <mailto:vclark at globalera.com>
> > www.globalera.com
> > 
> > 
> > ------------------------------------------------------------------------
> > 
> > _______________________________________________
> > Pljava-dev mailing list
> > Pljava-dev at gborg.postgresql.org
> > http://gborg.postgresql.org/mailman/listinfo/pljava-dev
> 
> 
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/pljava-dev






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

* [Pljava-dev] [Fwd: Unable to	load	class	org/postgresql/plsql/internal/Backend]
@ 2005-06-08 07:54  
  parent: 
  1 sibling, 0 replies; 14+ messages in thread

From:  @ 2005-06-08 07:54 UTC (permalink / raw)

I seriously doubt that this has anything to do with Suns Java 1.5 since:

1. I've been using Suns Java 1.5 on all platforms (including amd64) 
without problems.
2. The problem you encounter comes *after* the fact that the VM has 
loaded successfully.

I'd check the CLASSPATH setting again. If you are using PostgreSQL 8.0.x 
(or later) then I suggest you remove the CLASSPATH altogether and assert 
that the following lines is in your postgresql.conf:

custom_variable_classes = 'pljava'
pljava.classpath = '<your absolute path to pljava.jar>'

If you still have problems, then verify that the pljava.jar is 
accessible (check permissions on files and directories, the user who 
owns your postmaster must be able to read) and verify that it isn't 
corrupted.

Regards,
Thomas Hallgren

Michael Judd wrote:

>pljava placed my pljava.so.1.1 in /opt/pgsql/lib so I've used that
>instead of your /usr/lib64
>
>I still have the same issue.  I have restarted - I'm running it in a
>shell at the moment and I've closed the shell to ensure that the
>environment is reset and the started up postgres again with:
>
>pg_ctl start -D /opt/pgsql/pg_data -l /var/log/pgsql.log -o "-i"
>
>The log file confirms this.
>
>The problem may well be as you suggest java 1.5
>
>I'll try blackdown as I'm on dual opterons (amd64 too) which is the
>reason I didn't go with java1.4 to start.
>
>Thanks again for you help.
>
>Mike
>
>On Tue, 2005-06-07 at 19:08 -0600, Vince Clark wrote:
>  
>
>>Here is my dynamic_library_path in postgresql.conf
>>dynamic_library_path =
>>'/usr/lib64/:/home/java/j2sdk1.4.2/jre/lib/amd64/server/'
>>
>>Note that I am running an AMD64 so things will look slightly
>>different. The key in this line is that this path points to a
>>directory that contains a file called libjvm.so. In some JVM's I have
>>seen that file under jre/lib/client (rather than /server)
>>
>>Here is what my LD_LIBRARY_PATH looks like:
>>LD_LIBRARY_PATH=/usr/lib64/:/home/java/j2sdk1.4.2/jre/lib/amd64/server/ export LD_LIBRARY_PATH
>>
>>In my case the pljava build placed pljava.so.1.1 in /usr/lib64 and
>>created soft links with the proper file name of pljava.so
>>
>>Also, you may run into another problem once you get past the library
>>path issue. I was unable to install pljava using a 1.5.x JDK. I ended
>>up using Blackdown 1.4.2. It has something to do with being able to
>>spawn a VM from within Postgres. I don't remember exactly.
>>
>>Finally, I'm serious about restarting postgres. I did two
>>installations where the path settings were right but I had to restart
>>postgres before I could successfully add pljava as a language in the
>>database.
>>
>>Michael Judd wrote: 
>>    
>>
>>>Hi,
>>>
>>>At your recommendation I changed my LD_LIBRARY_PATH (via /etc/profile)
>>>to /usr/java/jdk1.5.0_03/jre/lib:/usr/java/jdk1.5.0_03/jre/lib/server:/usr/java/jdk1.5.0_03/jre/lib/native_threads:/opt/pgsql/lib
>>>This now matches my dynamic_library_path in postgresql.conf
>>>in /opt/pgsql/pg_data (or should I use this in my pljava.classpath ?
>>>
>>>I'm still getting exactly the same problem.
>>>
>>>Thanks for your help.
>>>
>>>
>>>
>>>On Tue, 2005-06-07 at 17:16 -0600, Vince Clark wrote:
>>>  
>>>      
>>>
>>>>Michael
>>>>
>>>>You said you were having trouble installing plsql. Do you mean pljava?
>>>>
>>>>Be sure you also have LD_LIBRARY_PATH set with the same values. 
>>>>
>>>>Once the library path is established in both places (LD_LIBRARY_PATH)
>>>>and postgresql.conf) I found that restarting postgres before trying to
>>>>install pljava solved the problem.
>>>>
>>>>Michael Judd wrote: 
>>>>    
>>>>        
>>>>
>>>>>____________________________________________________________________
>>>>>
>>>>>Subject:  Unable to load class org/postgresql/plsql/internal/Backend
>>>>>From:  Michael Judd <michael.judd at jaztek.co.uk>
>>>>>Date:  Tue, 07 Jun 2005 23:46:25 +0100
>>>>>To:  pljava-dev at gborg.postgresql.org
>>>>>To:  pljava-dev at gborg.postgresql.org
>>>>>
>>>>>Hi,
>>>>>
>>>>>I'm having trouble installing plsql and I'm getting the following:
>>>>>
>>>>>Unable to load class org/postgresql/plsql/internal/Backend using
>>>>>CLASSPATH '-Djava.class.path=/opt/pgsql/pljava/build.pljava.jar'
>>>>>
>>>>>when issuing the command to pgsql:
>>>>>
>>>>>SELECT sqlj.install_jar('file://opt/pgsql/lib/sqlj.jar','sqlj',true);
>>>>>
>>>>>I have checked that:
>>>>>- pljava.jar is in /opt/pgsql/pljava/build
>>>>>- sqlj.jar is in  /opt/pgsql/lib
>>>>>
>>>>>in my postgres.conf I have dynamic_library_path = '/opt/pgsql/lib:
>>>>>$libdir' where libpljava.so, plpgsql.so resides.
>>>>>
>>>>>my paths are:
>>>>> - postgres /opt/pgsql
>>>>> - pljava /opt/pgsql/pljava
>>>>> - data /opt/pgsql/pg_data
>>>>>
>>>>>Fedora Core 3 x86_64smp
>>>>>
>>>>>I've double checked that Backend is located in the jar exactly where it
>>>>>is supposed to be - so the error being displayed doesn't seem to point
>>>>>in the 'right' direction.
>>>>>
>>>>>Any ideas ?
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>  
>>>>>
>>>>>____________________________________________________________________
>>>>>
>>>>>_______________________________________________
>>>>>Pljava-dev mailing list
>>>>>Pljava-dev at gborg.postgresql.org
>>>>>http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>>>>>  
>>>>>      
>>>>>          
>>>>>
>>>>-- 
>>>>Vince Clark 
>>>>Global Era 
>>>>The freedom of open source. 
>>>>(303) 493-6723 
>>>>(303) 455-2409 fax 
>>>>vclark at globalera.com 
>>>>www.globalera.com
>>>>    
>>>>        
>>>>
>>>  
>>>      
>>>
>>-- 
>>Vince Clark 
>>Global Era 
>>The freedom of open source. 
>>(303) 493-6723 
>>(303) 455-2409 fax 
>>vclark at globalera.com 
>>www.globalera.com
>>    
>>
>
>
>_______________________________________________
>Pljava-dev mailing list
>Pljava-dev at gborg.postgresql.org
>http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>  
>






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

* [Pljava-dev] VM initialization failure
@ 2005-06-08 08:57  
  parent: 
  1 sibling, 3 replies; 14+ messages in thread

From:  @ 2005-06-08 08:57 UTC (permalink / raw)

I've gone for the blackdown 1.4.2-rc1 (AMD64) version and it has got me
to a new place - perhaps a step back!

When I try:

 SELECT sqlj.install_jar('file://opt/pgsql/lib/sqlj.jar','sqlj','true');

my /var/log/pgsql.log is showing:

Error occurred during initialization of VM

I've recompiled pljava and reinstalled it (with the -reinstall switch).
I've restarted the pgsql instance

I originally removed the LD_LIBRARY_PATH but this took me back to the
system not finding libjvm.so so I added it back in.

I'm on Postgres 8x

My postgresql.conf custom_variable_classes and pljava.classpath are set:

custom_variable_classes = 'pljava'
pljava.classpath = '/opt/pgsql/pljava/build/pljava.jar'

I've checked permissions on the postgres user and from su - postgres I
can see pljava.jar and I've opened it in file roller the it appears to
be intact.

Any other ideas ?


On Wed, 2005-06-08 at 09:54 +0200, Thomas Hallgren wrote:
> I seriously doubt that this has anything to do with Suns Java 1.5 since:
> 
> 1. I've been using Suns Java 1.5 on all platforms (including amd64) 
> without problems.
> 2. The problem you encounter comes *after* the fact that the VM has 
> loaded successfully.
> 
> I'd check the CLASSPATH setting again. If you are using PostgreSQL 8.0.x 
> (or later) then I suggest you remove the CLASSPATH altogether and assert 
> that the following lines is in your postgresql.conf:
> 
> custom_variable_classes = 'pljava'
> pljava.classpath = '<your absolute path to pljava.jar>'
> 
> If you still have problems, then verify that the pljava.jar is 
> accessible (check permissions on files and directories, the user who 
> owns your postmaster must be able to read) and verify that it isn't 
> corrupted.
> 
> Regards,
> Thomas Hallgren
> 
> Michael Judd wrote:
> 
> >pljava placed my pljava.so.1.1 in /opt/pgsql/lib so I've used that
> >instead of your /usr/lib64
> >
> >I still have the same issue.  I have restarted - I'm running it in a
> >shell at the moment and I've closed the shell to ensure that the
> >environment is reset and the started up postgres again with:
> >
> >pg_ctl start -D /opt/pgsql/pg_data -l /var/log/pgsql.log -o "-i"
> >
> >The log file confirms this.
> >
> >The problem may well be as you suggest java 1.5
> >
> >I'll try blackdown as I'm on dual opterons (amd64 too) which is the
> >reason I didn't go with java1.4 to start.
> >
> >Thanks again for you help.
> >
> >Mike
> >
> >On Tue, 2005-06-07 at 19:08 -0600, Vince Clark wrote:
> >  
> >
> >>Here is my dynamic_library_path in postgresql.conf
> >>dynamic_library_path =
> >>'/usr/lib64/:/home/java/j2sdk1.4.2/jre/lib/amd64/server/'
> >>
> >>Note that I am running an AMD64 so things will look slightly
> >>different. The key in this line is that this path points to a
> >>directory that contains a file called libjvm.so. In some JVM's I have
> >>seen that file under jre/lib/client (rather than /server)
> >>
> >>Here is what my LD_LIBRARY_PATH looks like:
> >>LD_LIBRARY_PATH=/usr/lib64/:/home/java/j2sdk1.4.2/jre/lib/amd64/server/ export LD_LIBRARY_PATH
> >>
> >>In my case the pljava build placed pljava.so.1.1 in /usr/lib64 and
> >>created soft links with the proper file name of pljava.so
> >>
> >>Also, you may run into another problem once you get past the library
> >>path issue. I was unable to install pljava using a 1.5.x JDK. I ended
> >>up using Blackdown 1.4.2. It has something to do with being able to
> >>spawn a VM from within Postgres. I don't remember exactly.
> >>
> >>Finally, I'm serious about restarting postgres. I did two
> >>installations where the path settings were right but I had to restart
> >>postgres before I could successfully add pljava as a language in the
> >>database.
> >>
> >>Michael Judd wrote: 
> >>    
> >>
> >>>Hi,
> >>>
> >>>At your recommendation I changed my LD_LIBRARY_PATH (via /etc/profile)
> >>>to /usr/java/jdk1.5.0_03/jre/lib:/usr/java/jdk1.5.0_03/jre/lib/server:/usr/java/jdk1.5.0_03/jre/lib/native_threads:/opt/pgsql/lib
> >>>This now matches my dynamic_library_path in postgresql.conf
> >>>in /opt/pgsql/pg_data (or should I use this in my pljava.classpath ?
> >>>
> >>>I'm still getting exactly the same problem.
> >>>
> >>>Thanks for your help.
> >>>
> >>>
> >>>
> >>>On Tue, 2005-06-07 at 17:16 -0600, Vince Clark wrote:
> >>>  
> >>>      
> >>>
> >>>>Michael
> >>>>
> >>>>You said you were having trouble installing plsql. Do you mean pljava?
> >>>>
> >>>>Be sure you also have LD_LIBRARY_PATH set with the same values. 
> >>>>
> >>>>Once the library path is established in both places (LD_LIBRARY_PATH)
> >>>>and postgresql.conf) I found that restarting postgres before trying to
> >>>>install pljava solved the problem.
> >>>>
> >>>>Michael Judd wrote: 
> >>>>    
> >>>>        
> >>>>
> >>>>>____________________________________________________________________
> >>>>>
> >>>>>Subject:  Unable to load class org/postgresql/plsql/internal/Backend
> >>>>>From:  Michael Judd <michael.judd at jaztek.co.uk>
> >>>>>Date:  Tue, 07 Jun 2005 23:46:25 +0100
> >>>>>To:  pljava-dev at gborg.postgresql.org
> >>>>>To:  pljava-dev at gborg.postgresql.org
> >>>>>
> >>>>>Hi,
> >>>>>
> >>>>>I'm having trouble installing plsql and I'm getting the following:
> >>>>>
> >>>>>Unable to load class org/postgresql/plsql/internal/Backend using
> >>>>>CLASSPATH '-Djava.class.path=/opt/pgsql/pljava/build.pljava.jar'
> >>>>>
> >>>>>when issuing the command to pgsql:
> >>>>>
> >>>>>SELECT sqlj.install_jar('file://opt/pgsql/lib/sqlj.jar','sqlj',true);
> >>>>>
> >>>>>I have checked that:
> >>>>>- pljava.jar is in /opt/pgsql/pljava/build
> >>>>>- sqlj.jar is in  /opt/pgsql/lib
> >>>>>
> >>>>>in my postgres.conf I have dynamic_library_path = '/opt/pgsql/lib:
> >>>>>$libdir' where libpljava.so, plpgsql.so resides.
> >>>>>
> >>>>>my paths are:
> >>>>> - postgres /opt/pgsql
> >>>>> - pljava /opt/pgsql/pljava
> >>>>> - data /opt/pgsql/pg_data
> >>>>>
> >>>>>Fedora Core 3 x86_64smp
> >>>>>
> >>>>>I've double checked that Backend is located in the jar exactly where it
> >>>>>is supposed to be - so the error being displayed doesn't seem to point
> >>>>>in the 'right' direction.
> >>>>>
> >>>>>Any ideas ?
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>  
> >>>>>
> >>>>>____________________________________________________________________
> >>>>>
> >>>>>_______________________________________________
> >>>>>Pljava-dev mailing list
> >>>>>Pljava-dev at gborg.postgresql.org
> >>>>>http://gborg.postgresql.org/mailman/listinfo/pljava-dev
> >>>>>  
> >>>>>      
> >>>>>          
> >>>>>
> >>>>-- 
> >>>>Vince Clark 
> >>>>Global Era 
> >>>>The freedom of open source. 
> >>>>(303) 493-6723 
> >>>>(303) 455-2409 fax 
> >>>>vclark at globalera.com 
> >>>>www.globalera.com
> >>>>    
> >>>>        
> >>>>
> >>>  
> >>>      
> >>>
> >>-- 
> >>Vince Clark 
> >>Global Era 
> >>The freedom of open source. 
> >>(303) 493-6723 
> >>(303) 455-2409 fax 
> >>vclark at globalera.com 
> >>www.globalera.com
> >>    
> >>
> >
> >
> >_______________________________________________
> >Pljava-dev mailing list
> >Pljava-dev at gborg.postgresql.org
> >http://gborg.postgresql.org/mailman/listinfo/pljava-dev
> >  
> >
> 
> 






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

* [Pljava-dev] [Fwd: Unable to load	class	org/postgresql/plsql/internal/Backend]
@ 2005-06-08 09:05  
  parent: 
  1 sibling, 0 replies; 14+ messages in thread

From:  @ 2005-06-08 09:05 UTC (permalink / raw)

Hi - I've gone with Blackdown now and I'm getting a VM initialization
error - which I've moved in to a new thread.

I've replicated your dynamic_library_path and LD_LIBRARY_PATH (note I
still don't have pljava in /usr/lib64 - but in /opt/pgsql/lib so that's
the only difference.

On Tue, 2005-06-07 at 19:08 -0600, Vince Clark wrote:
> Here is my dynamic_library_path in postgresql.conf
> dynamic_library_path =
> '/usr/lib64/:/home/java/j2sdk1.4.2/jre/lib/amd64/server/'
> 
> Note that I am running an AMD64 so things will look slightly
> different. The key in this line is that this path points to a
> directory that contains a file called libjvm.so. In some JVM's I have
> seen that file under jre/lib/client (rather than /server)
> 
> Here is what my LD_LIBRARY_PATH looks like:
> LD_LIBRARY_PATH=/usr/lib64/:/home/java/j2sdk1.4.2/jre/lib/amd64/server/ export LD_LIBRARY_PATH
> 
> In my case the pljava build placed pljava.so.1.1 in /usr/lib64 and
> created soft links with the proper file name of pljava.so
> 
> Also, you may run into another problem once you get past the library
> path issue. I was unable to install pljava using a 1.5.x JDK. I ended
> up using Blackdown 1.4.2. It has something to do with being able to
> spawn a VM from within Postgres. I don't remember exactly.
> 
> Finally, I'm serious about restarting postgres. I did two
> installations where the path settings were right but I had to restart
> postgres before I could successfully add pljava as a language in the
> database.
> 
> Michael Judd wrote: 
> > Hi,
> > 
> > At your recommendation I changed my LD_LIBRARY_PATH (via /etc/profile)
> > to /usr/java/jdk1.5.0_03/jre/lib:/usr/java/jdk1.5.0_03/jre/lib/server:/usr/java/jdk1.5.0_03/jre/lib/native_threads:/opt/pgsql/lib
> > This now matches my dynamic_library_path in postgresql.conf
> > in /opt/pgsql/pg_data (or should I use this in my pljava.classpath ?
> > 
> > I'm still getting exactly the same problem.
> > 
> > Thanks for your help.
> > 
> > 
> > 
> > On Tue, 2005-06-07 at 17:16 -0600, Vince Clark wrote:
> >   
> > > Michael
> > > 
> > > You said you were having trouble installing plsql. Do you mean pljava?
> > > 
> > > Be sure you also have LD_LIBRARY_PATH set with the same values. 
> > > 
> > > Once the library path is established in both places (LD_LIBRARY_PATH)
> > > and postgresql.conf) I found that restarting postgres before trying to
> > > install pljava solved the problem.
> > > 
> > > Michael Judd wrote: 
> > >     
> > > > ____________________________________________________________________
> > > > 
> > > > Subject:  Unable to load class org/postgresql/plsql/internal/Backend
> > > > From:  Michael Judd <michael.judd at jaztek.co.uk>
> > > > Date:  Tue, 07 Jun 2005 23:46:25 +0100
> > > > To:  pljava-dev at gborg.postgresql.org
> > > > To:  pljava-dev at gborg.postgresql.org
> > > > 
> > > > Hi,
> > > > 
> > > > I'm having trouble installing plsql and I'm getting the following:
> > > > 
> > > > Unable to load class org/postgresql/plsql/internal/Backend using
> > > > CLASSPATH '-Djava.class.path=/opt/pgsql/pljava/build.pljava.jar'
> > > > 
> > > > when issuing the command to pgsql:
> > > > 
> > > > SELECT sqlj.install_jar('file://opt/pgsql/lib/sqlj.jar','sqlj',true);
> > > > 
> > > > I have checked that:
> > > > - pljava.jar is in /opt/pgsql/pljava/build
> > > > - sqlj.jar is in  /opt/pgsql/lib
> > > > 
> > > > in my postgres.conf I have dynamic_library_path = '/opt/pgsql/lib:
> > > > $libdir' where libpljava.so, plpgsql.so resides.
> > > > 
> > > > my paths are:
> > > >  - postgres /opt/pgsql
> > > >  - pljava /opt/pgsql/pljava
> > > >  - data /opt/pgsql/pg_data
> > > > 
> > > > Fedora Core 3 x86_64smp
> > > > 
> > > > I've double checked that Backend is located in the jar exactly where it
> > > > is supposed to be - so the error being displayed doesn't seem to point
> > > > in the 'right' direction.
> > > > 
> > > > Any ideas ?
> > > > 
> > > > 
> > > > 
> > > > 
> > > > 
> > > >   
> > > > 
> > > > ____________________________________________________________________
> > > > 
> > > > _______________________________________________
> > > > Pljava-dev mailing list
> > > > Pljava-dev at gborg.postgresql.org
> > > > http://gborg.postgresql.org/mailman/listinfo/pljava-dev
> > > >   
> > > >       
> > > -- 
> > > Vince Clark 
> > > Global Era 
> > > The freedom of open source. 
> > > (303) 493-6723 
> > > (303) 455-2409 fax 
> > > vclark at globalera.com 
> > > www.globalera.com
> > >     
> > 
> >   
> 
> -- 
> Vince Clark 
> Global Era 
> The freedom of open source. 
> (303) 493-6723 
> (303) 455-2409 fax 
> vclark at globalera.com 
> www.globalera.com






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

* [Pljava-dev] Re: VM initialization failure
@ 2005-06-08 09:18  
  parent: 
  2 siblings, 0 replies; 14+ messages in thread

From:  @ 2005-06-08 09:18 UTC (permalink / raw)

Revert to the Sun 1.5 JVM. Reproduce the error you had earlier with the 
settings that you have now. If you still fail, then you might need to 
debug (using gdb) what's actually going on. You can do that by 
rebuilding pljava using make "CFLAGS=-g" and then add the setting 
"pljava.debug = true" in your postgresql.conf file. That will make the 
PL/Java stop immediately before it initializes the JVM, print the pid of 
its process and wait for a debugger to attach.

Regards,
Thomas Hallgren

Michael Judd wrote:

>I've gone for the blackdown 1.4.2-rc1 (AMD64) version and it has got me
>to a new place - perhaps a step back!
>
>When I try:
>
> SELECT sqlj.install_jar('file://opt/pgsql/lib/sqlj.jar','sqlj','true');
>
>my /var/log/pgsql.log is showing:
>
>Error occurred during initialization of VM
>
>I've recompiled pljava and reinstalled it (with the -reinstall switch).
>I've restarted the pgsql instance
>
>I originally removed the LD_LIBRARY_PATH but this took me back to the
>system not finding libjvm.so so I added it back in.
>
>I'm on Postgres 8x
>
>My postgresql.conf custom_variable_classes and pljava.classpath are set:
>
>custom_variable_classes = 'pljava'
>pljava.classpath = '/opt/pgsql/pljava/build/pljava.jar'
>
>I've checked permissions on the postgres user and from su - postgres I
>can see pljava.jar and I've opened it in file roller the it appears to
>be intact.
>
>Any other ideas ?
>
>
>On Wed, 2005-06-08 at 09:54 +0200, Thomas Hallgren wrote:
>  
>
>>I seriously doubt that this has anything to do with Suns Java 1.5 since:
>>
>>1. I've been using Suns Java 1.5 on all platforms (including amd64) 
>>without problems.
>>2. The problem you encounter comes *after* the fact that the VM has 
>>loaded successfully.
>>
>>I'd check the CLASSPATH setting again. If you are using PostgreSQL 8.0.x 
>>(or later) then I suggest you remove the CLASSPATH altogether and assert 
>>that the following lines is in your postgresql.conf:
>>
>>custom_variable_classes = 'pljava'
>>pljava.classpath = '<your absolute path to pljava.jar>'
>>
>>If you still have problems, then verify that the pljava.jar is 
>>accessible (check permissions on files and directories, the user who 
>>owns your postmaster must be able to read) and verify that it isn't 
>>corrupted.
>>
>>Regards,
>>Thomas Hallgren
>>
>>Michael Judd wrote:
>>
>>    
>>
>>>pljava placed my pljava.so.1.1 in /opt/pgsql/lib so I've used that
>>>instead of your /usr/lib64
>>>
>>>I still have the same issue.  I have restarted - I'm running it in a
>>>shell at the moment and I've closed the shell to ensure that the
>>>environment is reset and the started up postgres again with:
>>>
>>>pg_ctl start -D /opt/pgsql/pg_data -l /var/log/pgsql.log -o "-i"
>>>
>>>The log file confirms this.
>>>
>>>The problem may well be as you suggest java 1.5
>>>
>>>I'll try blackdown as I'm on dual opterons (amd64 too) which is the
>>>reason I didn't go with java1.4 to start.
>>>
>>>Thanks again for you help.
>>>
>>>Mike
>>>
>>>On Tue, 2005-06-07 at 19:08 -0600, Vince Clark wrote:
>>> 
>>>
>>>      
>>>
>>>>Here is my dynamic_library_path in postgresql.conf
>>>>dynamic_library_path =
>>>>'/usr/lib64/:/home/java/j2sdk1.4.2/jre/lib/amd64/server/'
>>>>
>>>>Note that I am running an AMD64 so things will look slightly
>>>>different. The key in this line is that this path points to a
>>>>directory that contains a file called libjvm.so. In some JVM's I have
>>>>seen that file under jre/lib/client (rather than /server)
>>>>
>>>>Here is what my LD_LIBRARY_PATH looks like:
>>>>LD_LIBRARY_PATH=/usr/lib64/:/home/java/j2sdk1.4.2/jre/lib/amd64/server/ export LD_LIBRARY_PATH
>>>>
>>>>In my case the pljava build placed pljava.so.1.1 in /usr/lib64 and
>>>>created soft links with the proper file name of pljava.so
>>>>
>>>>Also, you may run into another problem once you get past the library
>>>>path issue. I was unable to install pljava using a 1.5.x JDK. I ended
>>>>up using Blackdown 1.4.2. It has something to do with being able to
>>>>spawn a VM from within Postgres. I don't remember exactly.
>>>>
>>>>Finally, I'm serious about restarting postgres. I did two
>>>>installations where the path settings were right but I had to restart
>>>>postgres before I could successfully add pljava as a language in the
>>>>database.
>>>>
>>>>Michael Judd wrote: 
>>>>   
>>>>
>>>>        
>>>>
>>>>>Hi,
>>>>>
>>>>>At your recommendation I changed my LD_LIBRARY_PATH (via /etc/profile)
>>>>>to /usr/java/jdk1.5.0_03/jre/lib:/usr/java/jdk1.5.0_03/jre/lib/server:/usr/java/jdk1.5.0_03/jre/lib/native_threads:/opt/pgsql/lib
>>>>>This now matches my dynamic_library_path in postgresql.conf
>>>>>in /opt/pgsql/pg_data (or should I use this in my pljava.classpath ?
>>>>>
>>>>>I'm still getting exactly the same problem.
>>>>>
>>>>>Thanks for your help.
>>>>>
>>>>>
>>>>>
>>>>>On Tue, 2005-06-07 at 17:16 -0600, Vince Clark wrote:
>>>>> 
>>>>>     
>>>>>
>>>>>          
>>>>>
>>>>>>Michael
>>>>>>
>>>>>>You said you were having trouble installing plsql. Do you mean pljava?
>>>>>>
>>>>>>Be sure you also have LD_LIBRARY_PATH set with the same values. 
>>>>>>
>>>>>>Once the library path is established in both places (LD_LIBRARY_PATH)
>>>>>>and postgresql.conf) I found that restarting postgres before trying to
>>>>>>install pljava solved the problem.
>>>>>>
>>>>>>Michael Judd wrote: 
>>>>>>   
>>>>>>       
>>>>>>
>>>>>>            
>>>>>>
>>>>>>>____________________________________________________________________
>>>>>>>
>>>>>>>Subject:  Unable to load class org/postgresql/plsql/internal/Backend
>>>>>>>From:  Michael Judd <michael.judd at jaztek.co.uk>
>>>>>>>Date:  Tue, 07 Jun 2005 23:46:25 +0100
>>>>>>>To:  pljava-dev at gborg.postgresql.org
>>>>>>>To:  pljava-dev at gborg.postgresql.org
>>>>>>>
>>>>>>>Hi,
>>>>>>>
>>>>>>>I'm having trouble installing plsql and I'm getting the following:
>>>>>>>
>>>>>>>Unable to load class org/postgresql/plsql/internal/Backend using
>>>>>>>CLASSPATH '-Djava.class.path=/opt/pgsql/pljava/build.pljava.jar'
>>>>>>>
>>>>>>>when issuing the command to pgsql:
>>>>>>>
>>>>>>>SELECT sqlj.install_jar('file://opt/pgsql/lib/sqlj.jar','sqlj',true);
>>>>>>>
>>>>>>>I have checked that:
>>>>>>>- pljava.jar is in /opt/pgsql/pljava/build
>>>>>>>- sqlj.jar is in  /opt/pgsql/lib
>>>>>>>
>>>>>>>in my postgres.conf I have dynamic_library_path = '/opt/pgsql/lib:
>>>>>>>$libdir' where libpljava.so, plpgsql.so resides.
>>>>>>>
>>>>>>>my paths are:
>>>>>>>- postgres /opt/pgsql
>>>>>>>- pljava /opt/pgsql/pljava
>>>>>>>- data /opt/pgsql/pg_data
>>>>>>>
>>>>>>>Fedora Core 3 x86_64smp
>>>>>>>
>>>>>>>I've double checked that Backend is located in the jar exactly where it
>>>>>>>is supposed to be - so the error being displayed doesn't seem to point
>>>>>>>in the 'right' direction.
>>>>>>>
>>>>>>>Any ideas ?
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> 
>>>>>>>
>>>>>>>____________________________________________________________________
>>>>>>>
>>>>>>>_______________________________________________
>>>>>>>Pljava-dev mailing list
>>>>>>>Pljava-dev at gborg.postgresql.org
>>>>>>>http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>>>>>>> 
>>>>>>>     
>>>>>>>         
>>>>>>>
>>>>>>>              
>>>>>>>
>>>>>>-- 
>>>>>>Vince Clark 
>>>>>>Global Era 
>>>>>>The freedom of open source. 
>>>>>>(303) 493-6723 
>>>>>>(303) 455-2409 fax 
>>>>>>vclark at globalera.com 
>>>>>>www.globalera.com
>>>>>>   
>>>>>>       
>>>>>>
>>>>>>            
>>>>>>
>>>>> 
>>>>>     
>>>>>
>>>>>          
>>>>>
>>>>-- 
>>>>Vince Clark 
>>>>Global Era 
>>>>The freedom of open source. 
>>>>(303) 493-6723 
>>>>(303) 455-2409 fax 
>>>>vclark at globalera.com 
>>>>www.globalera.com
>>>>   
>>>>
>>>>        
>>>>
>>>_______________________________________________
>>>Pljava-dev mailing list
>>>Pljava-dev at gborg.postgresql.org
>>>http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>>> 
>>>
>>>      
>>>
>>    
>>
>
>
>  
>






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

* [Pljava-dev] Re: VM initialization failure
@ 2005-06-08 10:12  
  parent: 
  2 siblings, 0 replies; 14+ messages in thread

From:  @ 2005-06-08 10:12 UTC (permalink / raw)

Done - I'm back to SUN.

I am getting the same "Backend" problem now I've reverted to jdk1.5.0_03

I've compiled pljava again with:
make clean
make "CFLAGS-g"
make install

java -version reports jdk1.5.0_03-b07

gdb 
attach 28330 (the process reported by psql)
Symbols are loaded for libpljava.so 

What now?  psql tells me to set pljavaDebug to false.  How would I go
about that?

Mike

On Wed, 2005-06-08 at 11:18 +0200, Thomas Hallgren wrote:
> Revert to the Sun 1.5 JVM. Reproduce the error you had earlier with the 
> settings that you have now. If you still fail, then you might need to 
> debug (using gdb) what's actually going on. You can do that by 
> rebuilding pljava using make "CFLAGS=-g" and then add the setting 
> "pljava.debug = true" in your postgresql.conf file. That will make the 
> PL/Java stop immediately before it initializes the JVM, print the pid of 
> its process and wait for a debugger to attach.
> 
> Regards,
> Thomas Hallgren
> >On Wed, 2005-06-08 at 09:54 +0200, Thomas Hallgren wrote:
> >  
> >
> >>I seriously doubt that this has anything to do with Suns Java 1.5 since:
> >>
> >>1. I've been using Suns Java 1.5 on all platforms (including amd64) 
> >>without problems.
> >>2. The problem you encounter comes *after* the fact that the VM has 
> >>loaded successfully.
> >>
> >>I'd check the CLASSPATH setting again. If you are using PostgreSQL 8.0.x 
> >>(or later) then I suggest you remove the CLASSPATH altogether and assert 
> >>that the following lines is in your postgresql.conf:
> >>
> >>custom_variable_classes = 'pljava'
> >>pljava.classpath = '<your absolute path to pljava.jar>'
> >>
> >>If you still have problems, then verify that the pljava.jar is 
> >>accessible (check permissions on files and directories, the user who 
> >>owns your postmaster must be able to read) and verify that it isn't 
> >>corrupted.
> >>
> >>Regards,
> >>Thomas Hallgren
> >>>       
> >>>>>>
> >>>>>>            
> >>>>>>
> >>>>>>>____________________________________________________________________
> >>>>>>>
> >>>>>>>Subject:  Unable to load class org/postgresql/plsql/internal/Backend
> >>>>>>>From:  Michael Judd <michael.judd at jaztek.co.uk>
> >>>>>>>Date:  Tue, 07 Jun 2005 23:46:25 +0100
> >>>>>>>To:  pljava-dev at gborg.postgresql.org
> >>>>>>>To:  pljava-dev at gborg.postgresql.org
> >>>>>>>
> >>>>>>>Hi,
> >>>>>>>
> >>>>>>>I'm having trouble installing plsql and I'm getting the following:
> >>>>>>>
> >>>>>>>Unable to load class org/postgresql/plsql/internal/Backend using
> >>>>>>>CLASSPATH '-Djava.class.path=/opt/pgsql/pljava/build.pljava.jar'
> >>>>>>>
> >>>>>>>when issuing the command to pgsql:
> >>>>>>>
> >>>>>>>SELECT sqlj.install_jar('file://opt/pgsql/lib/sqlj.jar','sqlj',true);
> >>>>>>>
> >>>>>>>I have checked that:
> >>>>>>>- pljava.jar is in /opt/pgsql/pljava/build
> >>>>>>>- sqlj.jar is in  /opt/pgsql/lib
> >>>>>>>
> >>>>>>>in my postgres.conf I have dynamic_library_path = '/opt/pgsql/lib:
> >>>>>>>$libdir' where libpljava.so, plpgsql.so resides.
> >>>>>>>
> >>>>>>>my paths are:
> >>>>>>>- postgres /opt/pgsql
> >>>>>>>- pljava /opt/pgsql/pljava
> >>>>>>>- data /opt/pgsql/pg_data
> >>>>>>>
> >>>>>>>Fedora Core 3 x86_64smp
> >>>>>>>
> >>>>>>>I've double checked that Backend is located in the jar exactly where it
> >>>>>>>is supposed to be - so the error being displayed doesn't seem to point
> >>>>>>>in the 'right' direction.
> >>>>>>>
> >>>>>>>Any ideas ?
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>> 
> >>>>>>>
> >>>>>>>____________________________________________________________________
> >>>>>>>
> >>>>>>>_______________________________________________
> >>>>>>>Pljava-dev mailing list
> >>>>>>>Pljava-dev at gborg.postgresql.org
> >>>>>>>http://gborg.postgresql.org/mailman/listinfo/pljava-dev
> >>>>>>> 
> >>>>>>>     
> >>>>>>>         
> >>>>>>>
> >>>>>>>              
> >>>>>>>
> >>>>>>-- 
> >>>>>>Vince Clark 
> >>>>>>Global Era 
> >>>>>>The freedom of open source. 
> >>>>>>(303) 493-6723 
> >>>>>>(303) 455-2409 fax 
> >>>>>>vclark at globalera.com 
> >>>>>>www.globalera.com
> >>>>>>   
> >>>>>>       
> >>>>>>
> >>>>>>            
> >>>>>>
> >>>>> 
> >>>>>     
> >>>>>
> >>>>>          
> >>>>>
> >>>>-- 
> >>>>Vince Clark 
> >>>>Global Era 
> >>>>The freedom of open source. 
> >>>>(303) 493-6723 
> >>>>(303) 455-2409 fax 
> >>>>vclark at globalera.com 
> >>>>www.globalera.com
> >>>>   
> >>>>
> >>>>        
> >>>>
> >>>_______________________________________________
> >>>Pljava-dev mailing list
> >>>Pljava-dev at gborg.postgresql.org
> >>>http://gborg.postgresql.org/mailman/listinfo/pljava-dev
> >>> 
> >>>
> >>>      
> >>>
> >>    
> >>
> >
> >
> >  
> >
> 
> 






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

* [Pljava-dev] Re: VM initialization failure
@ 2005-06-08 11:41  
  parent: 
  2 siblings, 0 replies; 14+ messages in thread

From:  @ 2005-06-08 11:41 UTC (permalink / raw)

Just to clear up this thread - my problem - once I used gdm to get some
extra info - was the zlib version conflict - which I solved by
recompiling postgresql using the --without-zlib flag.

Thanks for all who helped.

Mike

On Wed, 2005-06-08 at 11:18 +0200, Thomas Hallgren wrote:
> Revert to the Sun 1.5 JVM. Reproduce the error you had earlier with the 
> settings that you have now. If you still fail, then you might need to 
> debug (using gdb) what's actually going on. You can do that by 
> rebuilding pljava using make "CFLAGS=-g" and then add the setting 
> "pljava.debug = true" in your postgresql.conf file. That will make the 
> PL/Java stop immediately before it initializes the JVM, print the pid of 
> its process and wait for a debugger to attach.
> 
> Regards,
> Thomas Hallgren
> 
> Michael Judd wrote:
> 
> >I've gone for the blackdown 1.4.2-rc1 (AMD64) version and it has got me
> >to a new place - perhaps a step back!
> >
> >When I try:
> >
> > SELECT sqlj.install_jar('file://opt/pgsql/lib/sqlj.jar','sqlj','true');
> >
> >my /var/log/pgsql.log is showing:
> >
> >Error occurred during initialization of VM
> >
> >I've recompiled pljava and reinstalled it (with the -reinstall switch).
> >I've restarted the pgsql instance
> >
> >I originally removed the LD_LIBRARY_PATH but this took me back to the
> >system not finding libjvm.so so I added it back in.
> >
> >I'm on Postgres 8x
> >
> >My postgresql.conf custom_variable_classes and pljava.classpath are set:
> >
> >custom_variable_classes = 'pljava'
> >pljava.classpath = '/opt/pgsql/pljava/build/pljava.jar'
> >
> >I've checked permissions on the postgres user and from su - postgres I
> >can see pljava.jar and I've opened it in file roller the it appears to
> >be intact.
> >
> >Any other ideas ?
> >
> >
> >On Wed, 2005-06-08 at 09:54 +0200, Thomas Hallgren wrote:
> >  
> >
> >>I seriously doubt that this has anything to do with Suns Java 1.5 since:
> >>
> >>1. I've been using Suns Java 1.5 on all platforms (including amd64) 
> >>without problems.
> >>2. The problem you encounter comes *after* the fact that the VM has 
> >>loaded successfully.
> >>
> >>I'd check the CLASSPATH setting again. If you are using PostgreSQL 8.0.x 
> >>(or later) then I suggest you remove the CLASSPATH altogether and assert 
> >>that the following lines is in your postgresql.conf:
> >>
> >>custom_variable_classes = 'pljava'
> >>pljava.classpath = '<your absolute path to pljava.jar>'
> >>
> >>If you still have problems, then verify that the pljava.jar is 
> >>accessible (check permissions on files and directories, the user who 
> >>owns your postmaster must be able to read) and verify that it isn't 
> >>corrupted.
> >>
> >>Regards,
> >>Thomas Hallgren
> >>
> >>Michael Judd wrote:
> >>
> >>    
> >>
> >>>pljava placed my pljava.so.1.1 in /opt/pgsql/lib so I've used that
> >>>instead of your /usr/lib64
> >>>
> >>>I still have the same issue.  I have restarted - I'm running it in a
> >>>shell at the moment and I've closed the shell to ensure that the
> >>>environment is reset and the started up postgres again with:
> >>>
> >>>pg_ctl start -D /opt/pgsql/pg_data -l /var/log/pgsql.log -o "-i"
> >>>
> >>>The log file confirms this.
> >>>
> >>>The problem may well be as you suggest java 1.5
> >>>
> >>>I'll try blackdown as I'm on dual opterons (amd64 too) which is the
> >>>reason I didn't go with java1.4 to start.
> >>>
> >>>Thanks again for you help.
> >>>
> >>>Mike
> >>>
> >>>On Tue, 2005-06-07 at 19:08 -0600, Vince Clark wrote:
> >>> 
> >>>
> >>>      
> >>>
> >>>>Here is my dynamic_library_path in postgresql.conf
> >>>>dynamic_library_path =
> >>>>'/usr/lib64/:/home/java/j2sdk1.4.2/jre/lib/amd64/server/'
> >>>>
> >>>>Note that I am running an AMD64 so things will look slightly
> >>>>different. The key in this line is that this path points to a
> >>>>directory that contains a file called libjvm.so. In some JVM's I have
> >>>>seen that file under jre/lib/client (rather than /server)
> >>>>
> >>>>Here is what my LD_LIBRARY_PATH looks like:
> >>>>LD_LIBRARY_PATH=/usr/lib64/:/home/java/j2sdk1.4.2/jre/lib/amd64/server/ export LD_LIBRARY_PATH
> >>>>
> >>>>In my case the pljava build placed pljava.so.1.1 in /usr/lib64 and
> >>>>created soft links with the proper file name of pljava.so
> >>>>
> >>>>Also, you may run into another problem once you get past the library
> >>>>path issue. I was unable to install pljava using a 1.5.x JDK. I ended
> >>>>up using Blackdown 1.4.2. It has something to do with being able to
> >>>>spawn a VM from within Postgres. I don't remember exactly.
> >>>>
> >>>>Finally, I'm serious about restarting postgres. I did two
> >>>>installations where the path settings were right but I had to restart
> >>>>postgres before I could successfully add pljava as a language in the
> >>>>database.
> >>>>
> >>>>Michael Judd wrote: 
> >>>>   
> >>>>
> >>>>        
> >>>>
> >>>>>Hi,
> >>>>>
> >>>>>At your recommendation I changed my LD_LIBRARY_PATH (via /etc/profile)
> >>>>>to /usr/java/jdk1.5.0_03/jre/lib:/usr/java/jdk1.5.0_03/jre/lib/server:/usr/java/jdk1.5.0_03/jre/lib/native_threads:/opt/pgsql/lib
> >>>>>This now matches my dynamic_library_path in postgresql.conf
> >>>>>in /opt/pgsql/pg_data (or should I use this in my pljava.classpath ?
> >>>>>
> >>>>>I'm still getting exactly the same problem.
> >>>>>
> >>>>>Thanks for your help.
> >>>>>
> >>>>>
> >>>>>
> >>>>>On Tue, 2005-06-07 at 17:16 -0600, Vince Clark wrote:
> >>>>> 
> >>>>>     
> >>>>>
> >>>>>          
> >>>>>
> >>>>>>Michael
> >>>>>>
> >>>>>>You said you were having trouble installing plsql. Do you mean pljava?
> >>>>>>
> >>>>>>Be sure you also have LD_LIBRARY_PATH set with the same values. 
> >>>>>>
> >>>>>>Once the library path is established in both places (LD_LIBRARY_PATH)
> >>>>>>and postgresql.conf) I found that restarting postgres before trying to
> >>>>>>install pljava solved the problem.
> >>>>>>
> >>>>>>Michael Judd wrote: 
> >>>>>>   
> >>>>>>       
> >>>>>>
> >>>>>>            
> >>>>>>
> >>>>>>>____________________________________________________________________
> >>>>>>>
> >>>>>>>Subject:  Unable to load class org/postgresql/plsql/internal/Backend
> >>>>>>>From:  Michael Judd <michael.judd at jaztek.co.uk>
> >>>>>>>Date:  Tue, 07 Jun 2005 23:46:25 +0100
> >>>>>>>To:  pljava-dev at gborg.postgresql.org
> >>>>>>>To:  pljava-dev at gborg.postgresql.org
> >>>>>>>
> >>>>>>>Hi,
> >>>>>>>
> >>>>>>>I'm having trouble installing plsql and I'm getting the following:
> >>>>>>>
> >>>>>>>Unable to load class org/postgresql/plsql/internal/Backend using
> >>>>>>>CLASSPATH '-Djava.class.path=/opt/pgsql/pljava/build.pljava.jar'
> >>>>>>>
> >>>>>>>when issuing the command to pgsql:
> >>>>>>>
> >>>>>>>SELECT sqlj.install_jar('file://opt/pgsql/lib/sqlj.jar','sqlj',true);
> >>>>>>>
> >>>>>>>I have checked that:
> >>>>>>>- pljava.jar is in /opt/pgsql/pljava/build
> >>>>>>>- sqlj.jar is in  /opt/pgsql/lib
> >>>>>>>
> >>>>>>>in my postgres.conf I have dynamic_library_path = '/opt/pgsql/lib:
> >>>>>>>$libdir' where libpljava.so, plpgsql.so resides.
> >>>>>>>
> >>>>>>>my paths are:
> >>>>>>>- postgres /opt/pgsql
> >>>>>>>- pljava /opt/pgsql/pljava
> >>>>>>>- data /opt/pgsql/pg_data
> >>>>>>>
> >>>>>>>Fedora Core 3 x86_64smp
> >>>>>>>
> >>>>>>>I've double checked that Backend is located in the jar exactly where it
> >>>>>>>is supposed to be - so the error being displayed doesn't seem to point
> >>>>>>>in the 'right' direction.
> >>>>>>>
> >>>>>>>Any ideas ?
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>> 
> >>>>>>>
> >>>>>>>____________________________________________________________________
> >>>>>>>
> >>>>>>>_______________________________________________
> >>>>>>>Pljava-dev mailing list
> >>>>>>>Pljava-dev at gborg.postgresql.org
> >>>>>>>http://gborg.postgresql.org/mailman/listinfo/pljava-dev
> >>>>>>> 
> >>>>>>>     
> >>>>>>>         
> >>>>>>>
> >>>>>>>              
> >>>>>>>
> >>>>>>-- 
> >>>>>>Vince Clark 
> >>>>>>Global Era 
> >>>>>>The freedom of open source. 
> >>>>>>(303) 493-6723 
> >>>>>>(303) 455-2409 fax 
> >>>>>>vclark at globalera.com 
> >>>>>>www.globalera.com
> >>>>>>   
> >>>>>>       
> >>>>>>
> >>>>>>            
> >>>>>>
> >>>>> 
> >>>>>     
> >>>>>
> >>>>>          
> >>>>>
> >>>>-- 
> >>>>Vince Clark 
> >>>>Global Era 
> >>>>The freedom of open source. 
> >>>>(303) 493-6723 
> >>>>(303) 455-2409 fax 
> >>>>vclark at globalera.com 
> >>>>www.globalera.com
> >>>>   
> >>>>
> >>>>        
> >>>>
> >>>_______________________________________________
> >>>Pljava-dev mailing list
> >>>Pljava-dev at gborg.postgresql.org
> >>>http://gborg.postgresql.org/mailman/listinfo/pljava-dev
> >>> 
> >>>
> >>>      
> >>>
> >>    
> >>
> >
> >
> >  
> >
> 
> 






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


end of thread, other threads:[~2005-06-08 11:41 UTC | newest]

Thread overview: 14+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-06-07 23:11 [Pljava-dev] [Fwd: Unable to load class org/postgresql/plsql/internal/Backend] 
2005-06-07 23:16 ` [Pljava-dev] [Fwd: Unable to load class	org/postgresql/plsql/internal/Backend] 
2005-06-08 00:27   ` [Pljava-dev] [Fwd: Unable to load class	org/postgresql/plsql/internal/Backend] 
2005-06-08 01:08     ` [Pljava-dev] [Fwd: Unable to load	class	org/postgresql/plsql/internal/Backend] 
2005-06-08 07:08       ` [Pljava-dev] [Fwd: Unable to load	class	org/postgresql/plsql/internal/Backend] 
2005-06-08 07:54         ` [Pljava-dev] [Fwd: Unable to	load	class	org/postgresql/plsql/internal/Backend] 
2005-06-08 08:57         ` [Pljava-dev] VM initialization failure 
2005-06-08 09:18           ` [Pljava-dev] Re: VM initialization failure 
2005-06-08 10:12           ` [Pljava-dev] Re: VM initialization failure 
2005-06-08 11:41           ` [Pljava-dev] Re: VM initialization failure 
2005-06-08 09:05       ` [Pljava-dev] [Fwd: Unable to load	class	org/postgresql/plsql/internal/Backend] 
2005-06-08 06:29   ` 
2005-06-08 06:29     ` 
2005-06-08 07:21       ` 

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