You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@cocoon.apache.org by Jon Lancelle <la...@pacbell.net> on 2000/12/15 03:01:39 UTC

SQLTransformer.executeQuery - SQL Update Statements

Can update statements be executed by SQLTransformer.executeQuery?

For instance:

...
<query>
INSERT INTO department_table VALUES (1,'Programmers')
</query>
...

returns an error message stating:

java.sql.SQLException: Cannot executeQuery() an update statement
                  at
org.apache.cocoon.transformation.SQLTransformer.executeQuery(SQLTransformer.java:153)

                  at
org.apache.cocoon.transformation.SQLTransformer.endExecuteQueryElement(SQLTransformer.java:257)

                  at
org.apache.cocoon.transformation.SQLTransformer.endElement(SQLTransformer.java:359)

                  at
org.apache.xerces.parsers.SAXParser.endElement(SAXParser.java:1398)
                  at
org.apache.xerces.validators.common.XMLValidator.callEndElement. . .

Am I screwing up with file permissions again, or are there plans to
allow this?

Thanks.
Jon Lancelle

Re: SQLTransformer.executeQuery - SQL Update Statements

Posted by Donald Ball <ba...@webslingerZ.com>.

On Fri, 15 Dec 2000, Jon Lancelle wrote:

> Can update statements be executed by SQLTransformer.executeQuery?
>
> For instance:
>
> ...
> <query>
> INSERT INTO department_table VALUES (1,'Programmers')
> </query>

try using the esql logicsheet.

- doanld