cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Gustavo Mejia <gme...@infotec.com.mx>
Subject Query problems !
Date Tue, 03 Jul 2001 19:16:05 GMT
Hi !!

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


Mime
View raw message