Adding a Connection Pool

A JDBC connection pool is a group of reusable connections for a particular database. Because creating each new physical connection is time consuming, the server maintains a pool of available connections to increase performance. When an application requests a connection, it obtains one from the pool. When an application closes a connection, the connection is returned to the pool.

Use the asadmin create-jdbc-connection-pool command to add a connection pool to the server. The syntax of the command is given below.

asadmin create-jdbc-connection-pool
     --user  admin_user
     --password admin_password
     --host localhost
     --port portno
     --datasourceclassname dsclassname
     --property User=ibank_user:Password=ibank_user:URL_PROP=db_url TMB

where, dsclassname is:

• oracle.jdbc.pool.OracleDataSource for Oracle

• com.pointbase.jdbc.jdbcDataSource for PointBase

URL_PROP is:

• url for Oracle

• DatabaseName for PointBase

db_url is:

• jdbc:oracle:thin:@ORACLE_HOST:1521:SID for Oracle, where ORACLE_HOST is the machine name/IP address on which the database is installed, and SID is the System ID of the Oracle database.

• jdbc:pointbase:server://POINTBASE_HOST:9092/migration-samples for Pointbase, where POINTBASE_HOST is the machine name/IP address on which the database is installed. This will be localhost in most cases.