Attribute | Value |
---|---|
Type | INT |
Nillable | true |
Expressions Allowed | true |
Storage | configuration |
Access Type | read-write |
Restart Required | all-services |
Attribute | Value |
---|---|
Type | LONG |
Nillable | true |
Expressions Allowed | true |
Storage | configuration |
Access Type | read-write |
Restart Required | all-services |
Attribute | Value |
---|---|
Default Value | false |
Type | BOOLEAN |
Nillable | true |
Expressions Allowed | true |
Storage | configuration |
Access Type | read-write |
Restart Required | all-services |
Attribute | Value |
---|---|
Capability reference | |
Type | STRING |
Nillable | true |
Expressions Allowed | false |
Storage | configuration |
Access Type | read-write |
Restart Required | all-services |
Attribute | Value |
---|---|
Type | BOOLEAN |
Nillable | true |
Expressions Allowed | true |
Storage | configuration |
Access Type | read-write |
Restart Required | all-services |
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 |
Attribute | Value |
---|---|
Type | LONG |
Nillable | true |
Expressions Allowed | true |
Unit | MILLISECONDS |
Storage | configuration |
Access Type | read-write |
Restart Required | no-services |
Attribute | Value |
---|---|
Type | STRING |
Nillable | true |
Expressions Allowed | true |
Storage | configuration |
Access Type | read-write |
Restart Required | all-services |
Attribute | Value |
---|---|
Type | OBJECT |
Nillable | true |
Expressions Allowed | true |
Storage | configuration |
Access Type | read-write |
Restart Required | all-services |
Attribute | Value |
---|---|
Type | STRING |
Nillable | true |
Expressions Allowed | true |
Storage | configuration |
Access Type | read-write |
Restart Required | all-services |
Attribute | Value |
---|---|
Type | OBJECT |
Nillable | true |
Expressions Allowed | true |
Storage | configuration |
Access Type | read-write |
Restart Required | all-services |
Attribute | Value |
---|---|
Type | STRING |
Nillable | true |
Expressions Allowed | true |
Storage | configuration |
Access Type | read-write |
Restart Required | all-services |
Attribute | Value |
---|---|
Default Value | false |
Type | BOOLEAN |
Nillable | true |
Expressions Allowed | true |
Storage | configuration |
Access Type | read-write |
Restart Required | all-services |
Attribute | Value |
---|---|
Type | STRING |
Nillable | true |
Expressions Allowed | true |
Storage | configuration |
Access Type | read-write |
Restart Required | all-services |
Attribute | Value |
---|---|
Type | OBJECT |
Nillable | true |
Expressions Allowed | true |
Storage | configuration |
Access Type | read-write |
Restart Required | all-services |
Attribute | Value |
---|---|
Type | STRING |
Nillable | true |
Expressions Allowed | true |
Storage | configuration |
Access Type | read-write |
Restart Required | all-services |
Attribute | Value |
---|---|
Type | OBJECT |
Nillable | true |
Expressions Allowed | false |
Storage | configuration |
Access Type | read-write |
Restart Required | all-services |
Attribute | Value |
---|---|
Type | STRING |
Nillable | true |
Expressions Allowed | true |
Storage | configuration |
Access Type | read-write |
Restart Required | all-services |
Attribute | Value |
---|---|
Type | STRING |
Nillable | true |
Expressions Allowed | true |
Storage | configuration |
Access Type | read-write |
Restart Required | all-services |
Attribute | Value |
---|---|
Type | STRING |
Nillable | false |
Expressions Allowed | true |
Storage | configuration |
Access Type | read-write |
Restart Required | all-services |
Attribute | Value |
---|---|
Default Value | false |
Type | BOOLEAN |
Nillable | true |
Expressions Allowed | true |
Storage | configuration |
Access Type | read-write |
Restart Required | all-services |
Attribute | Value |
---|---|
Default Value | true |
Type | BOOLEAN |
Nillable | true |
Expressions Allowed | true |
Storage | configuration |
Access Type | read-write |
Restart Required | all-services |
Attribute | Value |
---|---|
Default Value | false |
Type | BOOLEAN |
Nillable | true |
Expressions Allowed | true |
Storage | configuration |
Access Type | read-write |
Restart Required | no-services |
Attribute | Value |
---|---|
Type | STRING |
Nillable | true |
Expressions Allowed | true |
Storage | configuration |
Access Type | read-write |
Restart Required | all-services |
Attribute | Value |
---|---|
Type | STRING |
Nillable | true |
Expressions Allowed | true |
Storage | configuration |
Access Type | read-write |
Restart Required | all-services |
Attribute | Value |
---|---|
Type | OBJECT |
Nillable | true |
Expressions Allowed | true |
Storage | configuration |
Access Type | read-write |
Restart Required | all-services |
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 |
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 |
Attribute | Value |
---|---|
Type | INT |
Nillable | true |
Expressions Allowed | true |
Storage | configuration |
Access Type | read-write |
Restart Required | no-services |
Attribute | Value |
---|---|
Type | STRING |
Nillable | false |
Expressions Allowed | true |
Storage | configuration |
Access Type | read-write |
Restart Required | all-services |
Attribute | Value |
---|---|
Default Value | true |
Type | BOOLEAN |
Nillable | true |
Expressions Allowed | true |
Storage | configuration |
Access Type | read-write |
Restart Required | all-services |
Attribute | Value |
---|---|
Default Value | 20 |
Type | INT |
Nillable | true |
Expressions Allowed | true |
Storage | configuration |
Access Type | read-write |
Restart Required | all-services |
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 |
Attribute | Value |
---|---|
Default Value | 0 |
Type | INT |
Nillable | true |
Expressions Allowed | true |
Storage | configuration |
Access Type | read-write |
Restart Required | all-services |
Attribute | Value |
---|---|
Type | STRING |
Nillable | true |
Expressions Allowed | true |
Storage | configuration |
Access Type | read-write |
Restart Required | all-services |
Attribute | Value |
---|---|
Type | STRING |
Nillable | true |
Expressions Allowed | true |
Storage | configuration |
Access Type | read-write |
Restart Required | all-services |
Attribute | Value |
---|---|
Default Value | true |
Type | BOOLEAN |
Nillable | true |
Expressions Allowed | true |
Storage | configuration |
Access Type | read-write |
Restart Required | no-services |
Attribute | Value |
---|---|
Default Value | false |
Type | BOOLEAN |
Nillable | true |
Expressions Allowed | true |
Storage | configuration |
Access Type | read-write |
Restart Required | all-services |
Attribute | Value |
---|---|
Default Value | false |
Type | BOOLEAN |
Nillable | true |
Expressions Allowed | true |
Storage | configuration |
Access Type | read-write |
Restart Required | no-services |
Attribute | Value |
---|---|
Type | LONG |
Nillable | true |
Expressions Allowed | true |
Storage | configuration |
Access Type | read-write |
Restart Required | all-services |
Attribute | Value |
---|---|
Type | LONG |
Nillable | true |
Expressions Allowed | true |
Storage | configuration |
Access Type | read-write |
Restart Required | all-services |
Attribute | Value |
---|---|
Type | STRING |
Nillable | true |
Expressions Allowed | true |
Storage | configuration |
Access Type | read-write |
Restart Required | all-services |
Attribute | Value |
---|---|
Type | OBJECT |
Nillable | true |
Expressions Allowed | true |
Storage | configuration |
Access Type | read-write |
Restart Required | all-services |
Attribute | Value |
---|---|
Type | STRING |
Nillable | true |
Expressions Allowed | true |
Storage | configuration |
Access Type | read-write |
Restart Required | all-services |
Attribute | Value |
---|---|
Default Value | false |
Type | BOOLEAN |
Nillable | true |
Expressions Allowed | true |
Storage | configuration |
Access Type | read-write |
Restart Required | all-services |
Attribute | Value |
---|---|
Default Value | false |
Type | BOOLEAN |
Nillable | true |
Expressions Allowed | true |
Storage | configuration |
Access Type | read-write |
Restart Required | all-services |
Attribute | Value |
---|---|
Type | STRING |
Nillable | true |
Expressions Allowed | true |
Storage | configuration |
Access Type | read-write |
Restart Required | all-services |
Attribute | Value |
---|---|
Type | STRING |
Nillable | true |
Expressions Allowed | true |
Storage | configuration |
Access Type | read-write |
Restart Required | all-services |
Attribute | Value |
---|---|
Type | OBJECT |
Nillable | true |
Expressions Allowed | true |
Storage | configuration |
Access Type | read-write |
Restart Required | all-services |
Attribute | Value |
---|---|
Default Value | false |
Type | BOOLEAN |
Nillable | true |
Expressions Allowed | true |
Storage | configuration |
Access Type | read-write |
Restart Required | all-services |
Attribute | Value |
---|---|
Default Value | NOWARN |
Type | STRING |
Nillable | true |
Expressions Allowed | true |
Storage | configuration |
Access Type | read-write |
Restart Required | all-services |
Attribute | Value |
---|---|
Default Value | false |
Type | BOOLEAN |
Nillable | true |
Expressions Allowed | true |
Storage | configuration |
Access Type | read-write |
Restart Required | all-services |
Attribute | Value |
---|---|
Type | STRING |
Nillable | true |
Expressions Allowed | true |
Storage | configuration |
Access Type | read-write |
Restart Required | all-services |
Attribute | Value |
---|---|
Type | STRING |
Nillable | true |
Expressions Allowed | true |
Storage | configuration |
Access Type | read-write |
Restart Required | all-services |
Attribute | Value |
---|---|
Type | STRING |
Nillable | true |
Expressions Allowed | true |
Storage | configuration |
Access Type | read-write |
Restart Required | all-services |
Attribute | Value |
---|---|
Default Value | true |
Type | BOOLEAN |
Nillable | true |
Expressions Allowed | true |
Storage | configuration |
Access Type | read-write |
Restart Required | all-services |
Attribute | Value |
---|---|
Default Value | false |
Type | BOOLEAN |
Nillable | true |
Expressions Allowed | true |
Storage | configuration |
Access Type | read-write |
Restart Required | all-services |
Attribute | Value |
---|---|
Default Value | true |
Type | BOOLEAN |
Nillable | true |
Expressions Allowed | true |
Storage | configuration |
Access Type | read-write |
Restart Required | all-services |
Attribute | Value |
---|---|
Type | LONG |
Nillable | true |
Expressions Allowed | true |
Storage | configuration |
Access Type | read-write |
Restart Required | all-services |
Attribute | Value |
---|---|
Type | STRING |
Nillable | true |
Expressions Allowed | true |
Storage | configuration |
Access Type | read-write |
Restart Required | all-services |
Attribute | Value |
---|---|
Type | STRING |
Nillable | true |
Expressions Allowed | true |
Storage | configuration |
Access Type | read-write |
Restart Required | all-services |
Attribute | Value |
---|---|
Type | STRING |
Nillable | true |
Expressions Allowed | true |
Storage | configuration |
Access Type | read-write |
Restart Required | all-services |
Attribute | Value |
---|---|
Type | OBJECT |
Nillable | true |
Expressions Allowed | true |
Storage | configuration |
Access Type | read-write |
Restart Required | all-services |
Attribute | Value |
---|---|
Type | BOOLEAN |
Nillable | true |
Expressions Allowed | true |
Storage | configuration |
Access Type | read-write |
Restart Required | all-services |
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. Changing this value can be done only on disabled datasource, requires a server restart otherwise. | |
background-validation-millis | LONG | false | true | 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 | |
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 be injected 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 be injected 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. 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 specidied in connection-listener-class | |
connection-url | STRING | false | true | The JDBC driver connection URL | |
credential-reference | OBJECT | false | false | Credential (from Credential Store) to authenticate on data source | |
datasource-class | STRING | false | true | The fully qualified name of the JDBC datasource class | |
driver-class | STRING | false | true | The fully qualified name of the JDBC driver class | |
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. 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-module | STRING | false | true | The name of the module which makes the implementation of org.jboss.jca.adapters.jdbc.ExceptionSorter available | |
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. | |
jndi-name | STRING | true | true | Specifies the JNDI name for the datasource | |
jta | BOOLEAN | false | true | true | Enable Jakarta Transactions integration |
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 | |
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 | |
security-domain | STRING | false | true | Specifies the PicketBox security domain which defines the PicketBox 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-module | STRING | false | true | The name of the module which makes the implementation of org.jboss.jca.adapters.jdbc.StaleConnectionChecker available | |
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-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-module | STRING | false | true | The name of the module which makes the implementation of org.jboss.jca.adapters.jdbc.ValidConnectionChecker available | |
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 |
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 |