Re: HELP: Error opening connection to dburl: jdbc:postgresql://localhost/test - Mailing list pgsql-jdbc

From Ned Wolpert
Subject Re: HELP: Error opening connection to dburl: jdbc:postgresql://localhost/test
Date
Msg-id 20020119160552.34047.qmail@web13402.mail.yahoo.com
Whole thread Raw
In response to HELP: Error opening connection to dburl: jdbc:postgresql://localhost/test  ("Ivan Manuel Andrade Muñoz"<iandrade75@hotmail.com>)
List pgsql-jdbc
First, the standard things to check... ;-)

a) is postgres running?

b) does $PGSQL_HOME/data/pg_hba.conf allow for
remote access? (like  having this line in it:
  host       all         0.0.0.0     0.0.0.0    password
or whatever your security you want turned on?

c) Are you running the server with the '-i' switch on?

d) Is the username/password set right and has access to the database
test?  (How did you set it in the XSP page?)

Given that the above is set correctly, is there a second except that
gets printed out? (Like a root exception?)  This is just the xsp
exception that wraps the real one.  Also, if you can provide the xsp
page segment that is failing, that would also help.

--- Ivan Manuel Andrade Mu�oz <iandrade75@hotmail.com> wrote:
>
>
>
>
> Hello to all, Happy New Year.
>
> The error is:
>
>
***********************************************************************************************
>
-----------------------------------------------------------------------------------------------
> Cocoon 1.8.2
>
-----------------------------------------------------------------------------------------------
>
>                 Error found handling the request.
>
> java.lang.RuntimeException: Error opening connection to dburl:
> jdbc:postgresql://localhost/test
>         at
>
_usr._local._jakarta._build._tomcat._webapps._cocoon._samples._sql._esql.populateDocument(_esql.java:162)
>         at
> org.apache.cocoon.processor.xsp.XSPPage.getDocument(XSPPage.java:97)
>         at
>
org.apache.cocoon.processor.xsp.XSPProcessor.process(XSPProcessor.java:527)
>         at org.apache.cocoon.Engine.handle(Engine.java:384)
>         at org.apache.cocoon.Cocoon.service(Cocoon.java:183)
>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:865)
>         at
> org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:405)
>         at org.apache.tomcat.core.Handler.service(Handler.java:287)
>         at
> org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
>         at
>
org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:812)
>         at
> org.apache.tomcat.core.ContextManager.service(ContextManager.java:758)
>         at
>
org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:213)
>         at
>
org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
>         at
>
org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:501)
>         at java.lang.Thread.run(Thread.java:484)
>
>
-----------------------------------------------------------------------------------------------
>
> Warning: this page has been dynamically generated.
>
> Copyright (c) 1999-2001 The Apache XML Project.
> All rights reserved.
>
------------------------------------------------------------------------------------------------
>
************************************************************************************************
> I have installed:
>
> Red Hat Linux 7.2
> Sun JDK 1.3.1_01
> Apache 1.3.19
> Tomcat 3.2.3
> Cocoon 1.8.2
> Postgresql 7.1.3
> jdbc7.1-1.2
> -------------------------
> Note: form postgresql 7.1.3, with the option -- with-java
>
> I have formed my archive:
>
> My file .bash_profile.
> ------------------------------------------------------------
> # .bash_profile
>
> # Get the aliases and functions
> if [ -f ~/.bashrc ]; then
>        . ~/.bashrc
> fi
>
> # User specific environment and startup programs
>
> JAKARTA_HOME=/usr/local/jakarta
> ANT_HOME=$JAKARTA_HOME/jakarta-ant
>
PATH=$PATH:$HOME/bin:/usr/java/jdk1.3.1_01/bin:$ANT_HOME/bootstrap/bin:/usr/local/pgsql/bin
> BASH_ENV=$HOME/.bashrc
> USERNAME="root"
> JAVA_HOME=/usr/java/jdk1.3.1_01
> #JAKARTA_HOME=/usr/local/jakarta
> #ANT_HOME=$JAKARTA_HOME/jakarta-ant
> TOMCAT_HOME=$JAKARTA_HOME/build/tomcat
> COCOON_HOME=/usr/local/cocoon1.8.2/
> PG=/usr/local/pgsql
> PGLIB=$PG/lib
> PGDATA=$PG/data
> MANPATH=$MANPATH:$PG/man
> CLASSPATH=/usr/local/jdbc7.1-1.2.jar
> export USERNAME BASH_ENV JAVA_HOME JAKARTA_HOME ANT_HOME TOMCAT_HOME
> COCOON_HOME PATH CLASSPATH
>
-----------------------------------------------------------------------------------------------
>
>
>
>
>
>
> _________________________________________________________________
> Con MSN Hotmail s�mese al servicio de correo electr�nico m�s grande del
> mundo. http://www.hotmail.com/ES
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)


=====
Virtually,        |                   "Must you shout too?"
Ned Wolpert       |                                  -Dante
wolpert@yahoo.com |
_________________/              "Who watches the watchmen?"
4e75                                       -Juvenal, 120 AD

-- Place your commercial here --                      fnord

__________________________________________________
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/

pgsql-jdbc by date:

Previous
From: Dustin Sallings
Date:
Subject: DatabaseMetaData.getTables() ignoring a table?
Next
From: Bruce Momjian
Date:
Subject: Re: Patches for DatabaseMetaData.java for Postgresql 7.1.3 (sorry,