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