[jira] Created: (XALANJ-2501) "No ResutSet was produced" exception for inserts / updates

["Adam W (JIRA)" <xa...@xml.apache.org>]

"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-unsubscribe@xml.apache.org
For additional commands, e-mail: xalan-dev-help@xml.apache.org