agora inbox for pljava-dev@postgresql.org
help / color / mirror / Atom feed[Pljava-dev] language "java" does not exist
7+ messages / 0 participants
[nested] [flat]
* [Pljava-dev] language "java" does not exist
@ 2005-05-19 22:49
2005-05-21 07:30 ` [Pljava-dev] language "java" does not exist
0 siblings, 1 reply; 7+ messages in thread
From: @ 2005-05-19 22:49 UTC (permalink / raw)
I'm trying to deploy pljava with postgres 8.0 on Windows XP and failing. The
command I use is:
java org.postgresql.pljava.deploy.Deployer -install -host localhost
-database testdb -user postgres -password mypass
I receive this error:
java.sql.SQLException: ERROR: could not load library "C:/Program
Files/PostgreSQL/8.0/pljava/libpljava.dll": dynamic load error
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorI
mpl.java:1471)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.ja
va:1256)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:175)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.j
ava:389)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2St
atement.java:314)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.j
ava:306)
at
org.postgresql.pljava.deploy.Deployer.initJavaHandlers(Deployer.java:419)
at org.postgresql.pljava.deploy.Deployer.main(Deployer.java:275)
In the postgress log, it gives me this error:
2005-05-19 16:37:17 ERROR: language "java" does not exist
2005-05-19 16:37:31 ERROR: could not load library "C:/Program
Files/PostgreSQL/8.0/pljava/libpljava.dll": dynamic load error
2005-05-19 16:37:31 LOG: could not receive data from client: No connection
could be made because the target machine actively refused it.
2005-05-19 16:37:31 LOG: unexpected EOF on client connection
Below is my conf file (w/comments removed):
custom_variable_classes = 'pljava'
pljava.classpath = 'C:\\Program Files\\PostgreSQL\\8.0\\pljava\\pljava.jar'
listen_addresses = '*' # what IP interface(s) to listen on;
# defaults to localhost, '*' = any
port = 5432
max_connections = 100
shared_buffers = 1000 # min 16, at least max_connections*2, 8KB each
log_destination = 'stderr' # Valid values are combinations of stderr,
# syslog and eventlog, depending on
# platform.
redirect_stderr = true # Enable capturing of stderr into log files.
log_min_messages = info
lc_messages = 'C' # locale for system error message strings
lc_monetary = 'C' # locale for monetary formatting
lc_numeric = 'C' # locale for number formatting
lc_time = 'C' # locale for time formatting
dynamic_library_path = '$libdir;C:\\Program Files\\PostgreSQL\\8.0\\pljava'
I am using Java 5 sdk.
I could use any suggestions.
Terrance
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20050519/ec9f9e6f/attachment.html;
^ permalink raw reply [nested|flat] 7+ messages in thread
* [Pljava-dev] language "java" does not exist
2005-05-19 22:49 [Pljava-dev] language "java" does not exist
@ 2005-05-21 07:30 `
0 siblings, 0 replies; 7+ messages in thread
From: @ 2005-05-21 07:30 UTC (permalink / raw)
Terrance Davis wrote:
> I?m trying to deploy pljava with postgres 8.0 on Windows XP and
> failing. The command I use is:
>
> java org.postgresql.pljava.deploy.Deployer -install -host localhost
> -database testdb -user postgres -password mypass
>
> I receive this error:
>
> java.sql.SQLException: ERROR: could not load library "C:/Program
> Files/PostgreSQL/8.0/pljava/libpljava.dll": dynamic load error
>
Please consult the mail archives and/or user guide. There's plenty of
information concerning this error. Pay specific attention to the PATH
setting. The "language java does not exist" is a consequence of the load
error.
Regards,
Thomas Hallgren
^ permalink raw reply [nested|flat] 7+ messages in thread
* [Pljava-dev] language "java" does not exist
@ 2008-07-26 16:57
2008-07-29 17:15 ` [Pljava-dev] language "java" does not exist
0 siblings, 1 reply; 7+ messages in thread
From: @ 2008-07-26 16:57 UTC (permalink / raw)
Hi TrifonAfter I set LD_LIBRARY_PATH and run uninstall.sql to clear previous installation, there still has an error saying "java" does not exit. Why? What did I miss? I have explicitly set LD_LIBRARY_PATH and set in /usr/ld/ld.config by using crle -u -i ...
I have set the dynamic_library_path='$libdir:/usr/postgres/8.2/lib' in postgresql.conf
# echo $LD_LIBRARY_PATH/usr/postgres/8.2/lib:/usr/jdk/instances/jdk1.5.0/jre/lib/amd64:/usr/jdk/instances/jdk1.5.0/jre/lib/amd64/native_threads:/usr/jdk/instances/jdk1.5.0/jre/lib/amd64/server# echo $JAVA_HOME/usr/jdk/instances/jdk1.5.0
# java -versionjava version "1.5.0_15"Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_15-b04)Java HotSpot(TM) Client VM (build 1.5.0_15-b04, mixed mode, sharing)# svcadm restart postgresql:version_82# psql -d adempiere -U adempiere -f /var/tmp/pljava/pljava-1.4.0/src/sql/uninstall.sqlPassword for user adempiere:psql:/var/tmp/pljava/pljava-1.4.0/src/sql/uninstall.sql:1: ERROR: language "java" does not existpsql:/var/tmp/pljava/pljava-1.4.0/src/sql/uninstall.sql:2: ERROR: language "javau" does not existpsql:/var/tmp/pljava/pljava-1.4.0/src/sql/uninstall.sql:3: ERROR: schema "sqlj" does not exist#Regards, Terence
_________________________________________________________________
Connect to the next generation of MSN Messenger?
http://imagine-msn.com/messenger/launch80/default.aspx?locale=en-us&source=wlmailtagline
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20080727/3a6c7af8/attachment.html;
^ permalink raw reply [nested|flat] 7+ messages in thread
* [Pljava-dev] language "java" does not exist
2008-07-26 16:57 [Pljava-dev] language "java" does not exist
@ 2008-07-29 17:15 `
2008-07-30 14:35 ` [Pljava-dev] language "java" does not exist
0 siblings, 1 reply; 7+ messages in thread
From: @ 2008-07-29 17:15 UTC (permalink / raw)
Terence Ng wrote:
>
> After I set LD_LIBRARY_PATH and run uninstall.sql to clear previous
> installation, there still has an error saying "java" does not exit.
> Why? What did I miss?
If your previous installation didn't get completely installed than the
uninstall will fail to uninstall some parts of it. That's expected.
Also if you run the uninstall script multiple times it should only do
something interesting on the first run. I believe you've sufficiently
uninstalled it to begin the installation again.
Kris Jurka
^ permalink raw reply [nested|flat] 7+ messages in thread
* [Pljava-dev] language "java" does not exist
2008-07-26 16:57 [Pljava-dev] language "java" does not exist
2008-07-29 17:15 ` [Pljava-dev] language "java" does not exist
@ 2008-07-30 14:35 `
2008-07-30 15:00 ` [Pljava-dev] language "java" does not exist
0 siblings, 1 reply; 7+ messages in thread
From: @ 2008-07-30 14:35 UTC (permalink / raw)
I don't know why it cannot find libjvm.so and java. What should I do?# echo $LD_LIBRARY_PATH/usr/jdk/instances/jdk1.5.0/jre/lib/i386:/usr/jdk/instances /jdk1.5.0/jre/lib/i386/client:/usr/jdk/instances/jdk1.5.0/jre/lib/i386/native_threads# echo $LD_LIBRARY_PATH_64/usr/jdk/instances/jdk1.5.0/jre/lib/amd64:/usr/jdk/instances/jdk1.5.0/jre/lib/amd64/server:/usr/jdk/instances/jdk1.5.0/jre/lib/amd64/native_threads# echo $JAVA_HOME/usr/jdk/instances/jdk1.5.0# java -versionjava version "1.5.0_15"Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_15-b04)Java HotSpot(TM) Client VM (build 1.5.0_15-b04, mixed mode, sharing)# psql -d adempiere -U adempiere -f install.sqlPassword for user adempiere:CREATE SCHEMAGRANTpsql:install.sql:6: ERROR: could not load library "/usr/postgres/8.2/lib/pljava.so": ld.so.1: postgres: fatal: libjvm.so: open failed: No such file or directorypsql:install.sql:8: ERROR: function sqlj.java_call_handler() does not existpsql:install.sql:12: ERROR: could not load library "/usr/postgres/8.2/lib/pljava.so": ld.so.1: postgres: fatal: libjvm.so: open failed: No such file or directorypsql:install.sql:14: ERROR: function sqlj.javau_call_handler() does not existpsql:install.sql:23: NOTICE: CREATE TABLE will create implicit sequence "jar_repository_jarid_seq" for serial column "jar_repository.jarid"psql:install.sql:23: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "jar_repository_pkey" for table "jar_repository"psql:install.sql:23: NOTICE: CREATE TABLE / UNIQUE will create implicit index "jar_repository_jarname_key" for table "jar_repository"CREATE TABLEGRANTpsql:install.sql:32: NOTICE: CREATE TABLE will create implicit sequence "jar_entry_entryid_seq" for serial column "jar_entry.entryid"psql:install.sql:32: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "jar_entry_pkey" for table "jar_entry"psql:install.sql:32: NOTICE: CREATE TABLE / UNIQUE will create implicit index "jar_entry_jarid_key" for table "jar_entry"CREATE TABLEGRANTALTER TABLEpsql:install.sql:43: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "classpath_entry_pkey" for table "classpath_entry"CREATE TABLEGRANTpsql:install.sql:50: NOTICE: CREATE TABLE will create implicit sequence "typemap_entry_mapid_seq" for serial column "typemap_entry.mapid"psql:install.sql:50: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "typemap_entry_pkey" for table "typemap_entry"CREATE TABLEGRANTpsql:install.sql:55: ERROR: language "java" does not existpsql:install.sql:59: ERROR: language "java" does not existpsql:install.sql:63: ERROR: language "java" does not existpsql:install.sql:67: ERROR: language "java" does not existpsql:install.sql:71: ERROR: language "java" does not existpsql:install.sql:75: ERROR: language "java" does not existpsql:install.sql:79: ERROR: language "java" does not existpsql:install.sql:83: ERROR: language "java" does not existpsql:install.sql:87: ERROR: language "java" does not exist# Terence Ng
> Date: Tue, 29 Jul 2008 11:15:19 -0600> From: books at ejurka.com> To: terencenwk at hotmail.com> CC: pljava-dev at pgfoundry.org> Subject: Re: language "java" does not exist> > Terence Ng wrote:> > > > After I set LD_LIBRARY_PATH and run uninstall.sql to clear previous > > installation, there still has an error saying "java" does not exit. > > Why? What did I miss?> > If your previous installation didn't get completely installed than the > uninstall will fail to uninstall some parts of it. That's expected. > Also if you run the uninstall script multiple times it should only do > something interesting on the first run. I believe you've sufficiently > uninstalled it to begin the installation again.> > Kris Jurka
_________________________________________________________________
Connect to the next generation of MSN Messenger?
http://imagine-msn.com/messenger/launch80/default.aspx?locale=en-us&source=wlmailtagline
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20080730/a2df9d67/attachment.html;
^ permalink raw reply [nested|flat] 7+ messages in thread
* [Pljava-dev] language "java" does not exist
2008-07-26 16:57 [Pljava-dev] language "java" does not exist
2008-07-29 17:15 ` [Pljava-dev] language "java" does not exist
2008-07-30 14:35 ` [Pljava-dev] language "java" does not exist
@ 2008-07-30 15:00 `
2008-07-30 16:32 ` [Pljava-dev] language "java" does not exist
0 siblings, 1 reply; 7+ messages in thread
From: @ 2008-07-30 15:00 UTC (permalink / raw)
Terence Ng wrote:
> I don't know why it cannot find libjvm.so and java. What should I do?
>
> # echo $LD_LIBRARY_PATH
> /usr/jdk/instances/jdk1.5.0/jre/lib/i386:/usr/jdk/instances
> /jdk1.5.0/jre/lib/i386/client:/usr/jdk/instances/jdk1.5.0/jre/lib/i386/native_threads
> psql:install.sql:6: ERROR: could not load library
> "/usr/postgres/8.2/lib/pljava.so": ld.so.1: postgres: fatal: libjvm.so:
> open failed: No such file or directory
Setting LD_LIBRARY_PATH in your current environment doesn't help. You
need it set in the server's environment.
Kris Jurka
^ permalink raw reply [nested|flat] 7+ messages in thread
* [Pljava-dev] language "java" does not exist
2008-07-26 16:57 [Pljava-dev] language "java" does not exist
2008-07-29 17:15 ` [Pljava-dev] language "java" does not exist
2008-07-30 14:35 ` [Pljava-dev] language "java" does not exist
2008-07-30 15:00 ` [Pljava-dev] language "java" does not exist
@ 2008-07-30 16:32 `
0 siblings, 0 replies; 7+ messages in thread
From: @ 2008-07-30 16:32 UTC (permalink / raw)
I am sorry. I do not have any idea to set the server's environment. Could you give me some hints, so that I can as least look for the instructions.
Thanks in advance,
Terence
> Date: Wed, 30 Jul 2008 09:00:29 -0600> From: books at ejurka.com> To: terencenwk at hotmail.com> CC: pljava-dev at pgfoundry.org> Subject: Re: language "java" does not exist> > Terence Ng wrote:> > I don't know why it cannot find libjvm.so and java. What should I do?> > > > # echo $LD_LIBRARY_PATH> > /usr/jdk/instances/jdk1.5.0/jre/lib/i386:/usr/jdk/instances > > /jdk1.5.0/jre/lib/i386/client:/usr/jdk/instances/jdk1.5.0/jre/lib/i386/native_threads> > > psql:install.sql:6: ERROR: could not load library > > "/usr/postgres/8.2/lib/pljava.so": ld.so.1: postgres: fatal: libjvm.so: > > open failed: No such file or directory> > Setting LD_LIBRARY_PATH in your current environment doesn't help. You > need it set in the server's environment.> > Kris Jurka
_________________________________________________________________
Explore the seven wonders of the world
http://search.msn.com/results.aspx?q=7+wonders+world&mkt=en-US&form=QBRE
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20080731/075bc417/attachment.html;
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2008-07-30 16:32 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-05-19 22:49 [Pljava-dev] language "java" does not exist
2005-05-21 07:30 `
2008-07-26 16:57 [Pljava-dev] language "java" does not exist
2008-07-29 17:15 `
2008-07-30 14:35 `
2008-07-30 15:00 `
2008-07-30 16:32 `
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox