Closing the Connection 

The final part of the workflow involves releasing resources. You need to:

·        close objects, such as IRecord, IRecordset, and java.sql.resultset.

·        close the connection using IConnection.close.

Closing the connection must be inside a finally clause.

The physical connection to the EIS remains open and the IConnection object that is holding the physical connection reverts to the connection pool of the WebAS Java server.

Connection pooling properties are defined in the WebAS Java server administration, per connector/EIS type.