AW: AW: [Wyonacms-users] JDBC - Pool connection

Hello group,

I don't know exactly why but with a access DB it is working fine!

So I can proceed to modify my sitemap to create the fo objects from my query!

King regards!

-----Ursprüngliche Nachricht-----
Von: Scherler, Thorsten 
Gesendet: Mittwoch, 30. Oktober 2002 16:59
An: Niedermowe Rene
Cc: Wyonacms-Users (E-Mail); Wyona-Dev (E-Mail)
Betreff: [Wyonacms-dev] AW: [Wyonacms-users] JDBC - Pool connection


Hallo René, hello group,

I think so as well, BUT:

I am using XSP to do the query:
<!-- Example #1 -->
<xsp:page language="java" xmlns:xsp="http://apache.org/xsp" xmlns:esql="http://apache.org/cocoon/SQL/v2">
	<categories>
		<esql:connection>
			<esql:pool>ldodds</esql:pool>
			<esql:execute-query>
				<esql:query>
         select cat_id, name
         from category
         order by cat_id
         </esql:query>
				<esql:results>
					<esql:row-results>
						<category>
							<esql:get-columns/>
						</category>
					</esql:row-results>
				</esql:results>
				<esql:no-results/>
				<esql:error-results/>
			</esql:execute-query>
		</esql:connection>
	</categories>
</xsp:page>

Before I could use the xsp I had to modify:

1.) PATHTO\jakarta-tomcat-4.0.4\webapps\wyona-cms\WEB-INF\web.xml and at the driver (sun.jdbc.odbc.JdbcOdbcDriver):
		<init-param>
			<param-name>load-class</param-name>
			<param-value>
				<!-- For IBM WebSphere:
        com.ibm.servlet.classloader.Handler -->
				<!-- For Database Driver: -->
        sun.jdbc.odbc.JdbcOdbcDriver

        <!-- For parent ComponentManager sample:
        org.apache.cocoon.samples.parentcm.Configurator
        -->
			</param-value>
		</init-param>

2.)  PATHTO\jakarta-tomcat-4.0.4\webapps\wyona-cms\WEB-INF\cocoon.xconf to add the pool (ldodds):
		<jdbc name="ldodds">
			<pool-controller min="1" max="10"/>
			<dburl>jdbc:odbc:IBM</dburl>
			<user/>
			<password/>
		</jdbc>

But where can I set a close()?

-----Ursprüngliche Nachricht-----
Von: Niedermowe Rene [mailto:[email protected]]
Gesendet: Dienstag, 29. Oktober 2002 17:02
An: Scherler, Thorsten
Betreff: AW: [Wyonacms-users] JDBC - Pool connection


Hi Thorsten

Du musst das Statement wahrscheinlich schliessen und ein neues aufbauen.
Die Connection wird bestimmt als belegt gesetzt bis du ein close() befehl
gibst

> -----Ursprüngliche Nachricht-----
> Von: Scherler, Thorsten [mailto:[email protected]]
> Gesendet: Dienstag, 29. Oktober 2002 16:33
> An: Wyonacms-Users (E-Mail); Wyona-Dev (E-Mail)
> Betreff: [Wyonacms-users] 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.PipelineNod
> e 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
> > 
> > 
> 
> _______________________________________________
> WyonaCMS-users mailing list
> [email protected]
> http://mail.wyona.org/cgi-bin/mailman/listinfo/wyonacms-users
> 

_______________________________________________
WyonaCMS-dev mailing list
[email protected]
http://mail.wyona.org/cgi-bin/mailman/listinfo/wyonacms-dev