WildFly Full 23 Model Reference

  1. home
  2. subsystem=datasources
  3. xa-data-source

A JDBC XA data-source configuration

Children (1)

Provided capabilities(1)

Attributes (75)

  • 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 true
    Storage configuration
    Access Type read-write
    Restart Required all-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 true
    Storage configuration
    Access Type read-write
    Restart Required all-services
  • allow-multiple-users Specifies if multiple users will access the datasource through the getConnection(user, password) method and hence if the internal pool type should account for that
    • Attribute Value
    Default Value false
    Type BOOLEAN
    Nillable true
    Expressions Allowed true
    Storage configuration
    Access Type read-write
    Restart Required all-services
  • authentication-context The Elytron authentication context which defines the javax.security.auth.Subject that is used to distinguish connections in the pool.
    • Attribute Value
    Capability reference
    Type STRING
    Nillable true
    Expressions Allowed false
    Storage configuration
    Access Type read-write
    Restart Required all-services
  • background-validation An element to specify that connections should be validated on a background thread versus being validated prior to use.
    • Attribute Value
    Type BOOLEAN
    Nillable true
    Expressions Allowed true
    Storage configuration
    Access Type read-write
    Restart Required all-services
  • background-validation-millis The background-validation-millis element specifies the amount of time, in milliseconds, that background validation will run.
    • Attribute Value
    Type LONG
    Nillable true
    Expressions Allowed true
    Min 1
    Max 2,147,483,647
    Unit MILLISECONDS
    Storage configuration
    Access Type read-write
    Restart Required all-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 true
    Unit MILLISECONDS
    Storage configuration
    Access Type read-write
    Restart Required no-services
  • capacity-decrementer-class Class defining the policy for decrementing connections in the pool
    • Attribute Value
    Type STRING
    Nillable true
    Expressions Allowed true
    Storage configuration
    Access Type read-write
    Restart Required all-services
  • capacity-decrementer-properties Properties to inject in class defining the policy for decrementing connections in the pool
    • Attribute Value
    Type OBJECT
    Nillable true
    Expressions Allowed true
    Storage configuration
    Access Type read-write
    Restart Required all-services
  • capacity-incrementer-class Class defining the policy for incrementing connections in the pool
    • Attribute Value
    Type STRING
    Nillable true
    Expressions Allowed true
    Storage configuration
    Access Type read-write
    Restart Required all-services
  • capacity-incrementer-properties Properties to inject in class defining the policy for incrementing connections in the pool
    • Attribute Value
    Type OBJECT
    Nillable true
    Expressions Allowed true
    Storage configuration
    Access Type read-write
    Restart Required all-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 true
    Storage configuration
    Access Type read-write
    Restart Required all-services
  • connectable Enable the use of CMR for this datasource. This feature means that a local resource can reliably participate in an XA transaction.
    • Attribute Value
    Default Value false
    Type BOOLEAN
    Nillable true
    Expressions Allowed true
    Storage configuration
    Access Type read-write
    Restart Required all-services
  • connection-listener-class Speciefies class name extending org.jboss.jca.adapters.jdbc.spi.listener.ConnectionListener that provides a possible to listen for connection activation and passivation in order to perform actions before the connection is returned to the application or returned to the pool.
    • Attribute Value
    Type STRING
    Nillable true
    Expressions Allowed true
    Storage configuration
    Access Type read-write
    Restart Required all-services
  • connection-listener-property Properties to be injected in class specified in connection-listener-class
    • Attribute Value
    Type OBJECT
    Nillable true
    Expressions Allowed true
    Storage configuration
    Access Type read-write
    Restart Required all-services
  • credential-reference Credential (from Credential Store) to authenticate on data source
    • Attribute Value
    Type OBJECT
    Nillable true
    Expressions Allowed false
    Storage configuration
    Access Type read-write
    Restart Required all-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 false
    Expressions Allowed true
    Storage configuration
    Access Type read-write
    Restart Required all-services
  • elytron-enabled Enables Elytron security for handling authentication of connections for recovery. The Elytron authentication-context to be used will be current context if no context is specified (see authentication-context).
    • Attribute Value
    Default Value false
    Type BOOLEAN
    Nillable true
    Expressions Allowed true
    Storage configuration
    Access Type read-write
    Restart Required all-services
  • enabled Specifies if the datasource should be enabled. Note this attribute will not be supported runtime in next versions.
    • Deprecated Since 3.0.0
    Specifies if the datasource should be enabled. Note this attribute will not be supported runtime in next versions.
    Attribute Value
    Default Value true
    Type BOOLEAN
    Nillable true
    Expressions Allowed true
    Storage configuration
    Access Type read-write
    Restart Required all-services
  • enlistment-trace Defines if WildFly/IronJacamar should record enlistment traces
    • Attribute Value
    Default Value false
    Type BOOLEAN
    Nillable true
    Expressions Allowed true
    Storage configuration
    Access Type read-write
    Restart Required no-services
  • 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 true
    Storage configuration
    Access Type read-write
    Restart Required all-services
  • exception-sorter-properties The exception sorter properties
    • Attribute Value
    Type OBJECT
    Nillable true
    Expressions Allowed true
    Storage configuration
    Access Type read-write
    Restart Required all-services
  • flush-strategy Specifies how the pool should be flush in case of an error.
    • Attribute Value
    Default Value FailingConnectionOnly
    Type STRING
    Nillable true
    Expressions Allowed true
    Storage configuration
    Access Type read-write
    Restart Required all-services
    Allowed Values FailingConnectionOnly
    InvalidIdleConnections
    IdleConnections
    Gracefully
    EntirePool
    AllInvalidIdleConnections
    AllIdleConnections
    AllGracefully
    AllConnections
  • 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 true
    Min 0
    Max 2,147,483,647
    Unit MINUTES
    Storage configuration
    Access Type read-write
    Restart Required all-services
  • initial-pool-size The initial-pool-size element indicates the initial number of connections a pool should hold.
    • Attribute Value
    Type INT
    Nillable true
    Expressions Allowed true
    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 true
    Storage configuration
    Access Type read-write
    Restart Required all-services
  • jndi-name Specifies the JNDI name for the datasource
    • Attribute Value
    Type STRING
    Nillable false
    Expressions Allowed true
    Storage configuration
    Access Type read-write
    Restart Required all-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 true
    Storage configuration
    Access Type read-write
    Restart Required all-services
  • mcp Defines the ManagedConnectionPool implementation, f.ex. org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool
    • Attribute Value
    Default Value org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreConcurrentLinkedDequeManagedConnectionPool
    Type STRING
    Nillable true
    Expressions Allowed true
    Storage configuration
    Access Type read-write
    Restart Required all-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 true
    Storage configuration
    Access Type read-write
    Restart Required all-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 true
    Storage configuration
    Access Type read-write
    Restart Required all-services
  • no-recovery Specifies if the connection pool should be excluded from recovery
    • Attribute Value
    Type BOOLEAN
    Nillable true
    Expressions Allowed true
    Storage configuration
    Access Type read-write
    Restart Required all-services
  • no-tx-separate-pool Oracle does not like XA connections getting used both inside and outside a Jakarta Transactions 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 true
    Storage configuration
    Access Type read-write
    Restart Required all-services
  • pad-xid Should the Xid be padded
    • Attribute Value
    Default Value false
    Type BOOLEAN
    Nillable true
    Expressions Allowed true
    Storage configuration
    Access Type read-write
    Restart Required all-services
  • password Specifies the password used when creating a new connection
    • Attribute Value
    Type STRING
    Nillable true
    Expressions Allowed true
    Storage configuration
    Access Type read-write
    Restart Required all-services
  • pool-fair Defines if pool use should be fair
    • Attribute Value
    Default Value true
    Type BOOLEAN
    Nillable true
    Expressions Allowed true
    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 true
    Storage configuration
    Access Type read-write
    Restart Required all-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 true
    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 true
    Storage configuration
    Access Type read-write
    Restart Required all-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 true
    Storage configuration
    Access Type read-write
    Restart Required all-services
  • reauth-plugin-class-name The fully qualified class name of the reauthentication plugin implementation
    • Attribute Value
    Type STRING
    Nillable true
    Expressions Allowed true
    Storage configuration
    Access Type read-write
    Restart Required all-services
  • reauth-plugin-properties The properties for the reauthentication plugin
    • Attribute Value
    Type OBJECT
    Nillable true
    Expressions Allowed true
    Storage configuration
    Access Type read-write
    Restart Required all-services
  • recovery-authentication-context The Elytron authentication context which defines the javax.security.auth.Subject that is used to distinguish connections in the pool.
    • Attribute Value
    Capability reference
    Type STRING
    Nillable true
    Expressions Allowed false
    Storage configuration
    Access Type read-write
    Restart Required all-services
  • recovery-credential-reference Credential (from Credential Store) to authenticate on data source
    • Attribute Value
    Type OBJECT
    Nillable true
    Expressions Allowed false
    Storage configuration
    Access Type read-write
    Restart Required all-services
  • recovery-elytron-enabled Enables Elytron security for handling authentication of connections for recovery. The Elytron authentication-context to be used will be current context if no context is specified (see authentication-context).
    • Attribute Value
    Default Value false
    Type BOOLEAN
    Nillable true
    Expressions Allowed true
    Storage configuration
    Access Type read-write
    Restart Required all-services
  • recovery-password The password used for recovery
    • Attribute Value
    Type STRING
    Nillable true
    Expressions Allowed true
    Storage configuration
    Access Type read-write
    Restart Required all-services
  • recovery-plugin-class-name The fully qualified class name of the recovery plugin implementation
    • Attribute Value
    Type STRING
    Nillable true
    Expressions Allowed true
    Storage configuration
    Access Type read-write
    Restart Required all-services
  • recovery-plugin-properties The properties for the recovery plugin
    • Attribute Value
    Type OBJECT
    Nillable true
    Expressions Allowed true
    Storage configuration
    Access Type read-write
    Restart Required all-services
  • recovery-security-domain The security domain used for recovery
    • Attribute Value
    Type STRING
    Nillable true
    Expressions Allowed true
    Storage configuration
    Access Type read-write
    Restart Required all-services
  • recovery-username The user name used for recovery
    • Attribute Value
    Type STRING
    Nillable true
    Expressions Allowed true
    Storage configuration
    Access Type read-write
    Restart Required all-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 true
    Storage configuration
    Access Type read-write
    Restart Required all-services
  • security-domain Specifies the PicketBox 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 true
    Storage configuration
    Access Type read-write
    Restart Required all-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 true
    Storage configuration
    Access Type read-write
    Restart Required all-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 true
    Storage configuration
    Access Type read-write
    Restart Required all-services
  • spy Enable spying of SQL statements
    • Attribute Value
    Default Value false
    Type BOOLEAN
    Nillable true
    Expressions Allowed true
    Storage configuration
    Access Type read-write
    Restart Required all-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 true
    Storage configuration
    Access Type read-write
    Restart Required all-services
  • stale-connection-checker-properties The stale connection checker properties
    • Attribute Value
    Type OBJECT
    Nillable true
    Expressions Allowed true
    Storage configuration
    Access Type read-write
    Restart Required all-services
  • statistics-enabled Define whether runtime statistics are enabled or not.
    • Attribute Value
    Default Value false
    Type BOOLEAN
    Nillable true
    Expressions Allowed true
    Storage configuration
    Access Type read-write
    Restart Required all-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 true
    Storage configuration
    Access Type read-write
    Restart Required all-services
  • tracking Defines if IronJacamar should track connection handles across transaction boundaries
    • Attribute Value
    Default Value false
    Type BOOLEAN
    Nillable true
    Expressions Allowed true
    Storage configuration
    Access Type read-write
    Restart Required all-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. Different values are used to set customLevel using TransactionIsolation#customLevel.
    • Attribute Value
    Type STRING
    Nillable true
    Expressions Allowed true
    Storage configuration
    Access Type read-write
    Restart Required all-services
  • url-delimiter Specifies the delimiter for URLs in connection-url for HA datasources
    • Attribute Value
    Type STRING
    Nillable true
    Expressions Allowed true
    Storage configuration
    Access Type read-write
    Restart Required all-services
  • url-property Specifies the property for the URL property in the xa-datasource-property values
    • Attribute Value
    Type STRING
    Nillable true
    Expressions Allowed true
    Storage configuration
    Access Type read-write
    Restart Required all-services
  • url-selector-strategy-class-name A class that implements org.jboss.jca.adapters.jdbc.URLSelectorStrategy
    • Attribute Value
    Type STRING
    Nillable true
    Expressions Allowed true
    Storage configuration
    Access Type read-write
    Restart Required all-services
  • use-ccm Enable the use of a cached connection manager
    • Attribute Value
    Default Value true
    Type BOOLEAN
    Nillable true
    Expressions Allowed true
    Storage configuration
    Access Type read-write
    Restart Required all-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 true
    Storage configuration
    Access Type read-write
    Restart Required all-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 true
    Storage configuration
    Access Type read-write
    Restart Required all-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 true
    Storage configuration
    Access Type read-write
    Restart Required all-services
  • user-name Specify the user name used when creating a new connection
    • Attribute Value
    Type STRING
    Nillable true
    Expressions Allowed true
    Storage configuration
    Access Type read-write
    Restart Required all-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 true
    Storage configuration
    Access Type read-write
    Restart Required all-services
  • valid-connection-checker-properties The valid connection checker properties
    • Attribute Value
    Type OBJECT
    Nillable true
    Expressions Allowed true
    Storage configuration
    Access Type read-write
    Restart Required all-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
    Type BOOLEAN
    Nillable true
    Expressions Allowed true
    Storage configuration
    Access Type read-write
    Restart Required all-services
  • wrap-xa-resource Should the XAResource instances be wrapped in an org.jboss.tm.XAResourceWrapper instance
    • Attribute Value
    Default Value true
    Type BOOLEAN
    Nillable true
    Expressions Allowed true
    Storage configuration
    Access Type read-write
    Restart Required all-services
  • xa-datasource-class The fully qualified name of the javax.sql.XADataSource implementation
    • Attribute Value
    Type STRING
    Nillable true
    Expressions Allowed true
    Storage configuration
    Access Type read-write
    Restart Required all-services
  • xa-resource-timeout The value is passed to XAResource.setTransactionTimeout(), in seconds. Default is zero
    • Attribute Value
    Type INT
    Nillable true
    Expressions Allowed true
    Storage configuration
    Access Type read-write
    Restart Required all-services

Operations (10)

  • add Add a new XA data-source
    Request Parameter Type Required Expressions Allowed Default value Description
    allocation-retry INT false true 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 true The allocation retry wait millis element specifies the amount of time, in milliseconds, to wait between retrying to allocate a connection
    allow-multiple-users BOOLEAN false true false Specifies if multiple users will access the datasource through the getConnection(user, password) method and hence if the internal pool type should account for that
    authentication-context STRING false false The Elytron authentication context which defines the javax.security.auth.Subject that is used to distinguish connections in the pool.
    background-validation BOOLEAN false true An element to specify that connections should be validated on a background thread versus being validated prior to use.
    background-validation-millis LONG false true The background-validation-millis element specifies the amount of time, in milliseconds, that background validation will run.
    blocking-timeout-wait-millis LONG false true 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
    capacity-decrementer-class STRING false true Class defining the policy for decrementing connections in the pool
    capacity-decrementer-properties OBJECT false true Properties to inject in class defining the policy for decrementing connections in the pool
    capacity-incrementer-class STRING false true Class defining the policy for incrementing connections in the pool
    capacity-incrementer-properties OBJECT false true Properties to inject in class defining the policy for incrementing connections in the pool
    check-valid-connection-sql STRING false true Specify an SQL statement to check validity of a pool connection. This may be called when managed connection is obtained from the pool
    connectable BOOLEAN false true false Enable the use of CMR for this datasource. This feature means that a local resource can reliably participate in an XA transaction.
    connection-listener-class STRING false true Speciefies class name extending org.jboss.jca.adapters.jdbc.spi.listener.ConnectionListener that provides a possible to listen for connection activation and passivation in order to perform actions before the connection is returned to the application or returned to the pool.
    connection-listener-property OBJECT false true Properties to be injected in class specified in connection-listener-class
    credential-reference OBJECT false false Credential (from Credential Store) to authenticate on data source
    driver-name STRING true true 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
    elytron-enabled BOOLEAN false true false Enables Elytron security for handling authentication of connections for recovery. The Elytron authentication-context to be used will be current context if no context is specified (see authentication-context).
    enabled BOOLEAN false true true Specifies if the datasource should be enabled. Note this attribute will not be supported runtime in next versions.
    enlistment-trace BOOLEAN false true false Defines if WildFly/IronJacamar should record enlistment traces
    exception-sorter-class-name STRING false true 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 true The exception sorter properties
    flush-strategy STRING false true FailingConnectionOnly Specifies how the pool should be flush in case of an error.
    idle-timeout-minutes LONG false true 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.
    initial-pool-size INT false true The initial-pool-size element indicates the initial number of connections a pool should hold.
    interleaving BOOLEAN false true false An element to enable interleaving for XA connections
    jndi-name STRING true true Specifies the JNDI name for the datasource
    max-pool-size INT false true 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
    mcp STRING false true org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreConcurrentLinkedDequeManagedConnectionPool Defines the ManagedConnectionPool implementation, f.ex. org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool
    min-pool-size INT false true 0 The min-pool-size element specifies the minimum number of connections for a pool
    new-connection-sql STRING false true Specifies an SQL statement to execute whenever a connection is added to the connection pool
    no-recovery BOOLEAN false true Specifies if the connection pool should be excluded from recovery
    no-tx-separate-pool BOOLEAN false true false Oracle does not like XA connections getting used both inside and outside a Jakarta Transactions transaction. To workaround the problem you can create separate sub-pools for the different contexts
    pad-xid BOOLEAN false true false Should the Xid be padded
    password STRING false true Specifies the password used when creating a new connection
    pool-fair BOOLEAN false true true Defines if pool use should be fair
    pool-prefill BOOLEAN false true 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 true false Specifies if the min-pool-size should be considered strictly
    prepared-statements-cache-size LONG false true The number of prepared statements per connection in an LRU cache
    query-timeout LONG false true Any configured query timeout in seconds. If not provided no timeout will be set
    reauth-plugin-class-name STRING false true The fully qualified class name of the reauthentication plugin implementation
    reauth-plugin-properties OBJECT false true The properties for the reauthentication plugin
    recovery-authentication-context STRING false false The Elytron authentication context which defines the javax.security.auth.Subject that is used to distinguish connections in the pool.
    recovery-credential-reference OBJECT false false Credential (from Credential Store) to authenticate on data source
    recovery-elytron-enabled BOOLEAN false true false Enables Elytron security for handling authentication of connections for recovery. The Elytron authentication-context to be used will be current context if no context is specified (see authentication-context).
    recovery-password STRING false true The password used for recovery
    recovery-plugin-class-name STRING false true The fully qualified class name of the recovery plugin implementation
    recovery-plugin-properties OBJECT false true The properties for the recovery plugin
    recovery-security-domain STRING false true The security domain used for recovery
    recovery-username STRING false true The user name used for recovery
    same-rm-override BOOLEAN false true The is-same-rm-override element allows one to unconditionally set whether the javax.transaction.xa.XAResource.isSameRM(XAResource) returns true or false
    security-domain STRING false true Specifies the PicketBox security domain which defines the javax.security.auth.Subject that are used to distinguish connections in the pool
    set-tx-query-timeout BOOLEAN false true 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
    share-prepared-statements BOOLEAN false true false Whether to share prepared statements, i.e. whether asking for same statement twice without closing uses the same underlying prepared statement
    spy BOOLEAN false true false Enable spying of SQL statements
    stale-connection-checker-class-name STRING false true 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 true The stale connection checker properties
    statistics-enabled BOOLEAN false true false Define whether runtime statistics are enabled or not.
    track-statements STRING false true 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
    tracking BOOLEAN false true false Defines if IronJacamar should track connection handles across transaction boundaries
    transaction-isolation STRING false true 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. Different values are used to set customLevel using TransactionIsolation#customLevel.
    url-delimiter STRING false true Specifies the delimiter for URLs in connection-url for HA datasources
    url-property STRING false true Specifies the property for the URL property in the xa-datasource-property values
    url-selector-strategy-class-name STRING false true A class that implements org.jboss.jca.adapters.jdbc.URLSelectorStrategy
    use-ccm BOOLEAN false true true Enable the use of a cached connection manager
    use-fast-fail BOOLEAN false true 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)
    use-java-context BOOLEAN false true true Setting this to false will bind the datasource into global JNDI
    use-try-lock LONG false true Any configured timeout for internal locks on the resource adapter objects in seconds
    user-name STRING false true Specify the user name used when creating a new connection
    valid-connection-checker-class-name STRING false true 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 true The valid connection checker properties
    validate-on-match BOOLEAN false true 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
    wrap-xa-resource BOOLEAN false true true Should the XAResource instances be wrapped in an org.jboss.tm.XAResourceWrapper instance
    xa-datasource-class STRING false true The fully qualified name of the javax.sql.XADataSource implementation
    xa-resource-timeout INT false true The value is passed to XAResource.setTransactionTimeout(), in seconds. Default is zero
  • disable Disable the data-source. Note this operation will not be supported runtime in next versions.
    Deprecated Since 3.0.0
    Disable the data-source. Note this operation will not be supported runtime in next versions.
  • dump-queued-threads-in-pool Dump queued threads in the pool
  • enable Enable the data-source. Note this operation will not be supported runtime in next versions.
    Deprecated Since 3.0.0
    Enable the data-source. Note this operation will not be supported runtime in next versions.
  • flush-all-connection-in-pool Flushes all connections in the pool
  • flush-gracefully-connection-in-pool Flushes all connections gracefully in the pool
  • flush-idle-connection-in-pool Flushes all idle connections in the pool
  • flush-invalid-connection-in-pool Flushes all invalid connections in the pool
  • remove Remove the XA data-source
  • test-connection-in-pool Test if a connection can be obtained
    Request Parameter Type Required Expressions Allowed Default value Description
    user-name STRING false true User name to authenticate connection
    password STRING false true Password to authenticate connection