[ http://issues.apache.org/jira/browse/IBATIS-194?page=all ] Clinton Begin closed IBATIS-194: --------------------------------
Fix Version: 2.2.0 Resolution: Fixed IBATIS-173 should fix this issue as well....otherwise, it must be a non-compliant driver issue (which we can always reopen the issue for if necessary). > 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 > Assignee: Clinton Begin > Fix For: 2.2.0 > > 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