From: alphamalick at hotmail.com (Alpha Malick)
Date: Mon, 13 Nov 2006 14:40:30 +0000
Subject: [Pljava-dev] newbie sqlj.install_jar problem
In-Reply-To: <002401c706f8$9e9ffe50$1e03a8c0@fhrbek>
References: <455452ED.6020900@hotmail.com>
	<449f4cf70611100702t3fee08e8n625e53a917e85a85@mail.gmail.com><4554AE53.2070207@hotmail.com>
	<4554B2CA.1020506@tada.se>
	<002401c706f8$9e9ffe50$1e03a8c0@fhrbek>
Message-ID: <455883DE.208@hotmail.com>

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