[ http://issues.apache.org/jira/browse/IBATIS-194?page=comments#action_12331192 ]
Clinton Begin commented on IBATIS-194: -------------------------------------- So, the driver doesn't support execute(), then getResultSet(). That is a shame indeed. If you're adventurous, you could try either the SQL Server 2005 driver, or jTDS. I'd love to change it for you, but unfortunately we're in a situation where some drivers work one way, and others work another way.....in this case, SQL Server is the only one that doesn't support this approach...keep me posted if you can fix this another way. Otherwise we may be able to add a flag... Cheers, Clinton > 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
