I am making a query passing it from a JSP file, my code is very simple but I got an error:
java.lang.RuntimeException:
Error executed prepared statement:
?
at _C_._tomcat._webapps._cocoon._m3._query_m3.populateDocument(_query_m3.java:233)
at org.apache.cocoon.processor.xsp.XSPPage.getDocument(XSPPage.java:97)
at org.apache.cocoon.processor.xsp.XSPProcessor.process(XSPProcessor.java:527)
at org.apache.cocoon.Engine.handle(Engine.java:384)
at org.apache.cocoon.Cocoon.service(Cocoon.java:183)
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(ContextManager.java:797)
at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743)
at org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.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)
My code is the next:
<esql:query>
<esql:parameter type="string">
<request:get-parameter name="pQuery"/>
</esql:parameter>
</esql:query>
and I send the variable pQuery using the URL, something like:
http://localhost/cocoon/m3/query_m3.xml?pQuery=select * from inmuebles
I don't know what the error is, I think it is because the spaces in the query, I tried also putting my query directly, (no like a parameter) and it works fine.
Could you help me ? how can I fix this error !!
I would appreciate all your help !
Thanks a lot
--
Gustavo Mejía Mora
INFOTEC
Tel: 5624 28 00
Ext: 253
