agora inbox for pljava-dev@postgresql.org
help / color / mirror / Atom feed[Pljava-dev] Error while installing jar
3+ messages / 0 participants
[nested] [flat]
* [Pljava-dev] Error while installing jar
@ 2005-09-27 09:42
2005-09-27 09:42 ` [Pljava-dev] Error while installing jar
2005-09-27 10:16 ` [Pljava-dev] Re: Error while installing jar
0 siblings, 2 replies; 3+ messages in thread
From: @ 2005-09-27 09:42 UTC (permalink / raw)
Hello,
I am new to PL/Java, have some experience with Java in Oracle.
I have successfully deployed PL/Java after some problems with the
installation. But now I wanted to run the example tests as indicated in
the user manual. When doing so, I get the following error back from
Postgres in psql:
test_toolbox=# select
sqlj.install_jar('file:///home/pauli/office52/Artikel/Toolbox/pl_java/examples.jar',
'samples', true);
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
My configuration is as follows:
Linux (Fedora Core 3)
Java - Standard Installation, Java 1.4.2_05
[pauli at laptop ~]$ echo $JAVA_HOME
/usr/java/j2sdk1.4.2_05
My /etc/ld.so.conf:
include ld.so.conf.d/*.conf
/usr/X11R6/lib
/usr/lib/mysql
/usr/local/lib
/usr/local/lib/python2.4
/usr/local/lib/gtk-2.0
/usr/java/j2sdk1.4.2_05/jre/lib/i386
/usr/java/j2sdk1.4.2_05/jre/lib/i386/client
/usr/java/j2sdk1.4.2_05/jre/lib/i386/native_threads"
Postgres-Version:
PostgreSQL 8.0.1
contains support for command-line editing
My postgresql.conf:
custom_variable_classes = 'pljava'
#---------------------------------------------------------------------------
# SETTINGS FOR PL/Java 1.1
#---------------------------------------------------------------------------
pljava.classpath =
'/home/pauli/office52/Artikel/Toolbox/pl_java/pljava.jar'
libpljava.so in the same directory where Postgres-libraries reside
I could deploy PL/Java and I can see the schema and also all the tables
and functions therein.
Please explain to me, what the problem could be.
I really would need an answer very soon, because I am writing a magazine
article for a german developer magazine.
Thanks in advance.
Paul
^ permalink raw reply [nested|flat] 3+ messages in thread
* [Pljava-dev] Error while installing jar
2005-09-27 09:42 [Pljava-dev] Error while installing jar
@ 2005-09-27 09:42 `
1 sibling, 0 replies; 3+ messages in thread
From: @ 2005-09-27 09:42 UTC (permalink / raw)
Hi Paul,
Can you please attach the server log (i.e. backend output)? It will give
some hint as to why it terminated.
Regards,
Thomas Hallgren
Paul Weinstabl wrote:
> Hello,
>
> I am new to PL/Java, have some experience with Java in Oracle.
>
> I have successfully deployed PL/Java after some problems with the
> installation. But now I wanted to run the example tests as indicated
> in the user manual. When doing so, I get the following error back from
> Postgres in psql:
>
> test_toolbox=# select
> sqlj.install_jar('file:///home/pauli/office52/Artikel/Toolbox/pl_java/examples.jar',
> 'samples', true);
> server closed the connection unexpectedly
> This probably means the server terminated abnormally
> before or while processing the request.
> The connection to the server was lost. Attempting reset: Failed.
>
> My configuration is as follows:
>
> Linux (Fedora Core 3)
> Java - Standard Installation, Java 1.4.2_05
> [pauli at laptop ~]$ echo $JAVA_HOME
> /usr/java/j2sdk1.4.2_05
>
> My /etc/ld.so.conf:
> include ld.so.conf.d/*.conf
> /usr/X11R6/lib
> /usr/lib/mysql
> /usr/local/lib
> /usr/local/lib/python2.4
> /usr/local/lib/gtk-2.0
> /usr/java/j2sdk1.4.2_05/jre/lib/i386
> /usr/java/j2sdk1.4.2_05/jre/lib/i386/client
> /usr/java/j2sdk1.4.2_05/jre/lib/i386/native_threads"
>
> Postgres-Version:
> PostgreSQL 8.0.1
> contains support for command-line editing
>
> My postgresql.conf:
> custom_variable_classes = 'pljava'
>
> #---------------------------------------------------------------------------
>
> # SETTINGS FOR PL/Java 1.1
> #---------------------------------------------------------------------------
>
> pljava.classpath =
> '/home/pauli/office52/Artikel/Toolbox/pl_java/pljava.jar'
>
> libpljava.so in the same directory where Postgres-libraries reside
>
> I could deploy PL/Java and I can see the schema and also all the
> tables and functions therein.
>
> Please explain to me, what the problem could be.
>
> I really would need an answer very soon, because I am writing a
> magazine article for a german developer magazine.
>
> Thanks in advance.
>
> Paul
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/pljava-dev
^ permalink raw reply [nested|flat] 3+ messages in thread
* [Pljava-dev] Re: Error while installing jar
2005-09-27 09:42 [Pljava-dev] Error while installing jar
@ 2005-09-27 10:16 `
1 sibling, 0 replies; 3+ messages in thread
From: @ 2005-09-27 10:16 UTC (permalink / raw)
I see another potential problem with your configuration. You're using
PostgreSQL 8.0.1. It has a bug that doesn't play well with PL/Java. You
should use at least 8.0.2.
Regards,
Thomas Hallgren
Paul Weinstabl wrote:
> Hello,
>
> I am new to PL/Java, have some experience with Java in Oracle.
>
> I have successfully deployed PL/Java after some problems with the
> installation. But now I wanted to run the example tests as indicated in
> the user manual. When doing so, I get the following error back from
> Postgres in psql:
>
> test_toolbox=# select
> sqlj.install_jar('file:///home/pauli/office52/Artikel/Toolbox/pl_java/examples.jar',
> 'samples', true);
> server closed the connection unexpectedly
> This probably means the server terminated abnormally
> before or while processing the request.
> The connection to the server was lost. Attempting reset: Failed.
>
> My configuration is as follows:
>
> Linux (Fedora Core 3)
> Java - Standard Installation, Java 1.4.2_05
> [pauli at laptop ~]$ echo $JAVA_HOME
> /usr/java/j2sdk1.4.2_05
>
> My /etc/ld.so.conf:
> include ld.so.conf.d/*.conf
> /usr/X11R6/lib
> /usr/lib/mysql
> /usr/local/lib
> /usr/local/lib/python2.4
> /usr/local/lib/gtk-2.0
> /usr/java/j2sdk1.4.2_05/jre/lib/i386
> /usr/java/j2sdk1.4.2_05/jre/lib/i386/client
> /usr/java/j2sdk1.4.2_05/jre/lib/i386/native_threads"
>
> Postgres-Version:
> PostgreSQL 8.0.1
> contains support for command-line editing
>
> My postgresql.conf:
> custom_variable_classes = 'pljava'
>
> #---------------------------------------------------------------------------
>
> # SETTINGS FOR PL/Java 1.1
> #---------------------------------------------------------------------------
>
> pljava.classpath =
> '/home/pauli/office52/Artikel/Toolbox/pl_java/pljava.jar'
>
> libpljava.so in the same directory where Postgres-libraries reside
>
> I could deploy PL/Java and I can see the schema and also all the tables
> and functions therein.
>
> Please explain to me, what the problem could be.
>
> I really would need an answer very soon, because I am writing a magazine
> article for a german developer magazine.
>
> Thanks in advance.
>
> Paul
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2005-09-27 10:16 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-09-27 09:42 [Pljava-dev] Error while installing jar
2005-09-27 09:42 `
2005-09-27 10:16 `
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox