You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ibatis.apache.org by "Clinton Begin (JIRA)" <ib...@incubator.apache.org> on 2005/10/03 03:45:48 UTC

[jira] Closed: (IBATIS-194) No resultSet found when executing SQL Server stored procedure.

     [ 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