<span style="font-family:arial, sans-serif;font-size:13px;border-collapse:collapse">Thanks a lot Kris. My this problem is solved. The next error I get is below. Please have a look. I really need this up and running and really appreciate your help. pljava.so is there in the directory. I think it needs libjvm.so. Where do I find it ?<div>
<br></div><div><div>swaroop@swaroop-laptop:~/Project/pljava$ java -cp postgresql-8.4-701.jdbc4.jar:deploy.jar org.postgresql.pljava.deploy.Deployer -install</div><div>org.postgresql.util.PSQLException: ERROR: could not load library "/home/swaroop/Project/MayBMS/database/lib/postgresql/pljava.so": libjvm.so: cannot open shared object file: No such file or directory</div>
<div><span style="white-space:pre"> </span>at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)</div><div><span style="white-space:pre"> </span>at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)</div>
<div><span style="white-space:pre"> </span>at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)</div><div><span style="white-space:pre"> </span>at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)</div>
<div><span style="white-space:pre"> </span>at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:353)</div><div><span style="white-space:pre"> </span>at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:345)</div>
<div><span style="white-space:pre"> </span>at org.postgresql.pljava.deploy.Deployer.initJavaHandlers(Deployer.java:474)</div><div><span style="white-space:pre"> </span>at org.postgresql.pljava.deploy.Deployer.main(Deployer.java:269)</div>
</div><div><br></div><div><br></div><div>Regards<br clear="all"><font color="#888888">Swaroop</font></div></span><br>
<br><br><div class="gmail_quote">On Wed, Jun 16, 2010 at 11:32 PM, Kris Jurka <span dir="ltr"><<a href="mailto:books@ejurka.com" target="_blank">books@ejurka.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div>On 6/16/2010 3:11 PM, swaroop wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
The last step says, run the deployer program. I did that but<br>
unfortunately I get an exception. Please help me here. The exception is<br>
below. I tried to download the jdbc driver at<br>
<a href="http://jdbc.postgresql.org/download/postgresql-8.4-701.jdbc3.jar" target="_blank">http://jdbc.postgresql.org/download/postgresql-8.4-701.jdbc3.jar</a> and<br>
added it to classpath. But this did not help. Please advice.<br>
<br>
swaroop@swaroop-laptop:~/Project/pljava$ java -cp deploy.jar<br>
org.postgresql.pljava.deploy.Deployer -install<br>
java.lang.ClassNotFoundException: org.postgresql.Driver<br>
</blockquote>
<br></div>
You need to add it to the classpath here:<br>
<br>
java -cp postgresql-8.4-701.jdbc3.jar:deploy.jar org.postgresql.pljava.deploy.Deployer -install<br>
</blockquote></div><br>