From: alphamalick at hotmail.com (Alpha Malick)
Date: Fri, 10 Nov 2006 10:22:37 +0000
Subject: [Pljava-dev] newbie sqlj.install_jar problem
Message-ID: <455452ED.6020900@hotmail.com>

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.