Configuring a Nontransactional Read Login

When you use an external transaction controller (see "Configuring the Server Platform"), establishing a connection requires not only the usual connection setup overhead, but also transactional overhead. If your application reads data only to display it and only infrequently modifies data, you can configure an internal read connection pool to use its own connection specification that does not use the external transaction controller. This may improve performance by reducing the time it takes to establish a new read connection.

Using TopLink Workbench

To enable the configuration of nontransactional connection information for a TopLink read connection pool, use this procedure:

Expand a server session to reveal its connection pools in the Navigator.
Select a read connection pool in the Navigator. Its properties appear in the Editor.
Click the Login tab. The Login tab appears.
Click the Connection subtab. The Connection subtab appears.

Figure 86-3 Login Tab, Connection Subtab

Description of "Figure 86-3 Login Tab, Connection Subtab"

To enable a nontransactional read login, select the Use Non-Transactional Read Login option (see "Externally Managed Transactional Data Sources"). Continue with "Configuring Connection Pool Connection Options" to specify the connection information.