Return-Path: Delivered-To: apmail-xml-cocoon-users-archive@xml.apache.org Received: (qmail 80711 invoked by uid 500); 3 Jul 2001 19:17:58 -0000 Mailing-List: contact cocoon-users-help@xml.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: list-post: Reply-To: cocoon-users@xml.apache.org Delivered-To: mailing list cocoon-users@xml.apache.org Received: (qmail 80570 invoked from network); 3 Jul 2001 19:17:49 -0000 Message-ID: <3B4219F5.B8C0EC11@infotec.com.mx> Date: Tue, 03 Jul 2001 14:16:05 -0500 From: Gustavo Mejia X-Mailer: Mozilla 4.72 [en] (Win98; I) X-Accept-Language: en MIME-Version: 1.0 To: cocoon-users@xml.apache.org Subject: Query problems ! X-Priority: 1 (Highest) Content-Type: multipart/alternative; boundary="------------0C115C0001B0ADD1E9E9C456" X-Spam-Rating: h31.sny.collab.net 1.6.2 0/1000/N --------------0C115C0001B0ADD1E9E9C456 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit 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:

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 --------------0C115C0001B0ADD1E9E9C456 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit 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
--------------0C115C0001B0ADD1E9E9C456--