For the latest EclipseLink documentation, please see http://www.eclipse.org/eclipselink/documentation/
TOC Special:Whatlinkshere_Creating_an_Internal_Connection_Pool_(ELUG)[Related Topics]
For information, see Internal Connection Pools.
You can create internal connection pools only for server sessions (not for any other session type, including database sessions). For more information, see Creating an Internal Connection Pool.
After you create an internal connection pool, you must configure its various options.
After you create and configure a sequence connection pool, EclipseLink 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
How
to Acquire a Client Session that Uses a Named Connection Pool).
You can create an internal connection pool using the Workbench (see How to Create an Internal Connection Pool Using Workbench) or Java code. We recommend that you use the Workbench to create and manage your internal connection pools.
Alternatively, you can create internal connection pools in Java. For more information on creating sessions in Java, see the ’’EclipseLink API Reference.
Before you create a connection pool, you must first create a server session (see Creating a Server Session).
To create a new EclipseLink internal connection pool, use this procedure:
-
Select the server session in the Navigator in which you want to create a connection pool.
-
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.
Using Java, you can create read, write, and named connection pools. The #Example:Creating_Connection_Pools[Creating Connection Pools example] shows how to create connection pools. The #Example:Using_a_Single_Pool_for_Read_and_Write[Using a Single Pool for Read and Write example] shows an optimized connection pool, using the same connetion for both read and write operations.
[Example:Creating Connection Pools]# Creating Connection Pools
// Read
ConnectionPool pool = new ConnectionPool();
pool.setName("read");
pool.setLogin(login);
pool.setMaxNumberOfConnections(50);
pool.setMinNumberOfConnections(50);
serverSession.setReadConnectionPool(pool);
// Write
ConnectionPool pool = new ConnectionPool();
pool.setName("default");
pool.setLogin(login);
pool.setMaxNumberOfConnections(50);
pool.setMinNumberOfConnections(50);
serverSession.addConnectionPool(pool);
// Named
ConnectionPool pool = new ConnectionPool();
pool.setName("admin");
pool.setLogin(login);
pool.setMaxNumberOfConnections(2);
pool.setMinNumberOfConnections(2);
serverSession.addConnectionPool(pool);
[Using a Single Pool for Read and Write]# You can also use a single connection pools for both read and write operations, when the read and write pools use the same login information. This method requires fewer connections
Using a Single Pool for Read and Write
ConnectionPool pool = new ConnectionPool();
pool.setName("default");
pool.setLogin(login);
pool.setMaxNumberOfConnections(50);
pool.setMinNumberOfConnections(50);
serverSession.setReadConnectionPool(pool);
serverSession.addConnectionPool(pool);
Category:_EclipseLink_User’s_Guide[Category: EclipseLink User’s Guide] Category:_Release_1[Category: Release 1] Category:_Task[Category: Task]