weblogic.management.configuration
Interface JDBCStoreMBean

All Superinterfaces:

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

All Known Subinterfaces:

TransactionLogJDBCStoreMBean

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.

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()

Default Value:

20

Maximum Value:

100

Minimum Value:

1

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()

Default Value:

20

Maximum Value:

100

Minimum Value:

1

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()

Default Value:

20

Maximum Value:

100

Minimum Value:

1

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()

Default Value:

1

Maximum Value:

1000

Minimum Value:

1

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()

Default Value:

10

Maximum Value:

java.lang.Integer.MAX_VALUE

Minimum Value:

1

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()

Default Value:

200000

Maximum Value:

java.lang.Integer.MAX_VALUE

Minimum Value:

4000