[ http://issues.apache.org/jira/browse/IBATIS-194?page=all ]
Clinton Begin reassigned IBATIS-194:
------------------------------------
Assign To: Clinton Begin
> 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
>
> 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
