Hello comunity,
i have one problem with execute of SQL-statement.
I use Oracle 8.1.7, Tomcat 4.0.1 and Cocoon
I have added nls_charset12.jar to my CLASSPATH and
changed a xsp file:
<?xml version="1.0" encoding="UTF-8"?>
<!-- "ISO-8859-1" -->
.
.
.
<esql:execute-query>
<!--
<esql:query>update products set product = '<xsp-request:get-parameter name="product"/>', description = '<xsp-request:get-parameter name="description"/>', information = '<xsp-request:get-parameter name="information"/>' where product_key = <xsp:expr>productKey</xsp:expr>;</esql:query>
-->
<esql:query><xsp:expr>"update products set product = '" + <xsp-request:get-parameter name="product"/> + "', description = '" + <xsp-request:get-parameter name="description"/> + "', information = '" + <xsp-request:get-parameter name="information"/> + "' where product_key = " + <xsp:expr>productKey</xsp:expr>+ ";"</xsp:expr></esql:query>
<esql:results>
<esql:row-results>
<para>hello</para>
</esql:row-results>
<esql:error-results>
<para><br/>updating: the following error occured: <esql:get-message/></para>
</esql:error-results>
</esql:results>
</esql:execute-query>
.
.
.
I got allways this exception:
ERROR (2003-01-20) 09:35.41:119 [sitemap] (/prod/admin/article/add.html) HttpProcessor[8080][4]/sitemap_xmap: Sitemap
org.apache.cocoon.ProcessingException: Exception in ServerPagesGenerator.generate(): java.lang.RuntimeException: Error executing statement: update products set product = 'uuuuuuuuuuuuuuuuuuu', description = 'zzzzzzzzzzzzzzzzzzzzzzzz', information = 'zzzzzzzzzzzzzzzzzzzzzz' where product_key = 46;: java.sql.SQLException: ORA-00911: invalid character
at org.apache.cocoon.generation.ServerPagesGenerator.generate(ServerPagesGenerator.java:270)
at org.apache.cocoon.components.pipeline.CachingEventPipeline.process(CachingEventPipeline.java:250)
at org.apache.cocoon.components.source.SitemapSource.toSAX(SitemapSource.java:353)
at org.apache.cocoon.sitemap.ContentAggregator.generate(ContentAggregator.java:148)
at org.apache.cocoon.components.pipeline.CachingEventPipeline.process(CachingEventPipeline.java:250)
at org.apache.cocoon.components.pipeline.CachingStreamPipeline.process(CachingStreamPipeline.java:399)
at org.apache.cocoon.www.sitemap_xmap.matchN10388(/appl/tomcat/4.0.1/work/localhost/prod/cocoon-files/org/apache/cocoon/www/sitemap_xmap.java:3312)
at org.apache.cocoon.www.sitemap_xmap.process(/appl/tomcat/4.0.1/work/localhost/prod/cocoon-files/org/apache/cocoon/www/sitemap_xmap.java:2340)
at org.apache.cocoon.www.sitemap_xmap.process(/appl/tomcat/4.0.1/work/localhost/prod/cocoon-files/org/apache/cocoon/www/sitemap_xmap.java:2223)
at org.apache.cocoon.sitemap.Handler.process(Handler.java:224)
at org.apache.cocoon.sitemap.Manager.invoke(Manager.java:179)
at org.apache.cocoon.sitemap.SitemapManager.process(SitemapManager.java:154)
at org.apache.cocoon.Cocoon.process(Cocoon.java:575)
at org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:999)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:201)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:518)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2344)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:462)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:163)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:1011)
at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1106)
at java.lang.Thread.run(Thread.java:484)
Thank you for your help.
Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist nicht gestattet.
This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden.
