BEA Home | Events | Solutions | Partners | Products | Services | Download | Developer Center | WebSUPPORT
| WebLogic Server Doc Home | Console Online Help | Previous Topic | Next Topic | Contents | Index | View as PDF

JDBC Transaction Data Sources

This table describes the attributes you set in the Administration Console to configure and manage Transaction Data Sources. Read about Transaction Data Sources in Managing JDBC Connectivity.

Configuration

Attribute | Description | Range of Values | Default Value
--- | --- | --- | ---
Name | This attribute returns the name of this data source. | String | MyJDBC Tx Data Source
JNDI Name | Sets the JNDI path to where this TxDataSource is bound. Applications that look up the JNDI path will get a javax.sql.DataSource instance that corresponds to this TxDataSource. Note that the old style usage of DriverManager.getConnection() or Driver.Connect() has been deprecated in favor of looking up a datasource to obtain a connection. | Valid JNDI name | Null
Pool Name | This attribute allows the user to set the name of the connection pool that is associated with this TxDataSource. Calls to getConnection() on this TxDataSource will return a connection from the associated connection pool. | Valid connection pool name | Null
Enable Two-Phase Commit | This attribute allows the user to enable or disable the two phase commitment of transactions. Enable Two-Phase Commit allows non-XA JDBC drivers to pretend to participate in a the JDBC connection is the only participant in the transaction, but it is asking for trouble to have more than one resource participating in a transaction where one of them (the JDBC driver) is pretending to be an XA resource. There is a possibility of heuristic failures in such a situation. Set Enable Two-PhaseCommit (true) should be used only if you have no option (no decent XA driver available for a particular database, for example). If this TxDataSource is associated with an XA connection pool, or if there is only one resource participating in the distributed transaction, then this setting is ignored. | Boolean Enabled = Selected Not Enabled = Not Selected | Not Selected
Row Prefetch Enabled | Set to True to enable row prefetching between client and WebLogic Server for each ResultSet. When an external client does JDBC access through WebLogic Server, row prefetching improves performance by fetching multiple rows from the server to the client in one server access. The WebLogic Server will ignore this setting and not use row prefetching when the client and WebLogic Server are in the same JVM. | Boolean Enabled = Selected Not Enabled = Not Selected | Not Selected
Row Prefetch Size | The number of rows that will be prefetched between the client and WebLogic Server for each ResultSet. The optimal value is very dependent on the particulars of the query. Generally, increasing this number will increase performance, until a particular value is reached. At that point further increases do not result in any significant performance increase. Very rarely will increased performance result from exceeding 100 rows. The default value should be reasonable for most situations. | Legal Minimum = 2 Legal Maximum = 65536 | Default = 48
Stream Chunk Size | Determines the data chunk size for streaming datatypes. Streaming datatypes (for example resulting from a call to getBinarySTream())will be pulled in Stream Chunk Size-sized chunks from the WebLogic Server to the client as needed. | Legal Minimun = 1 Legal Maximum= 65,536 Units in bytes. | Default = 256

Targets

Servers

Attribute | Description | Range of Values | Default Value
--- | --- | --- | ---
Target Servers | This attribute allows the user to select the servers to be used as targets for this datasource. | List | Null

Clusters

Attribute | Description | Range of Values | Default Value
--- | --- | --- | ---
Target Clusters | This attribute allows the user to select the clusters to be used as targets for this datasource. | List | Null

Notes

Attribute | Description | Range of Values | Default Value
--- | --- | --- | ---
Notes | This attribute provides a space for optional user-supplied information. | The value must be an alphanumeric string. | Null

Copyright © 2001 BEA Systems, Inc. All rights reserved. Required browser: Netscape 4.0 or higher, or Microsoft Internet Explorer 4.0 or higher.