agora inbox for pljava-dev@postgresql.org
help / color / mirror / Atom feed[Pljava-dev] Deployer error.
8+ messages / 0 participants
[nested] [flat]
* [Pljava-dev] Deployer error.
@ 2005-09-05 12:49
0 siblings, 1 reply; 8+ messages in thread
From: @ 2005-09-05 12:49 UTC (permalink / raw)
Hi all,
If anyone can help. I have installed Java with Postgres SQL Server on Linux 8.0 and when trying to run # java org.postgresql.pljava.deploy.Deployer -install I get "NoClassDef in main error". Written a simple java program and it runs fine.
Here's my /etc/profile environment variables :
JAVA_HOME=/usr/local/j2sdk1.4.2
POSTGRES_HOME=/usr/local/pgsql
PATH=$JAVA_HOME/bin:$JAVA_HOME/jre/bin:$POSTGRES_HOME/bin:$PATH
CLASSPATH=.:/usr/local/pljava/deploy.jar:/usr/local/pgsql/share/java/postgresql-8.0-312.jdbc3.jar
LD_LIBRARY_PATH=$JAVA_HOME/jre/lib/i386:$JAVA_HOME/jre/lib/i386/client:$JAVA_HOME/jre/lib/i386/server:$JAVA_HOME/jre/lib/i386/native_threads
/usr/local/pgsql/data/postgresql.conf file :
dynamic_library_path = '$libdir:/usr/local/pljava/'
custom_variable_classes = 'pljava'
log_min_messages = info
pljava.classpath = '/usr/local/pljava/pljava.jar'
pljava.statement_cache_size = 10
pljava.release_lingering_savepoints = true
pljava.vmoptions = '-Xmx64M'
pljava.debug = false
Postgres database and Java are both installed and working.
pljava is installed under /usr/local/ - can check pljava.classpath value above.
Maybe I'm missing something, please help.
Thanks in advance.
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20050905/d59daa1d/attachment.html;
^ permalink raw reply [nested|flat] 8+ messages in thread
* [Pljava-dev] Deployer error.
@ 2005-09-05 12:54
parent:
0 siblings, 1 reply; 8+ messages in thread
From: @ 2005-09-05 12:54 UTC (permalink / raw)
Hi,
You need to add pljava.jar inside the $CLASSPATH
`java -jar org.postgresql.pljava.deploy.Deployer -install`, otherwise
`java -cp ${DIR_TO_PLJAVA_JAR}/pljava.jar
org.postgresql.pljava.deploy.Deployer -install`
Regards,
Edward Yakop
On 9/5/05, Mncedisi Kheswa <pkheswa at yahoo.com> wrote:
> Hi all,
>
> If anyone can help. I have installed Java with Postgres SQL Server on Linux
> 8.0 and when trying to run # java
> org.postgresql.pljava.deploy.Deployer -install I get
> "NoClassDef in main error". Written a simple java program and it runs fine.
>
> Here's my /etc/profile environment variables :
> JAVA_HOME=/usr/local/j2sdk1.4.2
> POSTGRES_HOME=/usr/local/pgsql
> PATH=$JAVA_HOME/bin:$JAVA_HOME/jre/bin:$POSTGRES_HOME/bin:$PATH
> CLASSPATH=.:/usr/local/pljava/deploy.jar:/usr/local/pgsql/share/java/postgresql-8.0-312.jdbc3.jar
> LD_LIBRARY_PATH=$JAVA_HOME/jre/lib/i386:$JAVA_HOME/jre/lib/i386/client:$JAVA_HOME/jre/lib/i386/server:$JAVA_HOME/jre/lib/i386/native_threads
>
> /usr/local/pgsql/data/postgresql.conf file :
> dynamic_library_path = '$libdir:/usr/local/pljava/'
> custom_variable_classes = 'pljava'
> log_min_messages = info
> pljava.classpath = '/usr/local/pljava/pljava.jar'
> pljava.statement_cache_size = 10
> pljava.release_lingering_savepoints = true
> pljava.vmoptions = '-Xmx64M'
> pljava.debug = false
>
> Postgres database and Java are both installed and working.
> pljava is installed under /usr/local/ - can check pljava.classpath value
> above.
>
> Maybe I'm missing something, please help.
>
> Thanks in advance.
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>
>
>
^ permalink raw reply [nested|flat] 8+ messages in thread
* [Pljava-dev] Re: Deployer error.
@ 2005-09-05 14:15
parent:
0 siblings, 2 replies; 8+ messages in thread
From: @ 2005-09-05 14:15 UTC (permalink / raw)
Actually, that advice is incorrect. pljava.jar is not needed by the
deployer client program. It must only be seen by the backend server.
The problem is that you use the -jar option. You should not use the -jar
option when running the deployer. Given that the CLASSPATH is set the
way you describe you should try this instead:
java org.postgresql.pljava.deploy.Deployer -install
Regards,
Thomas Hallgren
Edward Yakop wrote:
> Hi,
>
> You need to add pljava.jar inside the $CLASSPATH
> `java -jar org.postgresql.pljava.deploy.Deployer -install`, otherwise
> `java -cp ${DIR_TO_PLJAVA_JAR}/pljava.jar
> org.postgresql.pljava.deploy.Deployer -install`
>
> Regards,
> Edward Yakop
>
> On 9/5/05, Mncedisi Kheswa <pkheswa at yahoo.com> wrote:
>
>>Hi all,
>>
>>If anyone can help. I have installed Java with Postgres SQL Server on Linux
>>8.0 and when trying to run # java
>>org.postgresql.pljava.deploy.Deployer -install I get
>>"NoClassDef in main error". Written a simple java program and it runs fine.
>>
>>Here's my /etc/profile environment variables :
>>JAVA_HOME=/usr/local/j2sdk1.4.2
>>POSTGRES_HOME=/usr/local/pgsql
>>PATH=$JAVA_HOME/bin:$JAVA_HOME/jre/bin:$POSTGRES_HOME/bin:$PATH
>>CLASSPATH=.:/usr/local/pljava/deploy.jar:/usr/local/pgsql/share/java/postgresql-8.0-312.jdbc3.jar
>>LD_LIBRARY_PATH=$JAVA_HOME/jre/lib/i386:$JAVA_HOME/jre/lib/i386/client:$JAVA_HOME/jre/lib/i386/server:$JAVA_HOME/jre/lib/i386/native_threads
>>
>>/usr/local/pgsql/data/postgresql.conf file :
>>dynamic_library_path = '$libdir:/usr/local/pljava/'
>>custom_variable_classes = 'pljava'
>>log_min_messages = info
>>pljava.classpath = '/usr/local/pljava/pljava.jar'
>>pljava.statement_cache_size = 10
>>pljava.release_lingering_savepoints = true
>>pljava.vmoptions = '-Xmx64M'
>>pljava.debug = false
>>
>>Postgres database and Java are both installed and working.
>>pljava is installed under /usr/local/ - can check pljava.classpath value
>>above.
>>
>>Maybe I'm missing something, please help.
>>
>>Thanks in advance.
>>
>>
>>__________________________________________________
>>Do You Yahoo!?
>>Tired of spam? Yahoo! Mail has the best spam protection around
>>http://mail.yahoo.com
>>_______________________________________________
>>Pljava-dev mailing list
>>Pljava-dev at gborg.postgresql.org
>>http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>>
>>
>>
^ permalink raw reply [nested|flat] 8+ messages in thread
* [Pljava-dev] Re: Deployer error.
@ 2005-09-05 14:15
parent:
0 siblings, 1 reply; 8+ messages in thread
From: @ 2005-09-05 14:15 UTC (permalink / raw)
Actually, that advice is incorrect. pljava.jar is not needed by the
deployer client program. It must only be seen by the backend server.
The problem is that you use the -jar option. You should not use the -jar
option when running the deployer. Given that the CLASSPATH is set the
way you describe you should try this instead:
java org.postgresql.pljava.deploy.Deployer -install
Regards,
Thomas Hallgren
Edward Yakop wrote:
> Hi,
>
> You need to add pljava.jar inside the $CLASSPATH
> `java -jar org.postgresql.pljava.deploy.Deployer -install`, otherwise
> `java -cp ${DIR_TO_PLJAVA_JAR}/pljava.jar
> org.postgresql.pljava.deploy.Deployer -install`
>
> Regards,
> Edward Yakop
>
> On 9/5/05, Mncedisi Kheswa <pkheswa at yahoo.com> wrote:
>
>>Hi all,
>>
>>If anyone can help. I have installed Java with Postgres SQL Server on Linux
>>8.0 and when trying to run # java
>>org.postgresql.pljava.deploy.Deployer -install I get
>>"NoClassDef in main error". Written a simple java program and it runs fine.
>>
>>Here's my /etc/profile environment variables :
>>JAVA_HOME=/usr/local/j2sdk1.4.2
>>POSTGRES_HOME=/usr/local/pgsql
>>PATH=$JAVA_HOME/bin:$JAVA_HOME/jre/bin:$POSTGRES_HOME/bin:$PATH
>>CLASSPATH=.:/usr/local/pljava/deploy.jar:/usr/local/pgsql/share/java/postgresql-8.0-312.jdbc3.jar
>>LD_LIBRARY_PATH=$JAVA_HOME/jre/lib/i386:$JAVA_HOME/jre/lib/i386/client:$JAVA_HOME/jre/lib/i386/server:$JAVA_HOME/jre/lib/i386/native_threads
>>
>>/usr/local/pgsql/data/postgresql.conf file :
>>dynamic_library_path = '$libdir:/usr/local/pljava/'
>>custom_variable_classes = 'pljava'
>>log_min_messages = info
>>pljava.classpath = '/usr/local/pljava/pljava.jar'
>>pljava.statement_cache_size = 10
>>pljava.release_lingering_savepoints = true
>>pljava.vmoptions = '-Xmx64M'
>>pljava.debug = false
>>
>>Postgres database and Java are both installed and working.
>>pljava is installed under /usr/local/ - can check pljava.classpath value
>>above.
>>
>>Maybe I'm missing something, please help.
>>
>>Thanks in advance.
>>
>>
>>__________________________________________________
>>Do You Yahoo!?
>>Tired of spam? Yahoo! Mail has the best spam protection around
>>http://mail.yahoo.com
>>_______________________________________________
>>Pljava-dev mailing list
>>Pljava-dev at gborg.postgresql.org
>>http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>>
>>
>>
^ permalink raw reply [nested|flat] 8+ messages in thread
* [Pljava-dev] Re: Deployer error.
@ 2005-09-05 14:19
parent:
1 sibling, 0 replies; 8+ messages in thread
From: @ 2005-09-05 14:19 UTC (permalink / raw)
Sorry, let me correct that. You don't use the -jar option. That was in
Edward's example :-)
Please tell me the exact error message and provide a stack backtrace.
- thomas
Thomas Hallgren wrote:
> Actually, that advice is incorrect. pljava.jar is not needed by the
> deployer client program. It must only be seen by the backend server.
>
> The problem is that you use the -jar option. You should not use the
> -jar option when running the deployer. Given that the CLASSPATH is set
> the way you describe you should try this instead:
>
> java org.postgresql.pljava.deploy.Deployer -install
>
> Regards,
> Thomas Hallgren
>
>
> Edward Yakop wrote:
>
>> Hi,
>>
>> You need to add pljava.jar inside the $CLASSPATH
>> `java -jar org.postgresql.pljava.deploy.Deployer -install`, otherwise
>> `java -cp ${DIR_TO_PLJAVA_JAR}/pljava.jar
>> org.postgresql.pljava.deploy.Deployer -install`
>>
>> Regards,
>> Edward Yakop
>>
>> On 9/5/05, Mncedisi Kheswa <pkheswa at yahoo.com> wrote:
>>
>>> Hi all,
>>> If anyone can help. I have installed Java with Postgres SQL Server
>>> on Linux
>>> 8.0 and when trying to run # java
>>> org.postgresql.pljava.deploy.Deployer -install I get
>>> "NoClassDef in main error". Written a simple java program and it
>>> runs fine.
>>> Here's my /etc/profile environment variables :
>>> JAVA_HOME=/usr/local/j2sdk1.4.2
>>> POSTGRES_HOME=/usr/local/pgsql
>>> PATH=$JAVA_HOME/bin:$JAVA_HOME/jre/bin:$POSTGRES_HOME/bin:$PATH
>>> CLASSPATH=.:/usr/local/pljava/deploy.jar:/usr/local/pgsql/share/java/postgresql-8.0-312.jdbc3.jar
>>>
>>> LD_LIBRARY_PATH=$JAVA_HOME/jre/lib/i386:$JAVA_HOME/jre/lib/i386/client:$JAVA_HOME/jre/lib/i386/server:$JAVA_HOME/jre/lib/i386/native_threads
>>>
>>>
>>> /usr/local/pgsql/data/postgresql.conf file : dynamic_library_path =
>>> '$libdir:/usr/local/pljava/'
>>> custom_variable_classes = 'pljava'
>>> log_min_messages = info
>>> pljava.classpath = '/usr/local/pljava/pljava.jar'
>>> pljava.statement_cache_size = 10
>>> pljava.release_lingering_savepoints = true
>>> pljava.vmoptions = '-Xmx64M'
>>> pljava.debug = false
>>>
>>> Postgres database and Java are both installed and working. pljava is
>>> installed under /usr/local/ - can check pljava.classpath value
>>> above.
>>> Maybe I'm missing something, please help.
>>> Thanks in advance.
>>>
>>> __________________________________________________
>>> Do You Yahoo!?
>>> Tired of spam? Yahoo! Mail has the best spam protection around
>>> http://mail.yahoo.com _______________________________________________
>>> Pljava-dev mailing list
>>> Pljava-dev at gborg.postgresql.org
>>> http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>>>
>>>
>>>
>
>
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/pljava-dev
^ permalink raw reply [nested|flat] 8+ messages in thread
* [Pljava-dev] Re: Deployer error.
@ 2005-09-05 14:39
parent:
1 sibling, 1 reply; 8+ messages in thread
From: @ 2005-09-05 14:39 UTC (permalink / raw)
Whoops,
He actually need the deploy.jar. But you're right. I made a mistake on
the java -jar option.
Sorry,
Edward Yakop
On 9/5/05, Thomas Hallgren <thhal at mailblocks.com> wrote:
> Sorry, let me correct that. You don't use the -jar option. That was in
> Edward's example :-)
>
> Please tell me the exact error message and provide a stack backtrace.
>
> - thomas
>
> Thomas Hallgren wrote:
>
> > Actually, that advice is incorrect. pljava.jar is not needed by the
> > deployer client program. It must only be seen by the backend server.
> >
> > The problem is that you use the -jar option. You should not use the
> > -jar option when running the deployer. Given that the CLASSPATH is set
> > the way you describe you should try this instead:
> >
> > java org.postgresql.pljava.deploy.Deployer -install
> >
> > Regards,
> > Thomas Hallgren
> >
> >
> > Edward Yakop wrote:
> >
> >> Hi,
> >>
> >> You need to add pljava.jar inside the $CLASSPATH
> >> `java -jar org.postgresql.pljava.deploy.Deployer -install`, otherwise
> >> `java -cp ${DIR_TO_PLJAVA_JAR}/pljava.jar
> >> org.postgresql.pljava.deploy.Deployer -install`
> >>
> >> Regards,
> >> Edward Yakop
> >>
> >> On 9/5/05, Mncedisi Kheswa <pkheswa at yahoo.com> wrote:
> >>
> >>> Hi all,
> >>> If anyone can help. I have installed Java with Postgres SQL Server
> >>> on Linux
> >>> 8.0 and when trying to run # java
> >>> org.postgresql.pljava.deploy.Deployer -install I get
> >>> "NoClassDef in main error". Written a simple java program and it
> >>> runs fine.
> >>> Here's my /etc/profile environment variables :
> >>> JAVA_HOME=/usr/local/j2sdk1.4.2
> >>> POSTGRES_HOME=/usr/local/pgsql
> >>> PATH=$JAVA_HOME/bin:$JAVA_HOME/jre/bin:$POSTGRES_HOME/bin:$PATH
> >>> CLASSPATH=.:/usr/local/pljava/deploy.jar:/usr/local/pgsql/share/java/postgresql-8.0-312.jdbc3.jar
> >>>
> >>> LD_LIBRARY_PATH=$JAVA_HOME/jre/lib/i386:$JAVA_HOME/jre/lib/i386/client:$JAVA_HOME/jre/lib/i386/server:$JAVA_HOME/jre/lib/i386/native_threads
> >>>
> >>>
> >>> /usr/local/pgsql/data/postgresql.conf file : dynamic_library_path =
> >>> '$libdir:/usr/local/pljava/'
> >>> custom_variable_classes = 'pljava'
> >>> log_min_messages = info
> >>> pljava.classpath = '/usr/local/pljava/pljava.jar'
> >>> pljava.statement_cache_size = 10
> >>> pljava.release_lingering_savepoints = true
> >>> pljava.vmoptions = '-Xmx64M'
> >>> pljava.debug = false
> >>>
> >>> Postgres database and Java are both installed and working. pljava is
> >>> installed under /usr/local/ - can check pljava.classpath value
> >>> above.
> >>> Maybe I'm missing something, please help.
> >>> Thanks in advance.
> >>>
> >>> __________________________________________________
> >>> Do You Yahoo!?
> >>> Tired of spam? Yahoo! Mail has the best spam protection around
> >>> http://mail.yahoo.com _______________________________________________
> >>> Pljava-dev mailing list
> >>> Pljava-dev at gborg.postgresql.org
> >>> http://gborg.postgresql.org/mailman/listinfo/pljava-dev
> >>>
> >>>
> >>>
> >
> >
> > _______________________________________________
> > Pljava-dev mailing list
> > Pljava-dev at gborg.postgresql.org
> > http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>
>
>
>
^ permalink raw reply [nested|flat] 8+ messages in thread
* [Pljava-dev] Re: Deployer error.
@ 2005-09-05 14:54
parent:
0 siblings, 0 replies; 8+ messages in thread
From: @ 2005-09-05 14:54 UTC (permalink / raw)
Right. And I just saw that the usage string printed by the deployer
states that the -jar option should be used. It won't work since running
java with a -jar option ignores a remote classpath setting. It assumes
that the classpath has been set in the manifest. It isn't since I have
no way of knowing what PostgreSQL driver that will be used or where it's
located.
So, please ignore the "java -jar" suggestion printed by the deployer
command usage string. It's incorrect.
- thomas
Edward Yakop wrote:
>Whoops,
>
>He actually need the deploy.jar. But you're right. I made a mistake on
>the java -jar option.
>
>Sorry,
>Edward Yakop
>
>On 9/5/05, Thomas Hallgren <thhal at mailblocks.com> wrote:
>
>
>>Sorry, let me correct that. You don't use the -jar option. That was in
>>Edward's example :-)
>>
>>Please tell me the exact error message and provide a stack backtrace.
>>
>>- thomas
>>
>>Thomas Hallgren wrote:
>>
>>
>>
>>>Actually, that advice is incorrect. pljava.jar is not needed by the
>>>deployer client program. It must only be seen by the backend server.
>>>
>>>The problem is that you use the -jar option. You should not use the
>>>-jar option when running the deployer. Given that the CLASSPATH is set
>>>the way you describe you should try this instead:
>>>
>>>java org.postgresql.pljava.deploy.Deployer -install
>>>
>>>Regards,
>>>Thomas Hallgren
>>>
>>>
>>>Edward Yakop wrote:
>>>
>>>
>>>
>>>>Hi,
>>>>
>>>>You need to add pljava.jar inside the $CLASSPATH
>>>>`java -jar org.postgresql.pljava.deploy.Deployer -install`, otherwise
>>>>`java -cp ${DIR_TO_PLJAVA_JAR}/pljava.jar
>>>>org.postgresql.pljava.deploy.Deployer -install`
>>>>
>>>>Regards,
>>>>Edward Yakop
>>>>
>>>>On 9/5/05, Mncedisi Kheswa <pkheswa at yahoo.com> wrote:
>>>>
>>>>
>>>>
>>>>>Hi all,
>>>>>If anyone can help. I have installed Java with Postgres SQL Server
>>>>>on Linux
>>>>>8.0 and when trying to run # java
>>>>>org.postgresql.pljava.deploy.Deployer -install I get
>>>>>"NoClassDef in main error". Written a simple java program and it
>>>>>runs fine.
>>>>>Here's my /etc/profile environment variables :
>>>>>JAVA_HOME=/usr/local/j2sdk1.4.2
>>>>>POSTGRES_HOME=/usr/local/pgsql
>>>>>PATH=$JAVA_HOME/bin:$JAVA_HOME/jre/bin:$POSTGRES_HOME/bin:$PATH
>>>>>CLASSPATH=.:/usr/local/pljava/deploy.jar:/usr/local/pgsql/share/java/postgresql-8.0-312.jdbc3.jar
>>>>>
>>>>>LD_LIBRARY_PATH=$JAVA_HOME/jre/lib/i386:$JAVA_HOME/jre/lib/i386/client:$JAVA_HOME/jre/lib/i386/server:$JAVA_HOME/jre/lib/i386/native_threads
>>>>>
>>>>>
>>>>>/usr/local/pgsql/data/postgresql.conf file : dynamic_library_path =
>>>>>'$libdir:/usr/local/pljava/'
>>>>>custom_variable_classes = 'pljava'
>>>>>log_min_messages = info
>>>>>pljava.classpath = '/usr/local/pljava/pljava.jar'
>>>>>pljava.statement_cache_size = 10
>>>>>pljava.release_lingering_savepoints = true
>>>>>pljava.vmoptions = '-Xmx64M'
>>>>>pljava.debug = false
>>>>>
>>>>>Postgres database and Java are both installed and working. pljava is
>>>>>installed under /usr/local/ - can check pljava.classpath value
>>>>>above.
>>>>>Maybe I'm missing something, please help.
>>>>>Thanks in advance.
>>>>>
>>>>>__________________________________________________
>>>>>Do You Yahoo!?
>>>>>Tired of spam? Yahoo! Mail has the best spam protection around
>>>>>http://mail.yahoo.com _______________________________________________
>>>>>Pljava-dev mailing list
>>>>>Pljava-dev at gborg.postgresql.org
>>>>>http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>_______________________________________________
>>>Pljava-dev mailing list
>>>Pljava-dev at gborg.postgresql.org
>>>http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>>>
>>>
>>
>>
>>
>>
^ permalink raw reply [nested|flat] 8+ messages in thread
* [Pljava-dev] Re: Deployer error.
@ 2005-09-06 06:30
0 siblings, 0 replies; 8+ messages in thread
From: @ 2005-09-06 06:30 UTC (permalink / raw)
The deployer will attempt to connect to a postmaster on 'localhost' and
port 5432 if you don't specify something else (using -host and -port
options)
Apparently, that fails. Is the postmaster running? Do you see any
messages in the postmaster log? Can you use the psql command?
Regards,
Thomas Hallgren
Mncedisi Kheswa wrote:
> Hi all,
>
> After I run this commnad "$ java org.postgresql.pljava.deploy.Deployer
> -install" I get these errors :
>
>
> org.postgresql.util.PSQLException: Connection refused. Check that the
> hostname and port are correct and that the postmaster is accepting
> TCP/IP connections.
>
> at
> org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:122)
>
> at
> org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:65)
>
> at
> org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:117)
>
> at
> org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
>
> at org.postgresql.jdbc3.Jdbc3Connection.<init>(Jdbc3Connection.java:24)
>
> at org.postgresql.Driver.connect(Driver.java:235)
>
> at java.sql.DriverManager.getConnection(DriverManager.java:512)
>
> at java.sql.DriverManager.getConnection(DriverManager.java:171)
>
> at org.postgresql.pljava.deploy.Deployer.main(Deployer.java:259)
>
> Caused by: java.net.ConnectException: Connection timed out
>
> at java.net.PlainSocketImpl.socketConnect(Native Method)
>
> at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:305)
>
> at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:171)
>
> at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:158)
>
> at java.net.Socket.connect(Socket.java:452)
>
> at java.net.Socket.connect(Socket.java:402)
>
> at java.net.Socket.<init>(Socket.java:309)
>
> at java.net.Socket.<init>(Socket.java:124)
>
> at org.postgresql.core.PGStream.<init>(PGStream.java:58)
>
> at
> org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:77)
>
> ... 8 more
>
> The java version is 1.4. I have included pljava.jar in CLASSPATH and
> its also in pljava.classpath in postgresql.conf.
>
> Thanks in advance.
> Paul Kheswa.
>
> */Thomas Hallgren <thhal at mailblocks.com>/* wrote:
>
> Right. And I just saw that the usage string printed by the deployer
> states that the -jar option should be used. It won't work since
> running
> java with a -jar option ignores a remote classpath setting. It
> assumes
> that the classpath has been set in the manifest. It isn't since I
> have
> no way of knowing what PostgreSQL driver that will be used or
> where it's
> located.
>
> So, please ignore the "java -jar" suggestion printed by the deployer
> command usage string. It's incorrect.
>
> - thomas
>
> Edward Yakop wrote:
>
> >Whoops,
> >
> >He actually need the deploy.jar. But you're right. I made a
> mistake on
> >the java -jar option.
> >
> >Sorry,
> >Edward Yakop
> >
> >On 9/5/05, Thomas Hallgren wrote:
> >
> >
> >>Sorry, let me correct that. You don't use the -jar option. That
> was in
> >>Edward's example :-)
> >>
> >>Please tell me the exact error message and provide a stack
> backtrace.
> >>
> >>- thomas
> >>
> >>Thomas Hallgren wrote:
> >>
> >>
> >>
> >>>Actually, that advice is incorrect. pljava.jar is not needed by the
> >>>deployer client program. It must only be seen by the backend
> server.
> >>>
> >>>The problem is that you use the -jar option. You should not use the
> >>>-jar option when running the deployer. Given that the CLASSPATH
> is set
> >>>the way you describe you should try this instead:
> >>>
> >>>java org.postgresql.pljava.deploy.Deployer -install
> >>>
> >>>Regards,
> >>>Thomas Hallgren
> >>>
> >>>
> >>>Edward Yakop wrote:
> >>>
> >>>
> >>>
> >>>>Hi,
> >>>>
> >>>>You need to add pljava.jar inside the $CLASSPATH
> >>>>`java -jar org.postgresql.pljava.deploy.Deployer -install`,
> otherwise
> >>>>`java -cp ${DIR_TO_PLJAVA_JAR}/pljava.jar
> >>>>org.postgresql.pljava.deploy.Deployer -install`
> >>>>
> >>>>Regards,
> >>>>Edward Yakop
> >>>>
> >>>>On 9/5/05, Mncedisi Kheswa wrote:
> >>>>
> >>>>
> >>>>
> >>>>>Hi all,
> >>>>>If anyone can help. I have installed Java with Postgres SQL
> Server
> >>>>>on Linux
> >>>>>8.0 and when trying to run # java
> >>>>>org.postgresql.pljava.deploy.Deployer -install I get
> >>>>>"NoClassDef in main error". Written a simple java program and it
> >>>>>runs fine.
> >>>>>Here's my /etc/profile environment variables :
> >>>>>JAVA_HOME=/usr/local/j2sdk1.4.2
> >>>>>POSTGRES_HOME=/usr/local/pgsql
> >>>>>PATH=$JAVA_HOME/bin:$JAVA_HOME/jre/bin:$POSTGRES_HOME/bin:$PATH
> >>>>>CLASSPATH=.:/usr/local/pljava/deploy.jar:/usr/local/pgsql/share/java/postgresql-8.0-312.jdbc3.jar
> >>>>>
> >>>>>LD_LIBRARY_PATH=$JAVA_HOME/jre/lib/i386:$JAVA_HOME/jre/lib/i386/client:$JAVA_HOME/jre/lib/i386/server:$JAVA_HOME/jre/lib/i386/native_threads
> >>>>>
> >>>>>
> >>>>>/usr/local/pgsql/data/postgresql.conf file :
> dynamic_library_path =
> >>>>>'$libdir:/usr/local/pljava/'
> >>>>>custom_variable_classes = 'pljava'
> >>>>>log_min_messages = info
> >>>>>pljava.classpath = '/usr/local/pljava/pljava.jar'
> >>>>>pljava.statement_cache_size = 10
> >>>>>pljava.release_lingering_savepoints = true
> >>>>>pljava.vmoptions = '-Xmx64M'
> >>>>>pljava.debug = false
> >>>>>
> >>>>>Postgres database and Java are both installed and working.
> pljava is
> >>>>>installed under /usr/local/ - can check pljava.classpath value
> >>>>>above.
> >>>>>Maybe I'm missing something, please help.
> >>>>>Thanks in advance.
> >>>>>
> >>>>>__________________________________________________
> >>>>>Do You Yahoo!?
> >>>>>Tired of spam? Yahoo! Mail has the best spam protection around
> >>>>>http://mail.yahoo.com
> _______________________________________________
> >>>>>Pljava-dev mailing list
> >>>>>Pljava-dev at gborg.postgresql.org
> >>>>>http://gborg.postgresql.org/mailman/listinfo/pljava-dev
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>_______________________________________________
> >>>Pljava-dev mailing list
> >>>Pljava-dev at gborg.postgresql.org
> >>>http://gborg.postgresql.org/mailman/listinfo/pljava-dev
> >>>
> >>>
> >>
> >>
> >>
> >>
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>
^ permalink raw reply [nested|flat] 8+ messages in thread
end of thread, other threads:[~2005-09-06 06:30 UTC | newest]
Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-09-05 12:49 [Pljava-dev] Deployer error.
2005-09-05 12:54 `
2005-09-05 14:15 `
2005-09-05 14:15 `
2005-09-05 14:19 `
2005-09-05 14:39 `
2005-09-05 14:54 `
2005-09-06 06:30 [Pljava-dev] Re: Deployer error.
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox