Configuring Properties

For all connection pools, except write connection pools, you can specify arbitrary named values, called properties.

Some data sources require additional, driver-specific properties not supported in the ConnectionPool API. Add these properties to the ConnectionPool so that TopLink can pass them to the driver.

Using TopLink Workbench

To specify arbitrary named value pairs that TopLink associates with a ConnectionPool, use this procedure:

1. Expand a server session to reveal its connection pools in the Navigator.

2. Select a read, named, or sequence connection pool in the Navigator. Its properties appear in the Editor.

3. Click the Login tab. The Login tab appears.

4. Click the Properties subtab. The Properties subtab appears.

   Figure 89-2 Login Tab, Properties Subtab

   
   Description of "Figure 89-2 Login Tab, Properties Subtab"
   
   

Use the following information to add or edit a login property on the Add Property dialog box to add or edit a login property:

Option	Description
Name	The name by which TopLink retrieves the property value using the DatasourceLogin method getProperty.
Value	The value TopLink retrieves using the DatasourceLogin method getProperty passing in the corresponding property name. Using TopLink Workbench, you can set only character values which TopLink returns as String objects.

To add (or change) a new Name/Value property, click Add (or Edit).

To delete an existing property, select the Name/Value row and click Remove.

Using Java

Using Java, you can set any Object value using the DatasourceLogin method setProperty. To remove a property, use the DatasourceLogin method removeProperty.