Bug 166167 ODA IResultSet.close never been called in DtE
In DtE, we will close IConnection and IQuery from ODA, however the IResultSet.close() has never be called so that it is possible that even the ODA connection is closed the IResultSet is still open(If it is not closed when the IQuery or IConnection is closed). This is incorrect and needs a fix.
data/org.eclipse.birt.data/src/org/eclipse/birt/data/engine/executor/transform/CachedResultSet.java
/*
	 * @see org.eclipse.birt.data.engine.odi.IResultIterator#getCurrentResult()
	 */
	public IResultObject getCurrentResult( ) throws DataException
	{
		assert this.resultSetPopulator != null
				&& this.resultSetPopulator.getCache( ) != null;
		return this.resultSetPopulator.getCache( ).getCurrentResult( );
	}
	/*
	 * Advances row cursor, return false if no more rows.
	 * 
	 * @see org.eclipse.birt.data.engine.odi.IResultIterator#next()
	 */
	public boolean next( ) throws DataException
	{
		
		assert this.resultSetPopulator != null
				&& this.resultSetPopulator.getCache( ) != null;
		boolean hasNext = this.resultSetPopulator.getCache( ).next( );
		this.resultSetPopulator.getGroupProcessorManager( )
				.getGroupCalculationUtil( )
				.getGroupInformationUtil( )
				.next( hasNext );
		return hasNext;
	}
	
	/*
	 * @see org.eclipse.birt.data.engine.odi.IResultIterator#getEndingGroupLevel()
	 */