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.