Sun Java System Application Server Platform Edition 8.1 2005Q2 Update 2 Upgrade and Migration Guide

- Previous: Preparing for Migrating the iBank Application
- Next: Adding a JDBC Resource

### 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.

- Previous: Preparing for Migrating the iBank Application
- Next: Adding a JDBC Resource

- © 2010, Oracle Corporation and/or its affiliates