cocoon-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jon Lancelle <lance...@pacbell.net>
Subject SQLTransformer.executeQuery - SQL Update Statements
Date Fri, 15 Dec 2000 02:01:39 GMT
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


Mime
View raw message