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/05/26 16:52:41 UTC
The Same Problem with SQL!!!!
hi
i've checked the port of MySql server and also checked
the configuration of the SQL processor in the
cocoon.properties file...
but the same problem as i've described below....
please if u have any solution....Help me.
Thanks in Advance
--- mohamed ramzy <m_...@yahoo.com> wrote:
> hi...
>
> i've removed the trailing ? from the end of my
> driver
> name but NOTHING happened....
>
> plz i need help..
> Thanx
> --- Donald Ball <ba...@webslingerZ.com> wrote:
> > Remove the trailing ? at the end of your driver
> > name.
> >
> > - donald
> >
> > On Thu, 25 May 2000, mohamed ramzy wrote:
> >
> > > hi
> > > i'm sorry if my question is silly, but i'm new
> > with
> > > the sql with cocoon.
> > >
> > > i wrote an xml file which is
> > >
> > > <?xml-stylesheet href="tst-db.xsl"
> > type="text/xsl"?>
> > > <?cocoon-process type="sql"?>
> > > <?cocoon-process type="xslt"?>
> > >
> > > <tst>
> > > <connectiondefs>
> > > <connection name="first">
> > > <driver>org.gjt.mm.mysql.Driver?</driver>
> > >
> >
>
<dburl>jdbc:mysql://pawpaw.cs.nott.ac.uk:8080/~mrz/Ramzy1</dburl>
> > > <username>mrz</username>
> > > <password>zocka</password>
> > > </connection>
> > > </connectiondefs>
> > >
> > > <query connection="first">
> > > select *
> > > from pet
> > > </query>
> > > </tst>
> > >
> >
>
******************************************************
> > >
> > > and the XSL file is
> > > *******************
> > > <?xml version="1.0"?>
> > > <xsl:stylesheet
> > >
> xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
> > > <xsl:template match="tst">
> > > <html>
> > > <head/>
> > > <body>
> > > <xsl:apply-templates />
> > > </body>
> > > </html>
> > > </xsl:template>
> > >
> > > <xsl:template match="ROWSET">
> > > <table border="2" cellspacing="1"
> cellpadding="6">
> > > <tr>
> > > <th>Name</th>
> > > <th>Owner</th>
> > > <th>Species</th>
> > > <th>Sex</th>
> > > <th>Birth</th>
> > > <th>Death</th>
> > > </tr>
> > > <xsl:for-each select="ROW">
> > > <tr>
> > > <td><xsl:value-of select="name"/></td>
> > > <td><xsl:value-of select="owner"/></td>
> > > <td><xsl:value-of select="species"/></td>
> > > <td><xsl:value-of select="sex"/></td>
> > > <td><xsl:value-of select="birth"/></td>
> > > <td><xsl:value-of select="death"/></td>
> > > </tr>
> > > </xsl:for-each>
> > > </table>
> > > </xsl:template>
> > > </xsl:stylesheet>
> > >
> > > the problem
> > > ************
> > > when i try to access the xml file by cocoon.
> > > it just prints what is written between the tags
> of
> > the
> > > XML file and nothing more
> > > which is:
> > >
> > > org.gjt.mm.mysql.Driver?
> > >
> jdbc:mysql://pawpaw.cs.nott.ac.uk:8080/~mrz/Ramzy1
> > mrz
> > > zocka select * from pet
> > >
> > > i did the configuration as described in the
> apache
> > sql
> > > instructions.
> > > would u plz help me to find what is the
> > problem....
> > >
> > > Thanx in Advance
> > >
> > >
> __________________________________________________
> > > Do You Yahoo!?
> > > Kick off your party with Yahoo! Invites.
> > > http://invites.yahoo.com/
> > >
> > >
> >
>
---------------------------------------------------------------------
> > > To unsubscribe, e-mail:
> > cocoon-users-unsubscribe@xml.apache.org
> > > For additional commands, e-mail:
> > cocoon-users-help@xml.apache.org
> > >
> > >
> >
> >
> >
>
---------------------------------------------------------------------
> > To unsubscribe, e-mail:
> > cocoon-users-unsubscribe@xml.apache.org
> > For additional commands, e-mail:
> > cocoon-users-help@xml.apache.org
> >
>
>
> __________________________________________________
> Do You Yahoo!?
> Kick off your party with Yahoo! Invites.
> http://invites.yahoo.com/
>
>
---------------------------------------------------------------------
> To unsubscribe, e-mail:
> cocoon-users-unsubscribe@xml.apache.org
> For additional commands, e-mail:
> cocoon-users-help@xml.apache.org
>
__________________________________________________
Do You Yahoo!?
Kick off your party with Yahoo! Invites.
http://invites.yahoo.com/
Re: The Same Problem with SQL!!!!
Posted by sudhi <su...@planet.net>.
Here is some of my thoughts,
Is your driver jar file in the class path (in jserv.properties) ?
It will not execute your sql statement if its not able to find the
driver.
What you can do is write a simple java class which connects to the
database and execute it .
Even I tried removing the jar file from the classpath. Then I got the
same problem as yours.
HTH
Sudhi
Re: The Same Problem with SQL!!!!
Posted by Nishit Trivedi <ni...@planet.net>.
Make sure you have folliwing line after style sheet declaration in your xsl
file.
----------------------------------------------------------------------------
--------------------------
<xsl:processing-instruction
name="cocoon-format">type="text/html"</xsl:processing-instruction>
----------------------------------------------------------------------------
--------------------------
if that doesn't work, try replacing
<xsl:template match="tst">
with
<xsl:template match="/"><!--This will match with root element -->
good luck..
Nishit
Internet Programmer
Planet Access Networks
973-691-4704 Ext:157
----- Original Message -----
From: "mohamed ramzy" <m_...@yahoo.com>
To: <co...@xml.apache.org>
Sent: Friday, May 26, 2000 10:52 AM
Subject: The Same Problem with SQL!!!!
> hi
> i've checked the port of MySql server and also checked
> the configuration of the SQL processor in the
> cocoon.properties file...
> but the same problem as i've described below....
>
>
> please if u have any solution....Help me.
>
> Thanks in Advance
>
> --- mohamed ramzy <m_...@yahoo.com> wrote:
> > hi...
> >
> > i've removed the trailing ? from the end of my
> > driver
> > name but NOTHING happened....
> >
> > plz i need help..
> > Thanx
> > --- Donald Ball <ba...@webslingerZ.com> wrote:
> > > Remove the trailing ? at the end of your driver
> > > name.
> > >
> > > - donald
> > >
> > > On Thu, 25 May 2000, mohamed ramzy wrote:
> > >
> > > > hi
> > > > i'm sorry if my question is silly, but i'm new
> > > with
> > > > the sql with cocoon.
> > > >
> > > > i wrote an xml file which is
> > > >
> > > > <?xml-stylesheet href="tst-db.xsl"
> > > type="text/xsl"?>
> > > > <?cocoon-process type="sql"?>
> > > > <?cocoon-process type="xslt"?>
> > > >
> > > > <tst>
> > > > <connectiondefs>
> > > > <connection name="first">
> > > > <driver>org.gjt.mm.mysql.Driver?</driver>
> > > >
> > >
> >
> <dburl>jdbc:mysql://pawpaw.cs.nott.ac.uk:8080/~mrz/Ramzy1</dburl>
> > > > <username>mrz</username>
> > > > <password>zocka</password>
> > > > </connection>
> > > > </connectiondefs>
> > > >
> > > > <query connection="first">
> > > > select *
> > > > from pet
> > > > </query>
> > > > </tst>
> > > >
> > >
> >
> ******************************************************
> > > >
> > > > and the XSL file is
> > > > *******************
> > > > <?xml version="1.0"?>
> > > > <xsl:stylesheet
> > > >
> > xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
> > > > <xsl:template match="tst">
> > > > <html>
> > > > <head/>
> > > > <body>
> > > > <xsl:apply-templates />
> > > > </body>
> > > > </html>
> > > > </xsl:template>
> > > >
> > > > <xsl:template match="ROWSET">
> > > > <table border="2" cellspacing="1"
> > cellpadding="6">
> > > > <tr>
> > > > <th>Name</th>
> > > > <th>Owner</th>
> > > > <th>Species</th>
> > > > <th>Sex</th>
> > > > <th>Birth</th>
> > > > <th>Death</th>
> > > > </tr>
> > > > <xsl:for-each select="ROW">
> > > > <tr>
> > > > <td><xsl:value-of select="name"/></td>
> > > > <td><xsl:value-of select="owner"/></td>
> > > > <td><xsl:value-of select="species"/></td>
> > > > <td><xsl:value-of select="sex"/></td>
> > > > <td><xsl:value-of select="birth"/></td>
> > > > <td><xsl:value-of select="death"/></td>
> > > > </tr>
> > > > </xsl:for-each>
> > > > </table>
> > > > </xsl:template>
> > > > </xsl:stylesheet>
> > > >
> > > > the problem
> > > > ************
> > > > when i try to access the xml file by cocoon.
> > > > it just prints what is written between the tags
> > of
> > > the
> > > > XML file and nothing more
> > > > which is:
> > > >
> > > > org.gjt.mm.mysql.Driver?
> > > >
> > jdbc:mysql://pawpaw.cs.nott.ac.uk:8080/~mrz/Ramzy1
> > > mrz
> > > > zocka select * from pet
> > > >
> > > > i did the configuration as described in the
> > apache
> > > sql
> > > > instructions.
> > > > would u plz help me to find what is the
> > > problem....
> > > >
> > > > Thanx in Advance
> > > >
> > > >
> > __________________________________________________
> > > > Do You Yahoo!?
> > > > Kick off your party with Yahoo! Invites.
> > > > http://invites.yahoo.com/
> > > >
> > > >
> > >
> >
> ---------------------------------------------------------------------
> > > > To unsubscribe, e-mail:
> > > cocoon-users-unsubscribe@xml.apache.org
> > > > For additional commands, e-mail:
> > > cocoon-users-help@xml.apache.org
> > > >
> > > >
> > >
> > >
> > >
> >
> ---------------------------------------------------------------------
> > > To unsubscribe, e-mail:
> > > cocoon-users-unsubscribe@xml.apache.org
> > > For additional commands, e-mail:
> > > cocoon-users-help@xml.apache.org
> > >
> >
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Kick off your party with Yahoo! Invites.
> > http://invites.yahoo.com/
> >
> >
> ---------------------------------------------------------------------
> > To unsubscribe, e-mail:
> > cocoon-users-unsubscribe@xml.apache.org
> > For additional commands, e-mail:
> > cocoon-users-help@xml.apache.org
> >
>
>
> __________________________________________________
> Do You Yahoo!?
> Kick off your party with Yahoo! Invites.
> http://invites.yahoo.com/
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
> For additional commands, e-mail: cocoon-users-help@xml.apache.org
>
>