JDBC - Pool connection

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/.

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?

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