[IBATIS-269] SqlExecutor calls getMoreResults without checking supportsMultipleResultSets

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.1.6
• Fix Version/s: 2.2.0
• Component/s: Core
• Environment: Windows 2000 NL, IBM RAD 6.0.1
• Assignee: Clinton Begin
• Reporter: M.H. Avegaart
• Created: 23/Feb/06 22:12
• Updated: 14/Aug/06 04:44
• Resolved: 14/Aug/06 04:44

Description

Hi,

I'm using the JdbcOdbcDriver to connect to a really old ODBC driver (Solid v2.2). This ODBC driver doesn't support multiple resultsets, so calling getMoreResults() in com.ibatis.sqlmap.engine.execution.SqlExecutor will throw a SQLException.

Could you check if the connection supports multiple resultsets before calling getMoreResults ?

Example:

private boolean getMoreResults(final Statement stmt) throws SQLException {
if (!stmt.getConnection().getMetaData().supportsMultipleResultSets())

{ return false; }

return stmt.getMoreResults();
}

Thanks, Condor