ibatis-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Tony Ugando (JIRA)" <ibatis-...@incubator.apache.org>
Subject [jira] Created: (IBATIS-194) No resultSet found when executing SQL Server stored procedure.
Date Fri, 23 Sep 2005 16:41:30 GMT
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();

The follwing does not work:


		{call sp_epolice_open_events()}

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:
For more information on JIRA, see:

View raw message