Обсуждение: HELP: Error opening connection to dburl: jdbc:postgresql://localhost/test
HELP: Error opening connection to dburl: jdbc:postgresql://localhost/test
От
"Ivan Manuel Andrade Muñoz"
Дата:
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
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/