You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by mohamed ramzy <m_...@yahoo.com> on 2000/10/02 19:16:09 UTC
ESQL problem....URGENT
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/
Re: ESQL problem....URGENT
Posted by Viktors Rotanovs <vi...@riga.nu>.
Hi,
possibly you use PostgreSQL 7.0 and didn't
type org.postgresql.Driver instead of postgresql.Driver?
On Mon, 02 Oct 2000, you wrote:
> 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/
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
> For additional commands, e-mail: cocoon-users-help@xml.apache.org
--
Best Wishes,
Viktors Rotanovs
I create websites that attract more clients. http://riga.nu/
Riga Latvia +371, Phone 7377-142, GSM 9173-000, FAX 7377-472
Re: ESQL problem....URGENT
Posted by Donald Ball <ba...@webslingerZ.com>.
On Mon, 2 Oct 2000, mohamed ramzy wrote:
> <?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>
what output do you get if you remove the call to the xslt processor? can
you send me that and your generated java file from the repository?
- donald