agora inbox for pljava-dev@postgresql.org
help / color / mirror / Atom feed[Pljava-dev] newbie sqlj.install_jar problem
6+ messages / 0 participants
[nested] [flat]
* [Pljava-dev] newbie sqlj.install_jar problem
@ 2006-11-10 10:22
2006-11-10 15:03 ` [Pljava-dev] newbie sqlj.install_jar problem
0 siblings, 1 reply; 6+ messages in thread
From: @ 2006-11-10 10:22 UTC (permalink / raw)
Hello everybody
i new to this list, and pl/java too.
my environnement :
CentOS Linux 4.2, java 1.4.2_11, postgresql 8.1.4, pljava 1.3.0
after the deployment done with command :
java -cp
/opt/pgsql/pljava/deploy.jar:/opt/pgsql/jdbc/postgresql-8.1-310.jdbc3.jar
org.postgresql.pljava.deploy.Deployer -install -user dbuser -database
mydb
i have new tables in my database mydb :
- sqlj.classpath_entry
- sqlj.jar_entry
- sqlj.jar_repository
- sqlj.typemap_entry
- sqlj.jar_repository_pkey
- sqlj.jar_repository_jarname_pkey
- sqlj.jar_entry_pkey
- sqlj.jar_entry_jarid_key
- sqlj.classpath_entry_pkey
- sqlj.typemap_entry_pkey
- sqlj.jar_repository_jarid_seq
- sqlj.jar_entry_entryid_seq
- sqlj.typemap_entry_mapid_seq
now i would like to run command under psql:
select sqlj.install_jar('file:///opt/app/sqlj.jar','sqlj',true);
but each time, there is a failure, with error like this :
INFO: Error occurred during initialization of VM
INFO: Unable to load native library
INFO: : libverify.so: cannot open shared object file: No such file or
directory
INFO:
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.
Can someone help?
Where can i set up to have more ERROR information?
Thanks!
P.S: sorry if question has been asked before, but i have not found any
answer that works for me.
^ permalink raw reply [nested|flat] 6+ messages in thread
* [Pljava-dev] newbie sqlj.install_jar problem
2006-11-10 10:22 [Pljava-dev] newbie sqlj.install_jar problem
@ 2006-11-10 15:03 `
2006-11-10 16:52 ` [Pljava-dev] newbie sqlj.install_jar problem
0 siblings, 1 reply; 6+ messages in thread
From: @ 2006-11-10 15:03 UTC (permalink / raw)
I am new to this as well, but it sounds like postmaster can't find the
JVM libraries...
See this section of the wiki:
http://wiki.tada.se/wiki/display/pljava/Posix+Installation
Of the two options presented for the part of that Posix+Installation page:
Ensure that the JRE shared libraries can be found by the Postmaster
backend. This can be done in different ways depending on platform.
Here are two suggestions (the i386 directory will of course be named
something suitable for your CPU architecture):
1. Setting the LD_LIBRARY_PATH environment will work on most
Linux/Unix platforms. A good place to do this is usually the file
/etc/sysconfig/pgsql/postgresql:
export LD_LIBRARY_PATH=$JRE_HOME/lib/i386:$JRE_HOME/lib/i386/client
Apparently, on some Linux platforms you will also need to append
:$JRE_HOME/lib/i386/native_threads
2. Add a file named postgresql to the directory /etc/ld.so.conf.d
that looks like this:
<jre-home>/lib/i386
<jre-home>/lib/i386/client
The <jre-home> must be expanded. Then use /sbin/ldconfig to make
this new setting effective.
I did the #2 option on my CentOS 4 machine and had success (though I
had Java 1.5.0_09)...
Regards,
-Mark
On 11/10/06, Alpha Malick <alphamalick at hotmail.com> wrote:
> Hello everybody
> i new to this list, and pl/java too.
>
> my environnement :
> CentOS Linux 4.2, java 1.4.2_11, postgresql 8.1.4, pljava 1.3.0
>
> after the deployment done with command :
> java -cp
> /opt/pgsql/pljava/deploy.jar:/opt/pgsql/jdbc/postgresql-8.1-310.jdbc3.jar
> org.postgresql.pljava.deploy.Deployer -install -user dbuser -database
> mydb
>
> i have new tables in my database mydb :
> - sqlj.classpath_entry
> - sqlj.jar_entry
> - sqlj.jar_repository
> - sqlj.typemap_entry
> - sqlj.jar_repository_pkey
> - sqlj.jar_repository_jarname_pkey
> - sqlj.jar_entry_pkey
> - sqlj.jar_entry_jarid_key
> - sqlj.classpath_entry_pkey
> - sqlj.typemap_entry_pkey
> - sqlj.jar_repository_jarid_seq
> - sqlj.jar_entry_entryid_seq
> - sqlj.typemap_entry_mapid_seq
>
> now i would like to run command under psql:
>
> select sqlj.install_jar('file:///opt/app/sqlj.jar','sqlj',true);
>
> but each time, there is a failure, with error like this :
> INFO: Error occurred during initialization of VM
> INFO: Unable to load native library
> INFO: : libverify.so: cannot open shared object file: No such file or
> directory
> INFO:
> 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.
>
> Can someone help?
> Where can i set up to have more ERROR information?
> Thanks!
>
> P.S: sorry if question has been asked before, but i have not found any
> answer that works for me.
>
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* [Pljava-dev] newbie sqlj.install_jar problem
2006-11-10 10:22 [Pljava-dev] newbie sqlj.install_jar problem
2006-11-10 15:03 ` [Pljava-dev] newbie sqlj.install_jar problem
@ 2006-11-10 16:52 `
2006-11-10 17:11 ` [Pljava-dev] newbie sqlj.install_jar problem
0 siblings, 1 reply; 6+ messages in thread
From: @ 2006-11-10 16:52 UTC (permalink / raw)
Thanks a lot Mark!
Actually, i did like you, using the #2 option as suggested by the wiki.
After that i managed to run the deployer, and it generated the tables in
my database, like i said earlier.
The problem here is with command
select sqlj.install_jar('file:///opt/app/sqlj.jar','sqlj',true);
this is where the error happens!
I am going to try with java 1.5.0_09
thanks
Alpha
Mark Mitchell a ?crit :
> I am new to this as well, but it sounds like postmaster can't find the
> JVM libraries...
>
> See this section of the wiki:
> http://wiki.tada.se/wiki/display/pljava/Posix+Installation
>
> Of the two options presented for the part of that Posix+Installation page:
>
> Ensure that the JRE shared libraries can be found by the Postmaster
> backend. This can be done in different ways depending on platform.
> Here are two suggestions (the i386 directory will of course be named
> something suitable for your CPU architecture):
>
> 1. Setting the LD_LIBRARY_PATH environment will work on most
> Linux/Unix platforms. A good place to do this is usually the file
> /etc/sysconfig/pgsql/postgresql:
>
> export LD_LIBRARY_PATH=$JRE_HOME/lib/i386:$JRE_HOME/lib/i386/client
>
>
> Apparently, on some Linux platforms you will also need to append
>
> :$JRE_HOME/lib/i386/native_threads
>
> 2. Add a file named postgresql to the directory /etc/ld.so.conf.d
> that looks like this:
>
> <jre-home>/lib/i386
> <jre-home>/lib/i386/client
>
> The <jre-home> must be expanded. Then use /sbin/ldconfig to make
> this new setting effective.
>
>
> I did the #2 option on my CentOS 4 machine and had success (though I
> had Java 1.5.0_09)...
>
> Regards,
>
> -Mark
>
>
> On 11/10/06, Alpha Malick <alphamalick at hotmail.com> wrote:
>> Hello everybody
>> i new to this list, and pl/java too.
>>
>> my environnement :
>> CentOS Linux 4.2, java 1.4.2_11, postgresql 8.1.4, pljava 1.3.0
>>
>> after the deployment done with command :
>> java -cp
>> /opt/pgsql/pljava/deploy.jar:/opt/pgsql/jdbc/postgresql-8.1-310.jdbc3.jar
>> org.postgresql.pljava.deploy.Deployer -install -user dbuser -database
>> mydb
>>
>> i have new tables in my database mydb :
>> - sqlj.classpath_entry
>> - sqlj.jar_entry
>> - sqlj.jar_repository
>> - sqlj.typemap_entry
>> - sqlj.jar_repository_pkey
>> - sqlj.jar_repository_jarname_pkey
>> - sqlj.jar_entry_pkey
>> - sqlj.jar_entry_jarid_key
>> - sqlj.classpath_entry_pkey
>> - sqlj.typemap_entry_pkey
>> - sqlj.jar_repository_jarid_seq
>> - sqlj.jar_entry_entryid_seq
>> - sqlj.typemap_entry_mapid_seq
>>
>> now i would like to run command under psql:
>>
>> select sqlj.install_jar('file:///opt/app/sqlj.jar','sqlj',true);
>>
>> but each time, there is a failure, with error like this :
>> INFO: Error occurred during initialization of VM
>> INFO: Unable to load native library
>> INFO: : libverify.so: cannot open shared object file: No such file or
>> directory
>> INFO:
>> 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.
>>
>> Can someone help?
>> Where can i set up to have more ERROR information?
>> Thanks!
>>
>> P.S: sorry if question has been asked before, but i have not found any
>> answer that works for me.
>>
>> _______________________________________________
>> Pljava-dev mailing list
>> Pljava-dev at gborg.postgresql.org
>> http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>>
^ permalink raw reply [nested|flat] 6+ messages in thread
* [Pljava-dev] newbie sqlj.install_jar problem
2006-11-10 10:22 [Pljava-dev] newbie sqlj.install_jar problem
2006-11-10 15:03 ` [Pljava-dev] newbie sqlj.install_jar problem
2006-11-10 16:52 ` [Pljava-dev] newbie sqlj.install_jar problem
@ 2006-11-10 17:11 `
2006-11-13 07:52 ` [Pljava-dev] newbie sqlj.install_jar problem
0 siblings, 1 reply; 6+ messages in thread
From: @ 2006-11-10 17:11 UTC (permalink / raw)
Hi Alpha,
The deployer is a client program. Running it successfully doesn't mean
that the backend is able to find the JVM libraries so your problem might
still be configuration related. PL/Java *should* work with Java 1.4.2.
I've never tried CentOS though. What Java distro do you use? Is it the
standard Sun Java for Linux?
Regards,
Thomas Hallgren
Alpha Malick wrote:
> Thanks a lot Mark!
> Actually, i did like you, using the #2 option as suggested by the wiki.
> After that i managed to run the deployer, and it generated the tables in
> my database, like i said earlier.
> The problem here is with command
> select sqlj.install_jar('file:///opt/app/sqlj.jar','sqlj',true);
>
> this is where the error happens!
> I am going to try with java 1.5.0_09
>
> thanks
> Alpha
> Mark Mitchell a ?crit :
>
>> I am new to this as well, but it sounds like postmaster can't find the
>> JVM libraries...
>>
>> See this section of the wiki:
>> http://wiki.tada.se/wiki/display/pljava/Posix+Installation
>>
>> Of the two options presented for the part of that Posix+Installation page:
>>
>> Ensure that the JRE shared libraries can be found by the Postmaster
>> backend. This can be done in different ways depending on platform.
>> Here are two suggestions (the i386 directory will of course be named
>> something suitable for your CPU architecture):
>>
>> 1. Setting the LD_LIBRARY_PATH environment will work on most
>> Linux/Unix platforms. A good place to do this is usually the file
>> /etc/sysconfig/pgsql/postgresql:
>>
>> export LD_LIBRARY_PATH=$JRE_HOME/lib/i386:$JRE_HOME/lib/i386/client
>>
>>
>> Apparently, on some Linux platforms you will also need to append
>>
>> :$JRE_HOME/lib/i386/native_threads
>>
>> 2. Add a file named postgresql to the directory /etc/ld.so.conf.d
>> that looks like this:
>>
>> <jre-home>/lib/i386
>> <jre-home>/lib/i386/client
>>
>> The <jre-home> must be expanded. Then use /sbin/ldconfig to make
>> this new setting effective.
>>
>>
>> I did the #2 option on my CentOS 4 machine and had success (though I
>> had Java 1.5.0_09)...
>>
>> Regards,
>>
>> -Mark
>>
>>
>> On 11/10/06, Alpha Malick <alphamalick at hotmail.com> wrote:
>>
>>> Hello everybody
>>> i new to this list, and pl/java too.
>>>
>>> my environnement :
>>> CentOS Linux 4.2, java 1.4.2_11, postgresql 8.1.4, pljava 1.3.0
>>>
>>> after the deployment done with command :
>>> java -cp
>>> /opt/pgsql/pljava/deploy.jar:/opt/pgsql/jdbc/postgresql-8.1-310.jdbc3.jar
>>> org.postgresql.pljava.deploy.Deployer -install -user dbuser -database
>>> mydb
>>>
>>> i have new tables in my database mydb :
>>> - sqlj.classpath_entry
>>> - sqlj.jar_entry
>>> - sqlj.jar_repository
>>> - sqlj.typemap_entry
>>> - sqlj.jar_repository_pkey
>>> - sqlj.jar_repository_jarname_pkey
>>> - sqlj.jar_entry_pkey
>>> - sqlj.jar_entry_jarid_key
>>> - sqlj.classpath_entry_pkey
>>> - sqlj.typemap_entry_pkey
>>> - sqlj.jar_repository_jarid_seq
>>> - sqlj.jar_entry_entryid_seq
>>> - sqlj.typemap_entry_mapid_seq
>>>
>>> now i would like to run command under psql:
>>>
>>> select sqlj.install_jar('file:///opt/app/sqlj.jar','sqlj',true);
>>>
>>> but each time, there is a failure, with error like this :
>>> INFO: Error occurred during initialization of VM
>>> INFO: Unable to load native library
>>> INFO: : libverify.so: cannot open shared object file: No such file or
>>> directory
>>> INFO:
>>> 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.
>>>
>>> Can someone help?
>>> Where can i set up to have more ERROR information?
>>> Thanks!
>>>
>>> P.S: sorry if question has been asked before, but i have not found any
>>> answer that works for me.
>>>
>>> _______________________________________________
>>> 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] 6+ messages in thread
* [Pljava-dev] newbie sqlj.install_jar problem
2006-11-10 10:22 [Pljava-dev] newbie sqlj.install_jar problem
2006-11-10 15:03 ` [Pljava-dev] newbie sqlj.install_jar problem
2006-11-10 16:52 ` [Pljava-dev] newbie sqlj.install_jar problem
2006-11-10 17:11 ` [Pljava-dev] newbie sqlj.install_jar problem
@ 2006-11-13 07:52 `
2006-11-13 14:40 ` [Pljava-dev] newbie sqlj.install_jar problem
0 siblings, 1 reply; 6+ messages in thread
From: @ 2006-11-13 07:52 UTC (permalink / raw)
Hi all,
just for information, we use CentOS 4 (it is very close to RedHat EL
distribution), and we have no problems with running pljava (using standard
Sun Java). The only path to java libraries is
<jre-home>/lib/i386/server
which contains the libjvm.so library.
Are you sure that your postmaster can see the LD_LIBRARY_PATH? Try to check
the way it is passed to the postmaster start.
Regards
Filip
----- Original Message -----
From: "Thomas Hallgren" <thomas at tada.se>
To: "Alpha Malick" <alphamalick at hotmail.com>
Cc: <pljava-dev at gborg.postgresql.org>
Sent: Friday, November 10, 2006 6:11 PM
Subject: Re: [Pljava-dev] newbie sqlj.install_jar problem
> Hi Alpha,
> The deployer is a client program. Running it successfully doesn't mean
> that the backend is able to find the JVM libraries so your problem might
> still be configuration related. PL/Java *should* work with Java 1.4.2.
> I've never tried CentOS though. What Java distro do you use? Is it the
> standard Sun Java for Linux?
>
> Regards,
> Thomas Hallgren
>
>
> Alpha Malick wrote:
>> Thanks a lot Mark!
>> Actually, i did like you, using the #2 option as suggested by the wiki.
>> After that i managed to run the deployer, and it generated the tables in
>> my database, like i said earlier.
>> The problem here is with command
>> select sqlj.install_jar('file:///opt/app/sqlj.jar','sqlj',true);
>>
>> this is where the error happens!
>> I am going to try with java 1.5.0_09
>>
>> thanks
>> Alpha
>> Mark Mitchell a ?crit :
>>
>>> I am new to this as well, but it sounds like postmaster can't find the
>>> JVM libraries...
>>>
>>> See this section of the wiki:
>>> http://wiki.tada.se/wiki/display/pljava/Posix+Installation
>>>
>>> Of the two options presented for the part of that Posix+Installation
>>> page:
>>>
>>> Ensure that the JRE shared libraries can be found by the Postmaster
>>> backend. This can be done in different ways depending on platform.
>>> Here are two suggestions (the i386 directory will of course be named
>>> something suitable for your CPU architecture):
>>>
>>> 1. Setting the LD_LIBRARY_PATH environment will work on most
>>> Linux/Unix platforms. A good place to do this is usually the file
>>> /etc/sysconfig/pgsql/postgresql:
>>>
>>> export
>>> LD_LIBRARY_PATH=$JRE_HOME/lib/i386:$JRE_HOME/lib/i386/client
>>>
>>>
>>> Apparently, on some Linux platforms you will also need to append
>>>
>>> :$JRE_HOME/lib/i386/native_threads
>>>
>>> 2. Add a file named postgresql to the directory /etc/ld.so.conf.d
>>> that looks like this:
>>>
>>> <jre-home>/lib/i386
>>> <jre-home>/lib/i386/client
>>>
>>> The <jre-home> must be expanded. Then use /sbin/ldconfig to make
>>> this new setting effective.
>>>
>>>
>>> I did the #2 option on my CentOS 4 machine and had success (though I
>>> had Java 1.5.0_09)...
>>>
>>> Regards,
>>>
>>> -Mark
>>>
>>>
>>> On 11/10/06, Alpha Malick <alphamalick at hotmail.com> wrote:
>>>
>>>> Hello everybody
>>>> i new to this list, and pl/java too.
>>>>
>>>> my environnement :
>>>> CentOS Linux 4.2, java 1.4.2_11, postgresql 8.1.4, pljava 1.3.0
>>>>
>>>> after the deployment done with command :
>>>> java -cp
>>>> /opt/pgsql/pljava/deploy.jar:/opt/pgsql/jdbc/postgresql-8.1-310.jdbc3.jar
>>>> org.postgresql.pljava.deploy.Deployer -install -user dbuser -database
>>>> mydb
>>>>
>>>> i have new tables in my database mydb :
>>>> - sqlj.classpath_entry
>>>> - sqlj.jar_entry
>>>> - sqlj.jar_repository
>>>> - sqlj.typemap_entry
>>>> - sqlj.jar_repository_pkey
>>>> - sqlj.jar_repository_jarname_pkey
>>>> - sqlj.jar_entry_pkey
>>>> - sqlj.jar_entry_jarid_key
>>>> - sqlj.classpath_entry_pkey
>>>> - sqlj.typemap_entry_pkey
>>>> - sqlj.jar_repository_jarid_seq
>>>> - sqlj.jar_entry_entryid_seq
>>>> - sqlj.typemap_entry_mapid_seq
>>>>
>>>> now i would like to run command under psql:
>>>>
>>>> select sqlj.install_jar('file:///opt/app/sqlj.jar','sqlj',true);
>>>>
>>>> but each time, there is a failure, with error like this :
>>>> INFO: Error occurred during initialization of VM
>>>> INFO: Unable to load native library
>>>> INFO: : libverify.so: cannot open shared object file: No such file or
>>>> directory
>>>> INFO:
>>>> 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.
>>>>
>>>> Can someone help?
>>>> Where can i set up to have more ERROR information?
>>>> Thanks!
>>>>
>>>> P.S: sorry if question has been asked before, but i have not found any
>>>> answer that works for me.
>>>>
>>>> _______________________________________________
>>>> 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
>>
>
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/pljava-dev
^ permalink raw reply [nested|flat] 6+ messages in thread
* [Pljava-dev] newbie sqlj.install_jar problem
2006-11-10 10:22 [Pljava-dev] newbie sqlj.install_jar problem
2006-11-10 15:03 ` [Pljava-dev] newbie sqlj.install_jar problem
2006-11-10 16:52 ` [Pljava-dev] newbie sqlj.install_jar problem
2006-11-10 17:11 ` [Pljava-dev] newbie sqlj.install_jar problem
2006-11-13 07:52 ` [Pljava-dev] newbie sqlj.install_jar problem
@ 2006-11-13 14:40 `
0 siblings, 0 replies; 6+ messages in thread
From: @ 2006-11-13 14:40 UTC (permalink / raw)
Thanks a lot everyone (and specially to Filip Hbrek)
now it works after i change the path to <jre-home>/lib/i386/server
(instead of <jre-home>/lib/i386/client)
In fact i have to path to java librairies, <jre-home>/lib/i386/server
and <jre-home>/lib/i386/client, and they all contain libjvm.so
I don't really understand what's going on, but now command : select
sqlj.install_jar('file:///opt/app/sqlj.jar','sqlj',true);
Regards,
Alpha
Filip Hrbek a ?crit :
> Hi all,
> just for information, we use CentOS 4 (it is very close to RedHat EL
> distribution), and we have no problems with running pljava (using standard
> Sun Java). The only path to java libraries is
>
> <jre-home>/lib/i386/server
>
> which contains the libjvm.so library.
>
> Are you sure that your postmaster can see the LD_LIBRARY_PATH? Try to check
> the way it is passed to the postmaster start.
>
> Regards
> Filip
>
>
> ----- Original Message -----
> From: "Thomas Hallgren" <thomas at tada.se>
> To: "Alpha Malick" <alphamalick at hotmail.com>
> Cc: <pljava-dev at gborg.postgresql.org>
> Sent: Friday, November 10, 2006 6:11 PM
> Subject: Re: [Pljava-dev] newbie sqlj.install_jar problem
>
>
>> Hi Alpha,
>> The deployer is a client program. Running it successfully doesn't mean
>> that the backend is able to find the JVM libraries so your problem might
>> still be configuration related. PL/Java *should* work with Java 1.4.2.
>> I've never tried CentOS though. What Java distro do you use? Is it the
>> standard Sun Java for Linux?
>>
>> Regards,
>> Thomas Hallgren
>>
>>
>> Alpha Malick wrote:
>>> Thanks a lot Mark!
>>> Actually, i did like you, using the #2 option as suggested by the wiki.
>>> After that i managed to run the deployer, and it generated the tables in
>>> my database, like i said earlier.
>>> The problem here is with command
>>> select sqlj.install_jar('file:///opt/app/sqlj.jar','sqlj',true);
>>>
>>> this is where the error happens!
>>> I am going to try with java 1.5.0_09
>>>
>>> thanks
>>> Alpha
>>> Mark Mitchell a ?crit :
>>>
>>>> I am new to this as well, but it sounds like postmaster can't find the
>>>> JVM libraries...
>>>>
>>>> See this section of the wiki:
>>>> http://wiki.tada.se/wiki/display/pljava/Posix+Installation
>>>>
>>>> Of the two options presented for the part of that Posix+Installation
>>>> page:
>>>>
>>>> Ensure that the JRE shared libraries can be found by the Postmaster
>>>> backend. This can be done in different ways depending on platform.
>>>> Here are two suggestions (the i386 directory will of course be named
>>>> something suitable for your CPU architecture):
>>>>
>>>> 1. Setting the LD_LIBRARY_PATH environment will work on most
>>>> Linux/Unix platforms. A good place to do this is usually the file
>>>> /etc/sysconfig/pgsql/postgresql:
>>>>
>>>> export
>>>> LD_LIBRARY_PATH=$JRE_HOME/lib/i386:$JRE_HOME/lib/i386/client
>>>>
>>>>
>>>> Apparently, on some Linux platforms you will also need to append
>>>>
>>>> :$JRE_HOME/lib/i386/native_threads
>>>>
>>>> 2. Add a file named postgresql to the directory /etc/ld.so.conf.d
>>>> that looks like this:
>>>>
>>>> <jre-home>/lib/i386
>>>> <jre-home>/lib/i386/client
>>>>
>>>> The <jre-home> must be expanded. Then use /sbin/ldconfig to make
>>>> this new setting effective.
>>>>
>>>>
>>>> I did the #2 option on my CentOS 4 machine and had success (though I
>>>> had Java 1.5.0_09)...
>>>>
>>>> Regards,
>>>>
>>>> -Mark
>>>>
>>>>
>>>> On 11/10/06, Alpha Malick <alphamalick at hotmail.com> wrote:
>>>>
>>>>> Hello everybody
>>>>> i new to this list, and pl/java too.
>>>>>
>>>>> my environnement :
>>>>> CentOS Linux 4.2, java 1.4.2_11, postgresql 8.1.4, pljava 1.3.0
>>>>>
>>>>> after the deployment done with command :
>>>>> java -cp
>>>>> /opt/pgsql/pljava/deploy.jar:/opt/pgsql/jdbc/postgresql-8.1-310.jdbc3.jar
>>>>> org.postgresql.pljava.deploy.Deployer -install -user dbuser -database
>>>>> mydb
>>>>>
>>>>> i have new tables in my database mydb :
>>>>> - sqlj.classpath_entry
>>>>> - sqlj.jar_entry
>>>>> - sqlj.jar_repository
>>>>> - sqlj.typemap_entry
>>>>> - sqlj.jar_repository_pkey
>>>>> - sqlj.jar_repository_jarname_pkey
>>>>> - sqlj.jar_entry_pkey
>>>>> - sqlj.jar_entry_jarid_key
>>>>> - sqlj.classpath_entry_pkey
>>>>> - sqlj.typemap_entry_pkey
>>>>> - sqlj.jar_repository_jarid_seq
>>>>> - sqlj.jar_entry_entryid_seq
>>>>> - sqlj.typemap_entry_mapid_seq
>>>>>
>>>>> now i would like to run command under psql:
>>>>>
>>>>> select sqlj.install_jar('file:///opt/app/sqlj.jar','sqlj',true);
>>>>>
>>>>> but each time, there is a failure, with error like this :
>>>>> INFO: Error occurred during initialization of VM
>>>>> INFO: Unable to load native library
>>>>> INFO: : libverify.so: cannot open shared object file: No such file or
>>>>> directory
>>>>> INFO:
>>>>> 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.
>>>>>
>>>>> Can someone help?
>>>>> Where can i set up to have more ERROR information?
>>>>> Thanks!
>>>>>
>>>>> P.S: sorry if question has been asked before, but i have not found any
>>>>> answer that works for me.
>>>>>
>>>>> _______________________________________________
>>>>> 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
>>>
>> _______________________________________________
>> Pljava-dev mailing list
>> Pljava-dev at gborg.postgresql.org
>> http://gborg.postgresql.org/mailman/listinfo/pljava-dev
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2006-11-13 14:40 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-11-10 10:22 [Pljava-dev] newbie sqlj.install_jar problem
2006-11-10 15:03 `
2006-11-10 16:52 `
2006-11-10 17:11 `
2006-11-13 07:52 `
2006-11-13 14:40 `
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox