Incorrect java.sql.SQLException with INSERT and UPDATE

[Marc Gibert <ma...@cometatech.com>]

Hello!

        We have been trying to do insert and update operations with the
SQL taglib
and doesn't work (with select and delete all works fine).
        The query is correct, since we run it from the psql command line
(we use
PostgreSQL) and from a Java program with the JDBC driver, and it
executes with
no problem.
        The database connection is correct too, since we use the same
connection
(from the Turbine pool) to make selects and deletes, and all runs fine.

        Can anybody help us?

        Thank you very much for your responses.

        The error we get is:

java.sql.SQLException: insert into person ( /** QUERY **/
)java.sql.SQLException: ERROR:  parser: parse error at or near "into"

        at
org.apache.cocoon.processor.xsp.library.sql.XSPSQLLibrary.executeQuery(XSPSQLLibrary.java,
Compiled Code)
        at _usr._local._aibits._xml._test1.populateDocument(_test1.java,
Compiled
Code)
        at
org.apache.cocoon.processor.xsp.XSPPage.getDocument(XSPPage.java,
Compiled
Code)
        at
org.apache.cocoon.processor.xsp.XSPProcessor.process(XSPProcessor.java,
Compiled Code)
        at org.apache.cocoon.Engine.handle(Engine.java, Compiled Code)
        at org.apache.cocoon.Cocoon.service(Cocoon.java, Compiled Code)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java,
Compiled Code)
        at
org.apache.jserv.JServConnection.processRequest(JServConnection.java,
Compiled Code)
        at org.apache.jserv.JServConnection.run(JServConnection.java,
Compiled Code)
        at java.lang.Thread.run(Thread.java, Compiled Code)


        
-- 
Alberto Otero García              e-mail: alberto@cometatech.com
Cometa Technologies, S.L.         URL: http://www.cometatech.com

-- 
Sincerely,
Marc Gibert Ginestà               e-mail: marcg@cometatech.com
Cometa Technologies, S.L.         URL: http://www.cometatech.com
Telf.: 93 231 84 90               Fax: 93 245 93 43

Re: Incorrect java.sql.SQLException with INSERT and UPDATE

[Roman Zamorski <ra...@tenbit.pl>]

Hello Marc,

Wednesday, December 27, 2000, 4:36:37 PM, you wrote:

MG> Hello!

MG>         We have been trying to do insert and update operations with the
MG> SQL taglib
MG> and doesn't work (with select and delete all works fine).

MG>         at
MG> org.apache.cocoon.processor.xsp.library.sql.XSPSQLLibrary.executeQuery(XSPSQLLibrary.java,

you seem to be using the old version of esql which was a little buggy
for C1. go and fetch new one from CVS.

r.