cocoon-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Carsten Ziegeler" <cziege...@sundn.de>
Subject AW: [C2]:Go For Beta: SQLTransformer warning
Date Tue, 05 Jun 2001 07:52:39 GMT
Hi,

I think I fixed this problem. The connection should be closed now only once.

Could someone verify this please with the latest cvs?


Carsten

Open Source Group                        sunShine - b:Integrated
================================================================
Carsten Ziegeler, S&N AG, Klingenderstrasse 5, D-33100 Paderborn
www.sundn.de                          mailto: cziegeler@sundn.de
================================================================

> Jan Uyttenhove wrote:
>
> Sylvain,
>
> I noticed this before, it is indeed be caused by the connection
> being closed
> twice
> Inside the executeQuery method, the methods Query.execute() and
> Query.next()
> both close the db connection.
> I think I removed the conn.close() call from the finally block of the
> Query.close() method to solve the problem.
>
> Jan
>
> ----- Original Message -----
> From: "Sylvain Wallez" <sylvain.wallez@anyware-tech.com>
> To: <cocoon-dev@xml.apache.org>
> Sent: Friday, June 01, 2001 6:52 PM
> Subject: Re: [C2]:Go For Beta
>
>
> >
> >
> > Carsten Ziegeler a écrit :
> > >
> > > Hi C2ers!
> > >
> > > I think we are all +1 on the beta question. The only real
> > > remaining problem is that someone has to actually do it.
> > >
> > > So here is the roadmap for beta 1 that I will follow unless
> > > someone kills me - or threatens to :-):
> > >
> > > - Code-freeze and testing of the examples to be completed
> > >   by Sunday (MEST).
> > >   Only bug fixing should be checked in from now.
> > >   Can someone test the database examples?
> >
> > They're functionnal, but there are some "message output is null" in the
> > tomcat's console, and the log file contains the following exception on
> > the Simple SQL sample.
> >
> > DEBUG   84521   [cocoon  ] (Thread-10): Retrieving a
> > org.apache.avalon.excalibur.datasource.JdbcConnection from the pool
> > DEBUG   84521   [cocoon  ] (Thread-10): JdbcConnection was closed,
> > creating one to take its place
> > DEBUG   84521   [cocoon  ] (Thread-10): JdbcConnection object created
> > DEBUG   84521   [cocoon  ] (Thread-10): Returning a
> > org.apache.avalon.excalibur.datasource.JdbcConnection to the pool
> > WARN    84521   [cocoon  ] (Thread-10): Pool interrupted while waiting
> > for lock.
> > java.lang.IndexOutOfBoundsException: Index: -1, Size: 0
> > at java.util.ArrayList.RangeCheck(ArrayList.java:491)
> > at java.util.ArrayList.remove(ArrayList.java:375)
> > at
> > org.apache.avalon.excalibur.pool.DefaultPool.put(DefaultPool.java:174)
> > at
> >
> org.apache.avalon.excalibur.datasource.JdbcConnection.close(JdbcCo
> nnection.j
> ava:134)
> > at
> >
> org.apache.cocoon.transformation.SQLTransformer$Query.close(SQLTra
> nsformer.j
> ava:614)
> > at
> >
> org.apache.cocoon.transformation.SQLTransformer$Query.next(SQLTran
> sformer.ja
> va:597)
> > at
> >
> org.apache.cocoon.transformation.SQLTransformer.executeQuery(SQLTr
> ansformer.
> java:194)
> > at
> >
> org.apache.cocoon.transformation.SQLTransformer.executeQuery(SQLTr
> ansformer.
> java:198)
> > at
> >
> org.apache.cocoon.transformation.SQLTransformer.endExecuteQueryEle
> ment(SQLTr
> ansformer.java:294)
> > at
> >
> org.apache.cocoon.transformation.SQLTransformer.endElement(SQLTran
> sformer.ja
> va:396)
> > at
> >
> org.apache.cocoon.components.sax.XMLTeePipe.endElement(XMLTeePipe.java:84)
> > at org.apache.xerces.parsers.SAXParser.endElement(SAXParser.java:1403)
> > at
> >
> org.apache.xerces.validators.common.XMLValidator.callEndElement(XM
> LValidator
> .java:1436)
> > at
> >
> org.apache.xerces.framework.XMLDocumentScanner$ContentDispatcher.d
> ispatch(XM
> LDocumentScanner.java:1260)
> > at
> >
> org.apache.xerces.framework.XMLDocumentScanner.parseSome(XMLDocume
> ntScanner.
> java:381)
> > at org.apache.xerces.framework.XMLParser.parse(XMLParser.java:1035)
> > at
> > org.apache.cocoon.components.parser.JaxpParser.parse(JaxpParser.java:72)
> > at
> >
> org.apache.cocoon.generation.FileGenerator.generate(FileGenerator.
> java:115)
> > at
> >
> org.apache.cocoon.components.pipeline.CachingEventPipeline.process
> (CachingEv
> entPipeline.java:220)
> > at
> >
> org.apache.cocoon.components.pipeline.CachingStreamPipeline.proces
> s(CachingS
> treamPipeline.java:344)
> > at org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:3705)
> > at org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:1337)
> > at org.apache.cocoon.sitemap.Handler.process(Handler.java:175)
> > at org.apache.cocoon.sitemap.Manager.invoke(Manager.java:94)
> > at org.apache.cocoon.Cocoon.process(Cocoon.java:293)
> > at
> > org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:471)
> > at javax.servlet.http.HttpServlet.service(HttpServlet.java:865)
> > at
> > org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:404)
> > at org.apache.tomcat.core.Handler.service(Handler.java:286)
> > at
> > org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
> > at
> >
> org.apache.tomcat.core.ContextManager.internalService(ContextManag
> er.java:79
> 7)
> > at
> > org.apache.tomcat.core.ContextManager.service(ContextManager.java:743)
> > at
> >
> org.apache.tomcat.service.http.HttpConnectionHandler.processConnec
> tion(HttpC
> onnectionHandler.java:210)
> > at
> >
> org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
> > at
> >
> org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:498)
> > at java.lang.Thread.run(Thread.java:484)
> >
> > Couldn't this be caused by the connection being closed twice ? A quick
> > look to SQLTransformer did not reveal it, but maybe it could be worth
> > investigating this way.
> >
> > > - Total code-freeze starting monday to prepare the distribution.
> > > - Release of the beta on Wednesday
> > >
> > > I will prepare the distribution and put it on Daedalus on
> > > Wednesday and Giacomo will write the announcement.
> > >
> > Great, great :)
> >
> > > Carsten
> > >
> >
> > --
> > Sylvain Wallez
> > Anyware Technologies - http://www.anyware-tech.com
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: cocoon-dev-unsubscribe@xml.apache.org
> > For additional commands, email: cocoon-dev-help@xml.apache.org
> >
> >
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: cocoon-dev-unsubscribe@xml.apache.org
> For additional commands, email: cocoon-dev-help@xml.apache.org
>


---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-dev-unsubscribe@xml.apache.org
For additional commands, email: cocoon-dev-help@xml.apache.org


Mime
View raw message