[Pljava-dev] newbie sqlj.install_jar problem

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
>>