Creating a JDBC Connection Pool for the JavaDB Database

The following procedure provides the steps for creating a JavaDB JDBC connection pool.

To create a JDBC Connection Pool

1. In your web browser, log into the Sun Java System Application Server Administrator Console. For example:

   http://localhost:4848, username:admin, password: adminadmin

2. In the navigation tree, expand the following nodes: Resources -> JDBC.

3. Select Connection Pools, and in the right panel, click the New button.

4. Under General Settings, specify a name (such as bpelseDB).

5. Set the Resource Type to javax.sql.XADatasource.

6. Set the database vendor to Derby and click Next.

7. Under Connection Validation, enable Allow Non Component Callers by selecting the Enabled check box.

8. Under Additional Properties, specify the ServerName, User, Password and DatabaseName.

   You can use the following values, or choose your own for user, password and database name (keep create=true flag).

   • ServerName: machine-name

   • DatabaseName: DatabaseName: bpelseDB;create=true

   • User: bpelse_user

   • Password: bpelse_user

9. Click Finish, click the connection pool name and click the Ping button.

   This verifies your database connection.

10. Click Finish to prepare for creating a new JDBC resource.