Skip navigation links

weblogic.management.configuration
Interface JDBCStoreMBean

All Superinterfaces:

ConfigurationMBean, DeploymentMBean, DescriptorBean, DynamicDeploymentMBean, DynamicMBean, GenericJDBCStoreMBean, MBeanRegistration, NotificationBroadcaster, PersistentStoreMBean, SettableBean, WebLogicMBean

All Known Subinterfaces:

TransactionLogJDBCStoreMBean

@SingleTargetOnly
public interface JDBCStoreMBean

extends GenericJDBCStoreMBean, PersistentStoreMBean

Defines an instance of the persistent store that stores its persistent records in a JDBC-accessible database. It may be used by JMS and by other subsystems.

Since:

9.0.0.0

getDataSource

JDBCSystemResourceMBean getDataSource()

The JDBC data source used by this JDBC store to access its backing table.

The specified data source must use a non-XA JDBC driver since connection pools for XA JDBC drivers are not supported.

setDataSource

void setDataSource(JDBCSystemResourceMBean dataSource)
                   throws InvalidAttributeValueException

Sets the value of the DataSource attribute.

Throws:

InvalidAttributeValueException

See Also:

JDBCStoreMBean.getDataSource()

getDeletesPerBatchMaximum

int getDeletesPerBatchMaximum()

The maximum number of table rows that are deleted per database call.

• When possible, a JDBC store uses JDBC 3.0 batching to batch concurrent client requests.
• Both the maximum batch size for concurrent inserts and for concurrent writes are configurable.
• To disable JDBC 3.0 batching, set the maximum batch size to 1.
• The maximum batch size has no effect on the maximum number of concurrent client requests.

Returns:

The deletesPerBatchMaximum value

See Also:

JDBCStoreMBean.getInsertsPerBatchMaximum(), JDBCStoreMBean.getDeletesPerStatementMaximum()

setDeletesPerBatchMaximum

void setDeletesPerBatchMaximum(int deletesPerBatchMaximum)
                               throws InvalidAttributeValueException

Sets the value of the DeletesPerBatchMaximum attribute.

Throws:

InvalidAttributeValueException

DistributedManagementException

See Also:

JDBCStoreMBean.getDeletesPerBatchMaximum()

getInsertsPerBatchMaximum

int getInsertsPerBatchMaximum()

The maximum number of table rows that are inserted per database call.

• When possible, a JDBC store uses JDBC 3.0 batching to batch concurrent client requests.
• Both the maximum batch size for concurrent inserts and for concurrent writes are configurable.
• To disable JDBC 3.0 batching, set the maximum batch size to 1.
• The maximum batch size has no effect on the maximum number of concurrent client requests.

Returns:

The insertsPerBatchMaximum value

See Also:

JDBCStoreMBean.getDeletesPerBatchMaximum(), JDBCStoreMBean.getDeletesPerStatementMaximum()

setInsertsPerBatchMaximum

void setInsertsPerBatchMaximum(int deletesPerBatchMaximum)
                               throws InvalidAttributeValueException

Sets the value of the InsertsPerBatchMaximu attribute.

Throws:

InvalidAttributeValueException

See Also:

JDBCStoreMBean.getInsertsPerBatchMaximum()

getDeletesPerStatementMaximum

int getDeletesPerStatementMaximum()

The maximum number of table rows that are deleted per database call.

• Applies only when a JDBC store does not use JDBC 3.0 batching to batch concurrent client requests.
• The maximum deletes per statement has no effect on the maximum number of concurrent client requests.
• For some databases, the JDBC store may choose a lower value than the one configured.

Returns:

The deletesPerStatementMaximum value

See Also:

JDBCStoreMBean.getDeletesPerBatchMaximum(), JDBCStoreMBean.getInsertsPerBatchMaximum()

setDeletesPerStatementMaximum

void setDeletesPerStatementMaximum(int deletesPerBatchMaximum)
                                   throws InvalidAttributeValueException

Sets the value of the DeletesPerStatementMaximum attribute.

Throws:

InvalidAttributeValueException

See Also:

JDBCStoreMBean.getDeletesPerStatementMaximum()

getWorkerCount

int getWorkerCount()

The number of JDBC store worker threads to process the workerload.

• A value of 1 indicates a single thread is used (the default).
• A value greater than 1 indicates that multiple threads are used.
• For Oracle databases, Oracle recommends users rebuild the primary key index into a reverse index for the JDBC Store table when the worker count is greater than 1.
• For non-Oracle databases, refer to the database provider's documentation for help with indexing.

Returns:

The WorkerCount value

setWorkerCount

void setWorkerCount(int workerCount)
                    throws InvalidAttributeValueException

Sets the value of the WorkerCount attribute.

Throws:

InvalidAttributeValueException

See Also:

JDBCStoreMBean.getWorkerCount()

getWorkerPreferredBatchSize

int getWorkerPreferredBatchSize()

Specifies the batch size when the Worker Count attribute is configured to a value greater than 1.

Used to configure the workload the JDBC store incrementally puts on each worker thread. The workload consists of IO requests which are grouped and pushed to each JDBC worker thread for processing. If the IO request is very large (for example 1M), then tune this attribute to a smaller value.

Returns:

The WorkerPreferredBatchSize value

setWorkerPreferredBatchSize

void setWorkerPreferredBatchSize(int workerLoadSize)
                                 throws InvalidAttributeValueException

Sets the value of the WorkerPreferredBatchSize attribute.

The default value is 10.

Throws:

InvalidAttributeValueException

See Also:

JDBCStoreMBean.getWorkerPreferredBatchSize()

getThreeStepThreshold

int getThreeStepThreshold()

Specifies the threshold, in bytes, when the JDBC store uses 3 steps (insert, select, populate) instead of 1 step (insert) to populate an Oracle Blob data type.

Applies only to Oracle databases where a Blob data type is used instead of the default Long Raw data type for record data.

The default value is 200000.

Returns:

The threeStepThreshold value

setThreeStepThreshold

void setThreeStepThreshold(int threeStepThreshold)
                           throws InvalidAttributeValueException

Sets the value of the ThreeStepThreshold attribute.

Throws:

InvalidAttributeValueException

See Also:

JDBCStoreMBean.getThreeStepThreshold()

setOraclePiggybackCommitEnabled

void setOraclePiggybackCommitEnabled(boolean enable)

Sets the value of the OraclePiggybackCommitEnabled attribute.

isOraclePiggybackCommitEnabled

boolean isOraclePiggybackCommitEnabled()

Enables committing a batch of INSERT or DELETE operations with the last operation of the transaction instead of issuing a separate commit call to database server which saves a server round trip. This feature benefits applications that have many transactions of a small number of operations or small messages. This feature should be used only when configuring a JDBC store in Oracle Exalogic environments.

setReconnectRetryPeriodMillis

void setReconnectRetryPeriodMillis(int reconnectRetryPeriodMillis)

Set the length of time in milliseconds during which the persistent store will attempt to re-establish a connection to the database. The JDBC Store will repeatedly attempt to reconnection to the database during this period until the period has expired. The JDBC store will wait a specified period of time between reconnection attempts.

The reconnection period applies to JDBC connections regardless of the database that is used for the JDBC store.

See Also:

JDBCStoreMBean.getReconnectRetryPeriodMillis(), JDBCStoreMBean.getReconnectRetryIntervalMillis(), JDBCStoreMBean.setReconnectRetryIntervalMillis(int)

getReconnectRetryPeriodMillis

int getReconnectRetryPeriodMillis()

Returns the length of time in milliseconds during which the persistent store will attempt to re-establish a connection to the database. Successive reconnection attempts will be attempted after a fixed delay that is specified by the reconnection retry interval.

The reconnection period applies to JDBC connections regardless of the database that is used for the JDBC store.

The default value is 1000

Returns:

The length of the reconnection retry period in milliseconds

See Also:

JDBCStoreMBean.setReconnectRetryPeriodMillis(int), JDBCStoreMBean.getReconnectRetryIntervalMillis(), JDBCStoreMBean.setReconnectRetryIntervalMillis(int)

setReconnectRetryIntervalMillis

void setReconnectRetryIntervalMillis(int reconnectRetryIntervalMillis)

Set the length of time in milliseconds between reconnection attempts during the reconnection retry period.

The reconnection interval applies to JDBC connections regardless of the database that is used for the JDBC store.

getReconnectRetryIntervalMillis

int getReconnectRetryIntervalMillis()

The length of time in milliseconds between reconnection attempts during the reconnection retry period.

The reconnection interval applies to JDBC connections regardless of the database that is used for the JDBC store.

The default value is 200 milliseconds

Returns:

The length of time in milliseconds between reconnection attempts within the retry period

See Also:

JDBCStoreMBean.getReconnectRetryPeriodMillis(), JDBCStoreMBean.setReconnectRetryPeriodMillis(int)

Skip navigation links