<html>
<head>
<style>
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
FONT-SIZE: 10pt;
FONT-FAMILY:Tahoma
}
</style>
</head>
<body class='hmmessage'>
I forgot to mention that default points to jdk1.5.0_15. The last two question were referring to my PATH variable, does that get checked before the LD_LIBRARY_PATH setting? Or can anything else cause this setting to be skipped?<br><blockquote><hr>From: sotelojavier@hotmail.com<br>To: pljava-dev@pgfoundry.org<br>Date: Mon, 2 Jun 2008 21:07:01 -0700<br>Subject: [Pljava-dev] RE: PLJava (64-bit) Build Error: JNI_CreateJavaVMþ<br><br>
<meta http-equiv="Content-Type" content="text/html; charset=unicode">
<meta name="Generator" content="Microsoft SafeHTML">
<style>
.ExternalClass .EC_hmmessage P
{padding:0px;}
.ExternalClass body.EC_hmmessage
{font-size:10pt;font-family:Tahoma;}
</style>
<style>
.ExternalClass .EC_hmmessage P
{padding:0px;}
.ExternalClass body.EC_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 <br> '/usr/sh<br>are/pljava/pljava.so': /usr/share/pljava/pljava.so: undefined symbol: <br>JN
I_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<br> able is not checked? Can it be using a different libjvm.so?<br> <br>Much Appreciate
d,<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 <br> 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="_blank">Join the i’m Initiative from Microsoft.</a>
</blockquote><br /><hr />Enjoy 5 GB of free, password-protected online storage. <a href='http://www.windowslive.com/skydrive/overview.html?ocid=TXT_TAGLM_WL_Refresh_skydrive_062008' target='_new'>Get Windows Live SkyDrive.</a></body>
</html>