Configuring WebLogic JDBC Tx DataSources


The data source is configured through the WebLogic Server Console. The Tx DataSources support distributed transaction where standard DataSources do not. Figure 16.3 shows the WebLogic JDBC Tx DataSources page to create a new JDBC Tx DataSource. Follow these steps to configure a new Tx DataSource:

  1. Connect to your WebLogic Server Console using a web browser.

  2. Select Services/JDBC/Tx DataSources from the navigation tree on the left side of the console.

  3. Click the "Configure a new JDBC Tx DataSource..." link.

  4. Fill in the form as described in Table 16.4.

  5. Click the Apply button.

Tip

As shown in Figure 16.3, each field in the form is preceded with a "?" character. Click on the "?" to view context-sensitive help for the particular field.

Figure 16.3. Tx DataSources are configured through the WebLogic Server Console to support distributed transactions.

graphics/16fig03.jpg


Table 16.4. The Tx DataSource Is Configured Through the WebLogic Server Console

Field Name

Description

Name:

Any name of your choosing as long as no other data sources are using it.

JNDI Name:

This is the name that the application will lookup using JNDI to get this data source.

Pool Name:

This is the name of a JDBC connection pool that is associated with this Tx DataSource.

Emulate Two-Phase Commit for non-XA Driver: (check box)

Set this field if there is no XA-compliant JDBC driver available for the database you are using and you are forced to emulate distributed transactions.

Row Prefetch Enabled: (check box)

This option is used to improve performance by allowing the WebLogic Server to prefetch multiple rows for a ResultSet.

Row Prefetch Size:

This is the number of rows that will be prefetched for a ResultSet. The default value is 48, the minimum is 2, and the maximum is 65536. It is not recommended to exceed 100 for the prefetch size because additional performance is rarely achieved above this level.

Stream Chunk Size:

This is the number of bytes that WebLogic Server will read from a data stream for methods such as getBinaryStream() . The default value is 256, the minimum is 1, and the maximum is 65536.



BEA WebLogic Platform 7
BEA WebLogic Platform 7
ISBN: 0789727129
EAN: 2147483647
Year: 2003
Pages: 360

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net