No resultSet found when executing SQL Server stored procedure.
--------------------------------------------------------------
Key: IBATIS-194
URL: http://issues.apache.org/jira/browse/IBATIS-194
Project: iBatis for Java
Type: Bug
Components: SQL Maps
Versions: 2.1.0
Environment: SQL Server 2000
Reporter: Tony Ugando
When executing a SQL Server stored procedure that returns a resultSet, using
the <procedure> tag, iBATIS does not find a resultSet. I have tested the
procedure with the following lowlevel JDBC code, and it works fine...
Connection con = c_SQL_MAP_CLIENT.getCurrentConnection();
CallableStatement cs = con.prepareCall("{call sp_epolice_open_events()}");
ResultSet rs = cs.executeQuery();
...
con.close();
The follwing does not work:
XML...
<procedure
id="getAllOpenUdtCadEvents"
resultMap="cadEvent.result">
{call sp_epolice_open_events()}
</procedure>
Java DAO Class...
List list = c_SQL_MAP_CLIENT.queryForList(
"cadEvent.getAllOpenUdtCadEvents", null);
The follwoing error is produced...
The error occurred in com/mdpd/epolice/resources/cadEvent-sqlMap.xml.
--- The error occurred while applying a parameter map.
--- Check the cadEvent.getAllOpenUdtCadEvents-InlineParameterMap.
--- Check the results (failed to retrieve results).
--- Cause: java.lang.NullPointerException
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
