JBoss AS7 7.1.1 Model Reference

  1. JBoss AS7 7.1.1
  2. subsystem=datasources
  3. xa-data-source

A JDBC XA data-source configuration

Children (1)

Attributes (55)

  • allocation-retry The allocation retry element indicates the number of times that allocating a connection should be tried before throwing an exception
    • Attribute Value
    Type INT
    Nillable true
    Expressions Allowed false
    Storage configuration
    Access Type read-write
    Restart Required no-services
  • allocation-retry-wait-millis The allocation retry wait millis element specifies the amount of time, in milliseconds, to wait between retrying to allocate a connection
    • Attribute Value
    Type LONG
    Nillable true
    Expressions Allowed false
    Storage configuration
    Access Type read-write
    Restart Required no-services
  • background-validation An element to specify that connections should be validated on a background thread versus being validated prior to use. Changing this value can be done only on disabled datasource, requires a server restart otherwise.
    • Attribute Value
    Default Value false
    Type BOOLEAN
    Nillable true
    Expressions Allowed false
    Storage configuration
    Access Type read-write
    Restart Required no-services
  • background-validation-millis The background-validation-millis element specifies the amount of time, in milliseconds, that background validation will run. Changing this value can be done only on disabled datasource, requires a server restart otherwise
    • Attribute Value
    Type LONG
    Nillable true
    Expressions Allowed false
    Storage configuration
    Access Type read-write
    Restart Required no-services
  • blocking-timeout-wait-millis The blocking-timeout-millis element specifies the maximum time, in milliseconds, to block while waiting for a connection before throwing an exception. Note that this blocks only while waiting for locking a connection, and will never throw an exception if creating a new connection takes an inordinately long time
    • Attribute Value
    Type LONG
    Nillable true
    Expressions Allowed false
    Storage configuration
    Access Type read-write
    Restart Required no-services
  • check-valid-connection-sql Specify an SQL statement to check validity of a pool connection. This may be called when managed connection is obtained from the pool
    • Attribute Value
    Type STRING
    Nillable true
    Expressions Allowed false
    Storage configuration
    Access Type read-write
    Restart Required no-services
  • driver-name Defines the JDBC driver the datasource should use. It is a symbolic name matching the the name of installed driver. In case the driver is deployed as jar, the name is the name of deployment unit
    • Attribute Value
    Type STRING
    Nillable true
    Expressions Allowed false
    Storage configuration
    Access Type read-write
    Restart Required no-services
  • enabled Specifies if the datasource should be enabled
    • Attribute Value
    Type BOOLEAN
    Nillable true
    Expressions Allowed false
    Storage configuration
    Access Type read-only
  • exception-sorter-class-name An org.jboss.jca.adapters.jdbc.ExceptionSorter that provides an isExceptionFatal(SQLException) method to validate if an exception should broadcast an error
    • Attribute Value
    Type STRING
    Nillable true
    Expressions Allowed false
    Storage configuration
    Access Type read-write
    Restart Required no-services
  • exception-sorter-properties The exception sorter properties
    • Attribute Value
    Type OBJECT
    Nillable true
    Expressions Allowed false
    Storage configuration
    Access Type read-write
    Restart Required no-services
  • flush-strategy Specifies how the pool should be flush in case of an error. Valid values are: FailingConnectionOnly (default), IdleConnections and EntirePool
    • Attribute Value
    Default Value "FailingConnectionOnly"
    Type STRING
    Nillable true
    Expressions Allowed false
    Storage configuration
    Access Type read-write
    Restart Required no-services
  • idle-timeout-minutes The idle-timeout-minutes elements specifies the maximum time, in minutes, a connection may be idle before being closed. The actual maximum time depends also on the IdleRemover scan time, which is half of the smallest idle-timeout-minutes value of any pool. Changing this value can be done only on disabled datasource, requires a server restart otherwise.
    • Attribute Value
    Type LONG
    Nillable true
    Expressions Allowed false
    Storage configuration
    Access Type read-write
    Restart Required no-services
  • interleaving An element to enable interleaving for XA connections
    • Attribute Value
    Default Value false
    Type BOOLEAN
    Nillable true
    Expressions Allowed false
    Storage configuration
    Access Type read-write
    Restart Required no-services
  • jndi-name Specifies the JNDI name for the datasource
    • Attribute Value
    Type STRING
    Nillable true
    Expressions Allowed false
    Storage configuration
    Access Type read-write
    Restart Required no-services
  • jta Enable JTA integration
    • Attribute Value
    Default Value true
    Type BOOLEAN
    Nillable true
    Expressions Allowed false
    Storage configuration
    Access Type read-write
    Restart Required no-services
  • max-pool-size The max-pool-size element specifies the maximum number of connections for a pool. No more connections will be created in each sub-pool
    • Attribute Value
    Default Value 20
    Type INT
    Nillable true
    Expressions Allowed false
    Storage configuration
    Access Type read-write
    Restart Required no-services
  • min-pool-size The min-pool-size element specifies the minimum number of connections for a pool
    • Attribute Value
    Default Value 0
    Type INT
    Nillable true
    Expressions Allowed false
    Storage configuration
    Access Type read-write
    Restart Required no-services
  • new-connection-sql Specifies an SQL statement to execute whenever a connection is added to the connection pool
    • Attribute Value
    Type STRING
    Nillable true
    Expressions Allowed false
    Storage configuration
    Access Type read-write
    Restart Required no-services
  • no-recovery Specifies if the connection pool should be excluded from recovery
    • Attribute Value
    Type BOOLEAN
    Nillable true
    Expressions Allowed false
    Storage configuration
    Access Type read-write
    Restart Required no-services
  • no-tx-separate-pool Oracle does not like XA connections getting used both inside and outside a JTA transaction. To workaround the problem you can create separate sub-pools for the different contexts
    • Attribute Value
    Default Value false
    Type BOOLEAN
    Nillable true
    Expressions Allowed false
    Storage configuration
    Access Type read-write
    Restart Required no-services
  • pad-xid Should the Xid be padded
    • Attribute Value
    Default Value false
    Type BOOLEAN
    Nillable true
    Expressions Allowed false
    Storage configuration
    Access Type read-write
    Restart Required no-services
  • password Specifies the password used when creating a new connection
    • Attribute Value
    Type STRING
    Nillable true
    Expressions Allowed false
    Storage configuration
    Access Type read-write
    Restart Required no-services
  • pool-prefill Should the pool be prefilled. Changing this value can be done only on disabled datasource, requires a server restart otherwise.
    • Attribute Value
    Default Value false
    Type BOOLEAN
    Nillable true
    Expressions Allowed false
    Storage configuration
    Access Type read-write
    Restart Required no-services
  • pool-use-strict-min Specifies if the min-pool-size should be considered strictly
    • Attribute Value
    Default Value false
    Type BOOLEAN
    Nillable true
    Expressions Allowed false
    Storage configuration
    Access Type read-write
    Restart Required no-services
  • prepared-statements-cache-size The number of prepared statements per connection in an LRU cache
    • Attribute Value
    Type LONG
    Nillable true
    Expressions Allowed false
    Storage configuration
    Access Type read-write
    Restart Required no-services
  • query-timeout Any configured query timeout in seconds. If not provided no timeout will be set
    • Attribute Value
    Type LONG
    Nillable true
    Expressions Allowed false
    Storage configuration
    Access Type read-write
    Restart Required no-services
  • reauth-plugin-class-name The fully qualified class name of the reauthentication plugin implementation
    • Attribute Value
    Type STRING
    Nillable true
    Expressions Allowed false
    Storage configuration
    Access Type read-write
    Restart Required no-services
  • reauth-plugin-properties The properties for the reauthentication plugin
    • Attribute Value
    Type OBJECT
    Nillable true
    Expressions Allowed false
    Storage configuration
    Access Type read-write
    Restart Required no-services
  • recovery-password The password used for recovery
    • Attribute Value
    Type STRING
    Nillable true
    Expressions Allowed false
    Storage configuration
    Access Type read-write
    Restart Required no-services
  • recovery-plugin-class-name The fully qualified class name of the recovery plugin implementation
    • Attribute Value
    Type STRING
    Nillable true
    Expressions Allowed false
    Storage configuration
    Access Type read-write
    Restart Required no-services
  • recovery-plugin-properties The properties for the recovery plugin
    • Attribute Value
    Type OBJECT
    Nillable true
    Expressions Allowed false
    Storage configuration
    Access Type read-write
    Restart Required no-services
  • recovery-security-domain The security domain used for recovery
    • Attribute Value
    Type STRING
    Nillable true
    Expressions Allowed false
    Storage configuration
    Access Type read-write
    Restart Required no-services
  • recovery-username The user name used for recovery
    • Attribute Value
    Type STRING
    Nillable true
    Expressions Allowed false
    Storage configuration
    Access Type read-write
    Restart Required no-services
  • same-rm-override The is-same-rm-override element allows one to unconditionally set whether the javax.transaction.xa.XAResource.isSameRM(XAResource) returns true or false
    • Attribute Value
    Type BOOLEAN
    Nillable true
    Expressions Allowed false
    Storage configuration
    Access Type read-write
    Restart Required no-services
  • security-domain Specifies the security domain which defines the javax.security.auth.Subject that are used to distinguish connections in the pool
    • Attribute Value
    Type STRING
    Nillable true
    Expressions Allowed false
    Storage configuration
    Access Type read-write
    Restart Required no-services
  • set-tx-query-timeout Whether to set the query timeout based on the time remaining until transaction timeout. Any configured query timeout will be used if there is no transaction
    • Attribute Value
    Default Value false
    Type BOOLEAN
    Nillable true
    Expressions Allowed false
    Storage configuration
    Access Type read-write
    Restart Required no-services
  • share-prepared-statements Whether to share prepared statements, i.e. whether asking for same statement twice without closing uses the same underlying prepared statement
    • Attribute Value
    Default Value false
    Type BOOLEAN
    Nillable true
    Expressions Allowed false
    Storage configuration
    Access Type read-write
    Restart Required no-services
  • spy Enable spying of SQL statements
    • Attribute Value
    Default Value false
    Type BOOLEAN
    Nillable true
    Expressions Allowed false
    Storage configuration
    Access Type read-write
    Restart Required no-services
  • stale-connection-checker-class-name An org.jboss.jca.adapters.jdbc.StaleConnectionChecker that provides an isStaleConnection(SQLException) method which if it returns true will wrap the exception in an org.jboss.jca.adapters.jdbc.StaleConnectionException
    • Attribute Value
    Type STRING
    Nillable true
    Expressions Allowed false
    Storage configuration
    Access Type read-write
    Restart Required no-services
  • stale-connection-checker-properties The stale connection checker properties
    • Attribute Value
    Type OBJECT
    Nillable true
    Expressions Allowed false
    Storage configuration
    Access Type read-write
    Restart Required no-services
  • track-statements Whether to check for unclosed statements when a connection is returned to the pool, result sets are closed, a statement is closed or return to the prepared statement cache. Valid values are: "false" - do not track statements, "true" - track statements and result sets and warn when they are not closed, "nowarn" - track statements but do not warn about them being unclosed
    • Attribute Value
    Default Value "NOWARN"
    Type STRING
    Nillable true
    Expressions Allowed false
    Storage configuration
    Access Type read-write
    Restart Required no-services
  • transaction-isolation Set the java.sql.Connection transaction isolation level. Valid values are: TRANSACTION_READ_UNCOMMITTED, TRANSACTION_READ_COMMITTED, TRANSACTION_REPEATABLE_READ, TRANSACTION_SERIALIZABLE and TRANSACTION_NONE
    • Attribute Value
    Type STRING
    Nillable true
    Expressions Allowed false
    Storage configuration
    Access Type read-write
    Restart Required no-services
  • url-delimiter Specifies the delimiter for URLs in connection-url for HA datasources
    • Attribute Value
    Type STRING
    Nillable true
    Expressions Allowed false
    Storage configuration
    Access Type read-write
    Restart Required no-services
  • url-selector-strategy-class-name A class that implements org.jboss.jca.adapters.jdbc.URLSelectorStrategy
    • Attribute Value
    Type STRING
    Nillable true
    Expressions Allowed false
    Storage configuration
    Access Type read-write
    Restart Required no-services
  • use-ccm Enable the use of a cached connection manager
    • Attribute Value
    Default Value true
    Type BOOLEAN
    Nillable true
    Expressions Allowed false
    Storage configuration
    Access Type read-write
    Restart Required no-services
  • use-fast-fail Whether to fail a connection allocation on the first try if it is invalid (true) or keep trying until the pool is exhausted of all potential connections (false)
    • Attribute Value
    Default Value false
    Type BOOLEAN
    Nillable true
    Expressions Allowed false
    Storage configuration
    Access Type read-write
    Restart Required no-services
  • use-java-context Setting this to false will bind the datasource into global JNDI
    • Attribute Value
    Default Value true
    Type BOOLEAN
    Nillable true
    Expressions Allowed false
    Storage configuration
    Access Type read-write
    Restart Required no-services
  • use-try-lock Any configured timeout for internal locks on the resource adapter objects in seconds
    • Attribute Value
    Type LONG
    Nillable true
    Expressions Allowed false
    Storage configuration
    Access Type read-write
    Restart Required no-services
  • user-name Specify the user name used when creating a new connection
    • Attribute Value
    Type STRING
    Nillable true
    Expressions Allowed false
    Storage configuration
    Access Type read-write
    Restart Required no-services
  • valid-connection-checker-class-name An org.jboss.jca.adapters.jdbc.ValidConnectionChecker that provides an isValidConnection(Connection) method to validate a connection. If an exception is returned that means the connection is invalid. This overrides the check-valid-connection-sql element
    • Attribute Value
    Type STRING
    Nillable true
    Expressions Allowed false
    Storage configuration
    Access Type read-write
    Restart Required no-services
  • valid-connection-checker-properties The valid connection checker properties
    • Attribute Value
    Type OBJECT
    Nillable true
    Expressions Allowed false
    Storage configuration
    Access Type read-write
    Restart Required no-services
  • validate-on-match The validate-on-match element specifies if connection validation should be done when a connection factory attempts to match a managed connection. This is typically exclusive to the use of background validation
    • Attribute Value
    Default Value false
    Type BOOLEAN
    Nillable true
    Expressions Allowed false
    Storage configuration
    Access Type read-write
    Restart Required no-services
  • wrap-xa-resource Should the XAResource instances be wrapped in a org.jboss.tm.XAResourceWrapper instance
    • Attribute Value
    Default Value true
    Type BOOLEAN
    Nillable true
    Expressions Allowed false
    Storage configuration
    Access Type read-write
    Restart Required no-services
  • xa-datasource-class The fully qualified name of the javax.sql.XADataSource implementation
    • Attribute Value
    Type STRING
    Nillable true
    Expressions Allowed false
    Storage configuration
    Access Type read-write
    Restart Required no-services
  • xa-resource-timeout The value is passed to XAResource.setTransactionTimeout(), in seconds. Default is zero
    • Attribute Value
    Type INT
    Nillable true
    Expressions Allowed false
    Storage configuration
    Access Type read-write
    Restart Required no-services

Operations (4)

  • add Add a new XA data-source
    Request Parameter Type Required Expressions Allowed Default value Description
    xa-datasource-class STRING false false The fully qualified name of the javax.sql.XADataSource implementation
    jndi-name STRING true false Specifies the JNDI name for the datasource
    driver-name STRING true false Defines the JDBC driver the datasource should use. It is a symbolic name matching the the name of installed driver. In case the driver is deployed as jar, the name is the name of deployment unit
    new-connection-sql STRING false false Specifies an SQL statement to execute whenever a connection is added to the connection pool
    url-delimiter STRING false false Specifies the delimiter for URLs in connection-url for HA datasources
    url-selector-strategy-class-name STRING false false A class that implements org.jboss.jca.adapters.jdbc.URLSelectorStrategy
    use-java-context BOOLEAN false false true Setting this to false will bind the datasource into global JNDI
    max-pool-size INT false false 20 The max-pool-size element specifies the maximum number of connections for a pool. No more connections will be created in each sub-pool
    min-pool-size INT false false 0 The min-pool-size element specifies the minimum number of connections for a pool
    pool-prefill BOOLEAN false false false Should the pool be prefilled. Changing this value can be done only on disabled datasource, requires a server restart otherwise.
    pool-use-strict-min BOOLEAN false false false Specifies if the min-pool-size should be considered strictly
    interleaving BOOLEAN false false false An element to enable interleaving for XA connections
    no-tx-separate-pool BOOLEAN false false false Oracle does not like XA connections getting used both inside and outside a JTA transaction. To workaround the problem you can create separate sub-pools for the different contexts
    pad-xid BOOLEAN false false false Should the Xid be padded
    same-rm-override BOOLEAN false false The is-same-rm-override element allows one to unconditionally set whether the javax.transaction.xa.XAResource.isSameRM(XAResource) returns true or false
    wrap-xa-resource BOOLEAN false false true Should the XAResource instances be wrapped in a org.jboss.tm.XAResourceWrapper instance
    user-name STRING false false Specify the user name used when creating a new connection
    password STRING false false Specifies the password used when creating a new connection
    security-domain STRING false false Specifies the security domain which defines the javax.security.auth.Subject that are used to distinguish connections in the pool
    reauth-plugin-class-name STRING false false The fully qualified class name of the reauthentication plugin implementation
    reauth-plugin-properties OBJECT false false The properties for the reauthentication plugin
    flush-strategy STRING false false "FailingConnectionOnly" Specifies how the pool should be flush in case of an error. Valid values are: FailingConnectionOnly (default), IdleConnections and EntirePool
    prepared-statements-cache-size LONG false false The number of prepared statements per connection in an LRU cache
    share-prepared-statements BOOLEAN false false false Whether to share prepared statements, i.e. whether asking for same statement twice without closing uses the same underlying prepared statement
    track-statements STRING false false "NOWARN" Whether to check for unclosed statements when a connection is returned to the pool, result sets are closed, a statement is closed or return to the prepared statement cache. Valid values are: "false" - do not track statements, "true" - track statements and result sets and warn when they are not closed, "nowarn" - track statements but do not warn about them being unclosed
    allocation-retry INT false false The allocation retry element indicates the number of times that allocating a connection should be tried before throwing an exception
    allocation-retry-wait-millis LONG false false The allocation retry wait millis element specifies the amount of time, in milliseconds, to wait between retrying to allocate a connection
    blocking-timeout-wait-millis LONG false false The blocking-timeout-millis element specifies the maximum time, in milliseconds, to block while waiting for a connection before throwing an exception. Note that this blocks only while waiting for locking a connection, and will never throw an exception if creating a new connection takes an inordinately long time
    idle-timeout-minutes LONG false false The idle-timeout-minutes elements specifies the maximum time, in minutes, a connection may be idle before being closed. The actual maximum time depends also on the IdleRemover scan time, which is half of the smallest idle-timeout-minutes value of any pool. Changing this value can be done only on disabled datasource, requires a server restart otherwise.
    query-timeout LONG false false Any configured query timeout in seconds. If not provided no timeout will be set
    use-try-lock LONG false false Any configured timeout for internal locks on the resource adapter objects in seconds
    set-tx-query-timeout BOOLEAN false false false Whether to set the query timeout based on the time remaining until transaction timeout. Any configured query timeout will be used if there is no transaction
    transaction-isolation STRING false false Set the java.sql.Connection transaction isolation level. Valid values are: TRANSACTION_READ_UNCOMMITTED, TRANSACTION_READ_COMMITTED, TRANSACTION_REPEATABLE_READ, TRANSACTION_SERIALIZABLE and TRANSACTION_NONE
    check-valid-connection-sql STRING false false Specify an SQL statement to check validity of a pool connection. This may be called when managed connection is obtained from the pool
    exception-sorter-class-name STRING false false An org.jboss.jca.adapters.jdbc.ExceptionSorter that provides an isExceptionFatal(SQLException) method to validate if an exception should broadcast an error
    exception-sorter-properties OBJECT false false The exception sorter properties
    stale-connection-checker-class-name STRING false false An org.jboss.jca.adapters.jdbc.StaleConnectionChecker that provides an isStaleConnection(SQLException) method which if it returns true will wrap the exception in an org.jboss.jca.adapters.jdbc.StaleConnectionException
    stale-connection-checker-properties OBJECT false false The stale connection checker properties
    valid-connection-checker-class-name STRING false false An org.jboss.jca.adapters.jdbc.ValidConnectionChecker that provides an isValidConnection(Connection) method to validate a connection. If an exception is returned that means the connection is invalid. This overrides the check-valid-connection-sql element
    valid-connection-checker-properties OBJECT false false The valid connection checker properties
    background-validation-millis LONG false false The background-validation-millis element specifies the amount of time, in milliseconds, that background validation will run. Changing this value can be done only on disabled datasource, requires a server restart otherwise
    background-validation BOOLEAN false false false An element to specify that connections should be validated on a background thread versus being validated prior to use. Changing this value can be done only on disabled datasource, requires a server restart otherwise.
    use-fast-fail BOOLEAN false false false Whether to fail a connection allocation on the first try if it is invalid (true) or keep trying until the pool is exhausted of all potential connections (false)
    validate-on-match BOOLEAN false false false The validate-on-match element specifies if connection validation should be done when a connection factory attempts to match a managed connection. This is typically exclusive to the use of background validation
    xa-resource-timeout INT false false The value is passed to XAResource.setTransactionTimeout(), in seconds. Default is zero
    spy BOOLEAN false false false Enable spying of SQL statements
    use-ccm BOOLEAN false false true Enable the use of a cached connection manager
    recovery-username STRING false false The user name used for recovery
    recovery-password STRING false false The password used for recovery
    recovery-security-domain STRING false false The security domain used for recovery
    recovery-plugin-class-name STRING false false The fully qualified class name of the recovery plugin implementation
    recovery-plugin-properties OBJECT false false The properties for the recovery plugin
    no-recovery BOOLEAN false false Specifies if the connection pool should be excluded from recovery
    jta BOOLEAN false false true Enable JTA integration
  • disable Disable the XA data-source
  • enable Enable the XA data-source
    Request Parameter Type Required Expressions Allowed Default value Description
    persistent BOOLEAN false false true if true enable attribute is persisted
  • remove Remove the XA data-source