[IBATIS-194] No resultSet found when executing SQL Server stored procedure.

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.1.0
• Fix Version/s: 2.1.6
• Component/s: Core
• Environment: SQL Server 2000
• Assignee: Clinton Begin
• Reporter: Tony Ugando
• Created: 24/Sep/05 01:40
• Updated: 04/Oct/05 02:33
• Resolved: 03/Oct/05 10:44

Description

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