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
public CachedResultSet( BaseQuery query, IResultClass meta,
			ResultSet odaResultSet, IEventHandler eventHandler, DataEngineSession session )
			throws DataException
	{
		this.handler = eventHandler;
		this.resultSetPopulator = new ResultSetPopulator( query,
				meta,
				this,
				eventHandler, session );
		resultSetPopulator.populateResultSet( new OdiResultSetWrapper( odaResultSet) );
	}
	/**
	 * Constructs and intializes OdiResultSet based on data in an IJointDataSetPopulator
	 */
	public CachedResultSet( BaseQuery query, IResultClass meta,
			IDataSetPopulator odaResultSet, IEventHandler eventHandler, DataEngineSession session )
			throws DataException
	{
		this.handler = eventHandler;
		this.resultSetPopulator = new ResultSetPopulator( query,
				meta,
				this,
				eventHandler, session );
		resultSetPopulator.populateResultSet( new OdiResultSetWrapper( odaResultSet) );
	}
	
	/**
	 * @param query
	 * @param meta
	 * @param odaCacheResultSet