Internal Connection Pool Creation Overview

You can create internal connection pools only for server sessions (not for any other session type, including database sessions).

You can create an internal connection pool using TopLink Workbench or Java code. Oracle recommends that you use TopLink Workbench to create and manage your internal connection pools. For more information, see "Using TopLink Workbench".

Alternatively, you can create internal connection pools in Java. For more information on creating sessions in Java, see the Oracle TopLink API Reference.

After you create an internal connection pool, you must configure its various options (see "Internal Connection Pool Configuration Overview").

After you create and configure a sequence connection pool, TopLink uses it whenever it needs to assign an identifier to a new object.

After you create and configure a named connection pool, you use it in your application by passing in a ConnectionPolicy when you acquire a client session (see "Acquiring a Client Session that Uses a Named Connection Pool").

Using TopLink Workbench

Before you create a connection pool, you must first create a server session (see "Creating a Server Session").

To create a new TopLink internal connection pool, use this procedure:

1. Select the server session in the Navigator in which you want to create a connection pool.

2. 
   Click the appropriate button on the toolbar to create the type of connection pool you want:

   • To create a named connection pool, select Create a New Named Connection Pool, enter a name, and click OK.

   • To create a sequence connection pool, select Add the Sequence Connection Pool.

   • To create a write connection pool, select Add the Write Connection Pool.

   You can also create a new internal connection pool by right-clicking the server session configuration in the Navigator and selecting New > Named Connection Pool, Sequence Connection Pool, or Write Connection Pool from the context menu.