"No ResutSet was produced" exception for inserts / updates
----------------------------------------------------------
Key: XALANJ-2501
URL: https://issues.apache.org/jira/browse/XALANJ-2501
Project: XalanJ2
Issue Type: Bug
Security Level: No security risk; visible to anyone (Ordinary problems in
Xalan projects. Anybody can view the issue.)
Components: Xalan-extensions-(SQL)
Affects Versions: 2.7.1
Environment: Windows XP SP3, Java 1.6, SQLServer 2005 Express
Reporter: Adam W
Priority: Minor
When executing an INSERT or UPDATE against a database, an Exception is thrown
of this form:
java.sql.SQLException: No ResultSet was produced
at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(JdbcOdbcStatement.java:259)
at
org.apache.xalan.lib.sql.SQLDocument.executeSQLStatement(SQLDocument.java:408)
at org.apache.xalan.lib.sql.SQLDocument.execute(SQLDocument.java:370)
at org.apache.xalan.lib.sql.XConnection.query(XConnection.java:692)
This appears to occur (for my database) even if adding an arbitrary SELECT to
the same line ("; select count(something) as X from X").
I understand that the Xalan-SQL extension probably wasn't designed with INSERTs
or UPDATEs in mind, but is there some sort of parameter or option that could be
added (maybe an alternative to query()) that doesn't expect results or
gracefully handles the lack thereof?
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
---------------------------------------------------------------------
To unsubscribe, e-mail: xalan-dev-unsubscr...@xml.apache.org
For additional commands, e-mail: xalan-dev-h...@xml.apache.org
