cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From mohamed ramzy <m_ra...@yahoo.com>
Subject ESQL problem....URGENT
Date Mon, 02 Oct 2000 17:16:09 GMT
hi
i've upgraded my cocoon from 1,.7.2 to 1.8 which is a
cvs version, as i'm trying to use esql
i've added to the cocoon.properties file the following
line:

processor.xsp.logicsheet.esql.java =
resource://org/apache/cocoon/processor/xsp/library/sql/esql.xsl

then i've checked the postgresql Driver, by writing a
java class, and it works ok

then i wrote the following xml file

<?xml version="1.0"?>
<?xml-stylesheet href="tstdb-esql.xsl"
type="text/xsl"?>
<?cocoon-process type="xsp"?>
<?cocoon-process type="xslt"?>
<xsp:page
  language="java"
  xmlns:esql="http://apache.org/cocoon/SQL/v2"
  xmlns:xsp="http://www.apache.org/1999/XSP/Core">

<page>

<esql:execute-query>
<esql:driver>postgresql.Driver</esql:driver>
<esql:dburl>jdbc:postgresql://localhost/mrz</esql:dburl>
<esql:username>mrz</esql:username>
<esql:password>mrz</esql:password>
<esql:query>select * from usr</esql:query>
<esql:results>
  <id><esql:get-string column="id"/></id>
<fname><esql:get-string column="fname"/></fname>
<lname><esql:get-string column="lname"/></lname>
<bgcolr><esql:get-string column="bgcolr"/></bgcolr>
</esql:results>

<esql:no-results>
 <error>no results were found</error>
</esql:no-results>

<esql:error-results>
 <message><esql:get-message/></message>
 <stacktrace><esql:get-stacktrace/></stacktrace>
</esql:error-results>

</esql:execute-query>

</page>

</xsp:page>

and when i try this file all what i get is 

postgresql.Driver

that's all, so what do u think the problem is???

i've checked
- the Driver is working
-the Database pgsql is workig
- cocoon 1.8 cvs can use the esql

what shall i do.

Thanx in Advance

=====
Mohamed Ramzy Zakaria, Graduate Research student
School of Computer Science & Information Technology
Jubilee Campus, Nottingham University
Nottingham, UK
TEL: 00 44 (0)115 84 66529
MOB: 00 44 (0)7947105251
MOB E-MAIL: m_ramzy@quios.com

__________________________________________________
Do You Yahoo!?
Yahoo! Photos - 35mm Quality Prints, Now Get 15 Free!
http://photos.yahoo.com/

Mime
View raw message