[ http://issues.apache.org/jira/browse/IBATIS-194?page=comments#action_12330300 ]
Sven Boden commented on IBATIS-194: ----------------------------------- With the "custom Type Handlers" you can get a ResultSet back from a stored procedure via iBATIS. However automatically mapping that to a ResultMap is not yet in the code, as e.g. requested in IBATIS-154 So this problem is not a problem of not finding a ResultSet, but a problem of not yet supported functionality. > 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