Connection pool can also be used by application directly. Application can use the two following APIs defined in ConnectionPool interface.
public interface ConnectionPool { public Connection borrowConnection() throws Exception;
public void returnConnection(Connection con) throws Exception;
}
You should set the configuration of the connection pool according to the guide in the Tasks section. After getting a connection pool instance from the configuration, you can get a JDBC connection from pool by calling borrowConnection. You should call returnConnection to release the connection when connection is not used. The connection pool definition can be referred by other JDBC DAO implementation like EJ JDBC DAO or Access Control JDBC DAO. The table name and schema name should be set in attribute of DAO. The following is an example of EJ definition.