Re: [Wyonacms-users] JDBC - Pool connection

Scherler, Thorsten wrote:
> Hello group,
> 
> I have a problem and don't know how to solve it.
> 
> I have followed a tutorial of IBM. https://www6.software.ibm.com/developerworks/education/x-dbc2/.

What does the tutorial say (it's protected;-)?

> 
> I have everything working! But I can only execute the query once with success! If I retry the query that perfectly worked before I get this error message:
> 
> The org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode notifies that org.apache.cocoon.ProcessingException says:
> 
> Exception in ServerPagesGenerator.generate() 
> 
> More precisely:
> 
> org.apache.cocoon.ProcessingException: Exception in ServerPagesGenerator.generate(): java.lang.RuntimeException: Error executing statement: select cat_id, name from category order by cat_id : java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]Die Verbindung ist mit Ergebnissen von einem anderen hstmt belegt. 
> 
> I am using Microsoft® SQL Server(tm) 2000 and sun.jdbc.odbc.JdbcOdbcDriver.
> Tomcat 4.0.4.
> Snapshot of wyona.
> 
> Please can anybody give me a hint?

It looks like there is a problem with MSQL. Have you tried HSQL 
Database, which is shipped with Cocoon (Wyona)? We have written some 
docu on that at:

http://127.0.0.1:8080/wyona-cms/docs/xdocs/int-hsqldb.html


HTH

Michael



> 
> 
>>Mit freundlichem Gruss,
>>
>>Thorsten Scherler
>>Marketing / Telefonmarketing
>>
>>Weidmüller GmbH & Co.
>>P.O. Box 2807
>>33058 Paderborn
>>Tel.:+ 49 - 5252-960-350
>>Fax:+ 49 - 5252-960-116
>>eMail: [email protected]
>>http://www.weidmueller.de
>>
>>
> 
> 
> _______________________________________________
> WyonaCMS-users mailing list
> [email protected]
> http://mail.wyona.org/cgi-bin/mailman/listinfo/wyonacms-users