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]>
