ESQL can't connect to PostgreSQL

Hubert NEOtyk Iwaniuk Tue, 31 Jul 2001 06:15:06 -0700

Hi,

I have PostgreSQL 7.1 up and running on my Debian BOX,

JDBC driver (postgresql.jar) is in /usr/share/java, that is location

where all jars are placed.

Cocoon I v1.8.2, JServ v1.1.2, JDK 1.1.8v1.3.

I have searched archive, found similar problems, but non of them

told me why i can't connect to db.

Thanks,

Hubert NEOtyk Iwaniuk.

---
Ausgehende Mail ist zertifiziert virenfrei.
Uberpruft durch AVG Antivirus System (http://www.grisoft.com/de).
Version: 6.0.265 / Virendatenbank: 137 - Erstellungsdatum: 2001-07-18

<?xml version="1.0"?>
<!-- edited with XML Spy v3.5 NT (http://www.xmlspy.com) by Hubert NEOtyk Iwaniuk (private) -->
<?cocoon-process type="xsp"?>
<?cocoon-process type="xslt"?>
<?xml-stylesheet type="text/xsl" href="esql.xsl"?>
<xsp:page xmlns:xsp="http://www.apache.org/1999/XSP/Core"; xmlns:esql="http://apache.org/cocoon/SQL/v2";>
	<page>
		<esql:connection>
			<esql:driver>org.postgresql.Driver</esql:driver>
			<esql:dburl>jdbc:postgresql://localhost:5432/db_name</esql:dburl>
			<esql:username>db_user</esql:username>
			<esql:password>db_pass</esql:password>
			<esql:execute-query>
				<esql:query>select ID_hotel,Name_hotel from Hotel</esql:query>
				<esql:results>
					<header>header info</header>
					<esql:row-results>
						<hotel>
							<id>
								<esql:get-int column="ID_hotel"/>
							</id>
							<name>
								<esql:get-string column="Name_hotel"/>
							</name>
						</hotel>
					</esql:row-results>
					<footer>footer info</footer>
				</esql:results>
			</esql:execute-query>
		</esql:connection>
	</page>
</xsp:page>

Cocoon 1.8.2

Error found handling the request.

java.lang.RuntimeException: Error opening connection to dburl: jdbc:postgresql://localhost:5432/db_name
	at _home._huberti._public_html._esql.populateDocument(_esql.java)
	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:311)
	at org.apache.jserv.JServConnection.processRequest(JServConnection.java:317)
	at org.apache.jserv.JServConnection.run(JServConnection.java:188)
	at java.lang.Thread.run(Thread.java)

Warning: this page has been dynamically generated.

---------------------------------------------------------------------
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: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>

ESQL can't connect to PostgreSQL

Error found handling the request.

Reply via email to