For 2.1, there is a page in the docs (xdocs) dedicated to the
SQLTransformer. You can build the documentation by giving the parameter
'docs' to the build script.
To check the ouput, you can use a label or just don't put any transformers
after the SQLTranformer and serialize XML. The output XML from the
transformer will then appear in the browser.
To be sure if your query is correct and gives a result, try to execute the
query after EXECUTING (debug statement in cocoon.log) directly on the DB.
Sven
> -----Original Message-----
> From: Lajos Moczar [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 09, 2001 6:20 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Simple SQL Example w/ MySQL
>
>
> Sorry, I did forget to mention that I am using 2.1dev on Windows98. I
> have checked cocoon.log, which is where I see that the pool
> is getting
> created without any errors. There is a DEBUG statements which
> prints out
> the SQL query, and a couple for retrieving the returning the
> connection
> from the pool, but no errors whatsoever. Are you aware of any
> documentation for the SQLTransformer beyond the source file itself?
>
> Regards,
>
> Lajos
>
>
>
> Beauprez Sven wrote:
>
> > I am using C2 with MySQL for a while now and don't have any
> problems.
> > There is a lot of debug info in cocoon.log generated by the
> SQLTransformer.
> > In the future, you should also specify which version of C2
> you use (2.0 or
> > 2.1), because the SQLTransformer has changed a lot in the
> 2.1 version.
> >
> > Sven
> >
> >
> >
> >> -----Original Message-----
> >> From: Lajos Moczar [mailto:[EMAIL PROTECTED]]
> >> Sent: Monday, July 09, 2001 7:46 AM
> >> To: [EMAIL PROTECTED]
> >> Subject: Simple SQL Example w/ MySQL
> >>
> >>
> >> Hi all -
> >>
> >> I've finally got Cocoon2 to pool a MySQL connection, but when
> >> I try to
> >> run sql-page.xml I can't get any rows. I have verified that
> >> the pool is
> >> being created, the SQL is correct and there are rows in the
> >> table. But
> >> still no table data being displayed. Has anyone used MySQL
> >> with the sql
> >> tags?
> >>
> >> Is there any way to get SQL error messages printed to either
> >> the log or
> >> the screen?
> >>
> >> My fallback is esql, but I don't see anywhere that Cocoon2
> supports
> >> pools for esql.
> >>
> >>
> >> Thanks in advance.
> >>
> >> Lajos Moczar
> >> galatea.com
> >>
> >>
> >>
> ---------------------------------------------------------------------
> >> 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]>
> >>
> >
> >
> ---------------------------------------------------------------------
> > 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]>
>
>
> ---------------------------------------------------------------------
> 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]>
>
---------------------------------------------------------------------
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]>
