Hello,
first thanks to Jeff Turner and John Morrison both forwarding me the mail from
Carste from the mailing list.
Checked out the cocoon 2.1-dev version today from CVS.
The patch works for me when using avalon-excalibur-4.0.jar and
avalon-framework-4.0.jar instead of avalon-excalibur-20011126.jar and
avalon-framework-20011126.jar.
With avalon-excalibur-20011126.jar and avalon-framework-20011126.jar
I get a java.lang.IllegalMonitorStateException when using the
SQLTransformer.
The log from components.log is attached to the mail.
Peter Seiderer
I am not subscribed to the mailing list. Please reply via
CC to [EMAIL PROTECTED]
-----Original Message-----
> Date: Wed, 28 Nov 2001 13:05:30 +0100
> From: "Carsten Ziegeler" <[EMAIL PROTECTED]>
> Subject: RE: PATCH: add advanced error handling in SQLTransformer plus
> +escape-string element
> To: <[EMAIL PROTECTED]>
> X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0)
>
> Hi Peter,
>
> I applied your patch to the HEAD of the CVS (2.1-dev). Could
> you please cross-check.
>
> Thanks for your patch,
>
> Carsten
> -----Original Message-----
> From: Peter Seiderer [mailto:[EMAIL PROTECTED]]
> Sent: Monday, November 26, 2001 9:21 PM
> To: [EMAIL PROTECTED]
> Subject: PATCH: add advanced error handling in SQLTransformer plus
> escape-string element
>
>
> Hello,
> the patch attached above brings the following two changes to the
> SQLTransformer:
>
> 1. SQLExceptions coming from query.execute() are catched and the following
> output is added to the resulting xml documenters set
> <sql:rowset>
> <sql:error>The error messge from the SQLException.<sql:error>
> </sql:rowset>
>
> 2. The element <sql:escape-string> is added. The purpose of this is, that
> you can write the following statement:
> <sql:execute-query>
> <sql:query isupdate="true">
> update test_table set test1 = '<sql:escape-string>A string
> with tick ' and backslash \ in it.</sql:escape-string>'
> </sql:query>
> </sql:execute-query>
>
> The tick ' will be escaped with a double tick '' and the backslash will
> be escaped with a double backlslash \\ befor adding to the query string.
>
> With this it is although possible to create sql queries from stylesheets
> using form paramters like in the following example:
>
> <sql:execute-query>
> <sql:query isupdate="true">
> update test_table set
> test = '<sql:escape-string><xsl:value-of
> select="$input_test1"/></sql:escape-string>'
> </sql:query>
> </sql:execute-query>
>
> Cheers,
> Peter Seiderer
>
> I am not subscribed to the mailing list. Please reply via
> CC to [EMAIL PROTECTED]
>
>
FATAL_E (2001-11-29) 21:25.13:684 [root.xsl] (/xml3/test.xml)
Thread-15/TraxErrorHandler: Error in TraxTransformer:
javax.xml.transform.TransformerException: java.lang.IllegalMonitorStateException
javax.xml.transform.TransformerException: java.lang.IllegalMonitorStateException
at
org.apache.xalan.transformer.TransformerImpl.transformNode(TransformerImpl.java:1230)
at org.apache.xalan.transformer.TransformerImpl.run(TransformerImpl.java:3139)
at
org.apache.xalan.transformer.TransformerHandlerImpl.endDocument(TransformerHandlerImpl.java:433)
at org.apache.cocoon.xml.AbstractXMLPipe.endDocument(AbstractXMLPipe.java:48)
at org.apache.xerces.parsers.SAXParser.endDocument(SAXParser.java:1230)
at
org.apache.xerces.validators.common.XMLValidator.callEndDocument(XMLValidator.java:1146)
at
org.apache.xerces.framework.XMLDocumentScanner$EndOfInputDispatcher.dispatch(XMLDocumentScanner.java:1499)
at
org.apache.xerces.framework.XMLDocumentScanner.parseSome(XMLDocumentScanner.java:381)
at org.apache.xerces.framework.XMLParser.parse(XMLParser.java:1098)
at org.apache.cocoon.components.parser.JaxpParser.parse(JaxpParser.java:116)
at org.apache.cocoon.components.source.URLSource.toSAX(URLSource.java:331)
at org.apache.cocoon.generation.FileGenerator.generate(FileGenerator.java:109)
at
org.apache.cocoon.components.pipeline.AbstractEventPipeline.process(AbstractEventPipeline.java:106)
at
org.apache.cocoon.components.pipeline.AbstractStreamPipeline.process(AbstractStreamPipeline.java:140)
at
org.apache.cocoon.www.xml3.sitemap_xmap.wildcardMatchN400127(sitemap_xmap.java:1982)
at org.apache.cocoon.www.xml3.sitemap_xmap.process(sitemap_xmap.java:622)
at org.apache.cocoon.www.xml3.sitemap_xmap.process(sitemap_xmap.java:545)
at org.apache.cocoon.sitemap.Handler.process(Handler.java:163)
at org.apache.cocoon.sitemap.Manager.invoke(Manager.java:115)
at
org.apache.cocoon.www.sitemap_xmap.wildcardMatchN4001BA(sitemap_xmap.java:1705)
at org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:1511)
at org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:1454)
at org.apache.cocoon.sitemap.Handler.process(Handler.java:163)
at org.apache.cocoon.sitemap.Manager.invoke(Manager.java:115)
at org.apache.cocoon.sitemap.SitemapManager.process(SitemapManager.java:139)
at org.apache.cocoon.Cocoon.process(Cocoon.java:469)
at org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:792)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:865)
at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:405)
at org.apache.tomcat.core.Handler.service(Handler.java:287)
at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
at
org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:812)
at org.apache.tomcat.core.ContextManager.service(ContextManager.java:758)
at
org.apache.tomcat.service.connector.Ajp12ConnectionHandler.processConnection(Ajp12ConnectionHandler.java:166)
at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:501)
at java.lang.Thread.run(Thread.java:484)
---------
java.lang.IllegalMonitorStateException
at java.lang.Object.notifyAll(Native Method)
at
org.apache.avalon.excalibur.datasource.JdbcConnectionPool.put(JdbcConnectionPool.java:184)
at
org.apache.avalon.excalibur.datasource.AbstractJdbcConnection.close(AbstractJdbcConnection.java:145)
at
org.apache.cocoon.transformation.SQLTransformer$Query.close(SQLTransformer.java:1083)
at
org.apache.cocoon.transformation.SQLTransformer.executeQuery(SQLTransformer.java:314)
at
org.apache.cocoon.transformation.SQLTransformer.endExecuteQueryElement(SQLTransformer.java:417)
at
org.apache.cocoon.transformation.SQLTransformer.endElement(SQLTransformer.java:689)
at org.apache.cocoon.xml.AbstractXMLPipe.endElement(AbstractXMLPipe.java:104)
at
com.ecademix.cocoon.transformation.EcademixTransformer.endElement(EcademixTransformer.java)
at
com.ecademix.cocoon.transformation.CryptTransformer.endElement(CryptTransformer.java)
at
org.apache.xalan.transformer.ResultTreeHandler.endElement(ResultTreeHandler.java:307)
at
org.apache.xalan.templates.ElemLiteralResult.execute(ElemLiteralResult.java:716)
at
org.apache.xalan.transformer.TransformerImpl.executeChildTemplates(TransformerImpl.java:2186)
at
org.apache.xalan.templates.ElemLiteralResult.execute(ElemLiteralResult.java:710)
at
org.apache.xalan.transformer.TransformerImpl.executeChildTemplates(TransformerImpl.java:2186)
at org.apache.xalan.templates.ElemTemplate.execute(ElemTemplate.java:430)
at
org.apache.xalan.templates.ElemCallTemplate.execute(ElemCallTemplate.java:279)
at
org.apache.xalan.transformer.TransformerImpl.executeChildTemplates(TransformerImpl.java:2186)
at
org.apache.xalan.templates.ElemLiteralResult.execute(ElemLiteralResult.java:710)
at
org.apache.xalan.templates.ElemApplyTemplates.transformSelectedNodes(ElemApplyTemplates.java:422)
at
org.apache.xalan.templates.ElemApplyTemplates.execute(ElemApplyTemplates.java:226)
at
org.apache.xalan.transformer.TransformerImpl.executeChildTemplates(TransformerImpl.java:2186)
at
org.apache.xalan.transformer.TransformerImpl.applyTemplateToNode(TransformerImpl.java:2012)
at
org.apache.xalan.transformer.TransformerImpl.transformNode(TransformerImpl.java:1175)
at org.apache.xalan.transformer.TransformerImpl.run(TransformerImpl.java:3139)
at
org.apache.xalan.transformer.TransformerHandlerImpl.endDocument(TransformerHandlerImpl.java:433)
at org.apache.cocoon.xml.AbstractXMLPipe.endDocument(AbstractXMLPipe.java:48)
at org.apache.xerces.parsers.SAXParser.endDocument(SAXParser.java:1230)
at
org.apache.xerces.validators.common.XMLValidator.callEndDocument(XMLValidator.java:1146)
at
org.apache.xerces.framework.XMLDocumentScanner$EndOfInputDispatcher.dispatch(XMLDocumentScanner.java:1499)
at
org.apache.xerces.framework.XMLDocumentScanner.parseSome(XMLDocumentScanner.java:381)
at org.apache.xerces.framework.XMLParser.parse(XMLParser.java:1098)
at org.apache.cocoon.components.parser.JaxpParser.parse(JaxpParser.java:116)
at org.apache.cocoon.components.source.URLSource.toSAX(URLSource.java:331)
at org.apache.cocoon.generation.FileGenerator.generate(FileGenerator.java:109)
at
org.apache.cocoon.components.pipeline.AbstractEventPipeline.process(AbstractEventPipeline.java:106)
at
org.apache.cocoon.components.pipeline.AbstractStreamPipeline.process(AbstractStreamPipeline.java:140)
at
org.apache.cocoon.www.xml3.sitemap_xmap.wildcardMatchN400127(sitemap_xmap.java:1982)
at org.apache.cocoon.www.xml3.sitemap_xmap.process(sitemap_xmap.java:622)
at org.apache.cocoon.www.xml3.sitemap_xmap.process(sitemap_xmap.java:545)
at org.apache.cocoon.sitemap.Handler.process(Handler.java:163)
at org.apache.cocoon.sitemap.Manager.invoke(Manager.java:115)
at
org.apache.cocoon.www.sitemap_xmap.wildcardMatchN4001BA(sitemap_xmap.java:1705)
at org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:1511)
at org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:1454)
at org.apache.cocoon.sitemap.Handler.process(Handler.java:163)
at org.apache.cocoon.sitemap.Manager.invoke(Manager.java:115)
at org.apache.cocoon.sitemap.SitemapManager.process(SitemapManager.java:139)
at org.apache.cocoon.Cocoon.process(Cocoon.java:469)
at org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:792)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:865)
at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:405)
at org.apache.tomcat.core.Handler.service(Handler.java:287)
at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
at
org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:812)
at org.apache.tomcat.core.ContextManager.service(ContextManager.java:758)
at
org.apache.tomcat.service.connector.Ajp12ConnectionHandler.processConnection(Ajp12ConnectionHandler.java:166)
at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:501)
at java.lang.Thread.run(Thread.java:484)
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, email: [EMAIL PROTECTED]
