On Oct 26, 12:51 pm, yogesh <yogesh.arora.daffo...@xxxxxxxxx> wrote:
> Hello frnds,
> I have installed the Postgres on Linux Platform(suse
> Linux)...now i want to install Pl/JAVA in postgres......i done it with
> the following command.............
>
> java -cp /usr/share/pljava/deploy.jar:/usr/share/pgsql/
> postgresql-8.1-404.jdbc3.jar org.postgresql.pljava.deploy.Deployer -
> install -user yogesh -database yogesh -password arora
>
> Now when i run this command ...........I got a Error message that
> is :-
>
> org.postgresql.util.PSQLException: ERROR: could not load library "/usr/
> share/pljava/pljava.so": libjvm.so: cannot open shared object file: No
> such file or directory
> at
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:
> 1548)
> at
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:
> 1316)
> at
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:
> 212)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:
> 458)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:
> 338)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:
> 329)
> at
> org.postgresql.pljava.deploy.Deployer.initJavaHandlers(Deployer.java:
> 474)
> at org.postgresql.pljava.deploy.Deployer.main(Deployer.java:270)
>
> any body have an Idea about the problem...Please respond asap..
>
> regards,
> Yogesh Arora
Hello Frnds,
My this problem is also been sort out.....
There was some problem in JAVA_HOME so it was unable to find
out the libjvm.so
i changed the path from simple JAVA_HOME to JROckIT
JAVA_HOME......where it finds the libjvm.so..
Now its running....
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
