<html>
<head>
<style>
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
FONT-SIZE: 10pt;
FONT-FAMILY:Tahoma
}
</style>
</head>
<body class='hmmessage'>
<style>.hmmessage P{margin:0px;padding:0px}body.hmmessage{FONT-SIZE: 10pt;FONT-FAMILY:Tahoma}</style><pre>The LD_LIBRARY_PATH environment setting is being set with the .bashrc <br>file which is the start up script that SuSe uses, this should be the script<br> you were referring to. The export snapshot I sent in the DETAILS section <br>lists some of the environmental variables set at start up by default. The <br>path to the libjvm.so is correct: <br> <br>postgres@lb-bft23:/usr/java/jdk1.5.0_15/jre/lib/amd64/server> ls<br>libjsig.so libjvm.so Xusage.txt<br> <br>One thing I did notice was the SuSe used the java binary under <br>/usr/java/jdk1.5.0_15/bin so I issued the following command:<br> <br>postgres@lb-bft23:/usr/share/pljava> /usr/java/default/jre/bin/java -server<br>-cp deploy.jar:postgresql-8.1-412.jdbc3.jar <br>org.postgresql.pljava.deploy.Deployer -install -user postgres <br>-database pljava<br>org.postgresql.util.PSQLException: ERROR: could not load library
'/usr/sh<br>are/pljava/pljava.so': /usr/share/pljava/pljava.so: undefined symbol: <br>JNI_CreateJavaVM<br> at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse<br>(QueryExecutorImpl.java:1575)<br> at org.postgresql.core.v3.QueryExecutorImpl.processResults(Query<br>ExecutorImpl.java:1324)<br> at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecut<br>orImpl.java:190)<br> at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(Abstract<br>Jdbc2Statement.java:452)<br> at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags<br>(AbstractJdbc2Statement.java:340)<br> at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(Abstract<br>Jdbc2Statement.java:332)<br> at org.postgresql.pljava.deploy.Deployer.initJavaHandlers(Deploye<br>r.java:474)<br> at org.postgresql.pljava.deploy.Deployer.main(Deployer.java:269)<br> <br>As you can see it's the same result. Is there any way that the <br>environmental vari
able is not checked? Can it be using a different libjvm.so?<br> <br>Much Appreciated,<br>Javier Sotelo <br>----------------------------------------<br>> Date: Sat, 31 May 2008 09:27:05 -0400<br>> From: books@ejurka.com<br>> To: sotelojavier@hotmail.com<br>> CC: pljava-dev@pgfoundry.org<br>> Subject: Re: [Pljava-dev] PLJava (64-bit) Build Error: JNI_CreateJavaVM<br>> <br>> <br>> <br>> On Tue, 13 May 2008, Javier Sotelo wrote:<br>> <br>>> The current 64-bit pljava binary for Linux depends on assert code that <br>>> is not included, therefore it is unusable. After successfully building <br>>> pljava with no errors, I tried to install again. This time the library <br>>> could not load due to an undefined symbol, JNI_CreateJavaVM (actually <br>>> there's more, see details).<br>> <br>> This error suggests that you don't have libjvm.so available to the server <br>> process. You seem to be setting LD_LIBRARY_PATH
appropriately, but it's <br>> not clear when/where you are settting this. You need to start your server <br>> with this environment, not the deployer. Note that setting it in your <br>> environment and then running an init script is unlikely to work. I'm not <br>> familiar with Suse start scripts, but usually the easiest thing to do is <br>> to just modify the start script itself to set this environment variable.<br>> <br>> Kris Jurka<br>> <br> </pre><br /><hr />Change the world with e-mail. <a href='http://im.live.com/Messenger/IM/Join/Default.aspx?source=EML_WL_ChangeWorld' target='_new'>Join the i’m Initiative from Microsoft.</a></body>
</html>