cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ivan Manuel Andrade Muñoz" <iandrad...@hotmail.com>
Subject HELP,HELP PLEASE : Error opening connection to dburl:
Date Tue, 29 Jan 2002 13:50:22 GMT
<html><div style='background-color:'><DIV><FONT face="Courier New">Hello
ALL. <BR><BR>The error is: <BR><BR>**************************************************************
<BR><BR>------------------------------------------------------------------ <BR>Cocoon
1.8.2 <BR>------------------------------------------------------------------ <BR><BR>Error
found handling the request. <BR><BR>java.lang.RuntimeException: Error opening
connection to dburl: <BR>jdbc:postgresql://localhost/test <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
at <BR><BR>_usr._local._jakarta._build._tomcat._webapps._cocoon._samples._sql._esql.pop
<BR>ulateDocument(_esql.java:162) <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
at <BR>org.apache.cocoon.processor.xsp.XSPPage.getDocument(XSPPage.java:97) <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
at <BR><BR>org.apache.cocoon.processor.xsp.XSPProcessor.process(XSPProcessor.java:527)
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.cocoon.Engine.handle(Engine.java:384)
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.cocoon.Cocoon.service(Cocoon.java:183)
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at javax.servlet.http.HttpServlet.service(HttpServlet.java:865)
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at <BR>org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:405)
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.tomcat.core.Handler.service(Handler.java:287)
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at <BR>org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at <BR><BR>org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:81
<BR>2) <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
at <BR>org.apache.tomcat.core.ContextManager.service(ContextManager.java:758) <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
at <BR><BR>org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpC
<BR>onnectionHandler.java:213) <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
at <BR>org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416) <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
at <BR>org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:501) <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
at java.lang.Thread.run(Thread.java:484) <BR><BR>--------------------------------------------------------------
<BR>Warning: this page has been dynamically generated. <BR>Copyright (c) 1999-2001
The Apache XML Project. <BR>All rights reserved. <BR>--------------------------------------------------------------
<BR><BR>*************************************************************** <BR><BR>I
have installed: <BR><BR>Red Hat Linux 7.2 <BR>Sun JDK 1.3.1_01 <BR>Apache
1.3.19 <BR>Tomcat 3.2.3 <BR>Cocoon 1.8.2 <BR>Postgresql 7.1.3 <BR>jdbc7.1-1.2
<BR>------------------------- <BR>Note: form postgresql 7.1.3, with the option
-- with-java <BR><BR>I have formed my archive: <BR><BR>My file .bash_profile.
<BR>------------------------------------------------------------ <BR># .bash_profile
<BR><BR># User specific environment and startup programs <BR><BR>JAKARTA_HOME=/usr/local/jakarta
<BR>ANT_HOME=$JAKARTA_HOME/jakarta-ant <BR><BR>PATH=$PATH:$HOME/bin:/usr/java/jdk1.3.1_01/bin:$ANT_HOME/bootstrap/bin:/usr/
<BR>local/pgsql/bin <BR>BASH_ENV=$HOME/.bashrc <BR>USERNAME="root" <BR>JAVA_HOME=/usr/java/jdk1.3.1_01
<BR>#JAKARTA_HOME=/usr/local/jakarta <BR>#ANT_HOME=$JAKARTA_HOME/jakarta-ant <BR>TOMCAT_HOME=$JAKARTA_HOME/build/tomcat
<BR>COCOON_HOME=/usr/local/cocoon1.8.2/ <BR>PG=/usr/local/pgsql <BR>PGLIB=$PG/lib
<BR>MANPATH=$MANPATH:$PG/man <BR>CLASSPATH=/usr/local/jdbc7.1-1.2.jar <BR>export
USERNAME BASH_ENV JAVA_HOME JAKARTA_HOME ANT_HOME TOMCAT_HOME <BR>COCOON_HOME PATH CLASSPATH
<BR>-------------------------------------------------------------------------- <BR><BR>My
archive esql.xml is: <BR><BR>&lt;?cocoon-process type="xslt"?&gt; <BR>&lt;?xml-stylesheet
type="text/xsl" href="esql.xsl"?&gt; <BR><BR>&lt;xsp:page <BR>xmlns:xsp="</FONT><A
target=_blank href="http://64.4.16.250/cgi-bin/linkrd?_lang=ES&amp;lah=c0e944bbf81b332db019660084ec80dd&amp;lat=1012312117&amp;hm___action=http%3a%2f%2fwww%2eapache%2eorg%2f1999%2fXSP%2fCore"><FONT
face="Courier New" color=#000099>http://www.apache.org/1999/XSP/Core</FONT></A><FONT
face="Courier New">" <BR>xmlns:esql="</FONT><A target=_blank href="http://64.4.16.250/cgi-bin/linkrd?_lang=ES&amp;lah=8eda3bcfc254a16a96b1cbafa0fec60b&amp;lat=1012312117&amp;hm___action=http%3a%2f%2fapache%2eorg%2fcocoon%2fSQL%2fv2"><FONT
face="Courier New" color=#000099>http://apache.org/cocoon/SQL/v2</FONT></A><FONT
face="Courier New">" <BR></FONT>
<TABLE>
<TBODY>
<TR>
<TD width=1 bgColor=#cccccc>&nbsp;</TD>
<TD width=5>&nbsp;</TD>
<TD><TT><BR></TT></TD></TR></TBODY></TABLE><TT><BR>&lt;page&gt;
<BR><BR>&lt;esql:connection&gt; <BR>&lt;esql:driver&gt;org.postgresql.Driver&lt;/esql:driver&gt;
<BR>&lt;esql:dburl&gt;jdbc:postgresql://localhost/test&lt;/esql:dburl&gt;
<BR>&lt;esql:username&gt;postgres&lt;/esql:username&gt; <BR>&lt;esql:password&gt;postgres&lt;/esql:password&gt;
<BR>&lt;esql:execute-query&gt; <BR>&nbsp;&nbsp; &lt;esql:query&gt;select
id,name from department_table&lt;/esql:query&gt; <BR>&nbsp;&nbsp; &lt;esql:results&gt;
<BR>&nbsp;&nbsp;&nbsp;&nbsp; &lt;header&gt;header info&lt;/header&gt;
<BR>&nbsp;&nbsp;&nbsp;&nbsp; &lt;esql:row-results&gt; <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&lt;department&gt; <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&lt;id&gt;&lt;esql:get-int column="id"/&gt;&lt;/id&gt; <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&lt;name&gt;&lt;esql:get-string column="name"/&gt;&lt;/name&gt; <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&lt;esql:connection&gt; <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&lt;esql:driver&gt;org.postgresql.Driver&lt;/esql:driver&gt; <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&lt;esql:dburl&gt;jdbc:postgresql://localhost/test&lt;/esql:dburl&gt; <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&lt;esql:username&gt;test&lt;/esql:username&gt; <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&lt;esql:password&gt;test&lt;/esql:password&gt; <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&lt;esql:execute-query&gt; <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&lt;esql:query&gt;select name from user_table where department_id = <BR>&lt;esql:parameter
type="int"&gt;&lt;esql:get-int ancestor="1" <BR>column="id"/&gt;&lt;/esql:parameter&gt;&lt;/esql:query&gt;
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&lt;esql:results&gt; <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&lt;esql:row-results&gt; <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&lt;user&gt;&lt;esql:get-string column="name"/&gt;&lt;/user&gt; <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&lt;/esql:row-results&gt; <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&lt;/esql:results&gt; <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&lt;esql:no-results&gt; <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&lt;user&gt;No employees&lt;/user&gt; <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&lt;/esql:no-results&gt; <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&lt;/esql:execute-query&gt; <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&lt;/esql:connection&gt; <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&lt;/department&gt; <BR>&nbsp;&nbsp;&nbsp;&nbsp; &lt;/esql:row-results&gt;
<BR>&nbsp;&nbsp;&nbsp;&nbsp; &lt;footer&gt;footer info&lt;/footer&gt;
<BR>&nbsp;&nbsp; &lt;/esql:results&gt; <BR>&lt;/esql:execute-query&gt;
<BR>&lt;/esql:connection&gt; <BR><BR>&lt;/page&gt; <BR><BR>&lt;/xsp:page&gt;
<BR>----------------------------------------------------------------- <BR>Where
test, is my data base poststoneware is the account that I use to raise <BR>the postmaster
and to enter my data base. <BR><BR>For example, in my data base test:To me it
shows <BR><BR>test=# select * from pg_user; <BR>usename&nbsp; | usesysid
| usecreatedb | usetrace | usesuper | usecatupd | <BR>passwd&nbsp; | valuntil <BR>----------+----------+-------------+----------+----------+-----------+----------+----------
<BR>postgres |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 420 | t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
| t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
| t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | <BR>********
| <BR>(1 row) <BR><BR>That you would recommend to me to do?. <BR>To
change something in esql.xml?. <BR>As the username and password of my data base in postmaster?.
<BR>As I create a username to him and password to a data base?. <BR><BR>From
already thanks for your aid. <BR>Ivan Manuel Andrade Muñoz. <BR>Punta Arenas.
<BR>Chile. <BR>FONO: (061) 243046 <BR></TT></DIV></div><br
clear=all><hr>MSN Photos es la manera más sencilla de compartir e imprimir sus fotos.
<a href='http://go.msn.com/bql/hmtag2_etl_ES.asp'>http://photos.latam.msn.com/Support/WorldWide.aspx</a><br></html>

---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>

To unsubscribe, e-mail: <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail: <cocoon-users-help@xml.apache.org>


Mime
View raw message