Database
Reconnecting to the database automatically
If the database connection is lost for a long time, the connection is restored by default. This is achieved by configuring the database connection to do an automatic retry by including the following parameters to the standalone-full.xml.
Parameter | Explanation | ||
|---|---|---|---|
check-valid-connection-sql Oracle | This query is executed on the database to validate that the connection still works. select 1 from dual MSSQL: select 1 | ||
background-validation | Validate the database connections in the background (when they are idle), default is true. | ||
background-validation-millis | Validates the connection every X milliseconds. (Default is 10000) | ||
query-timeout | The maximum amount of seconds that a query can run. By default this is 50 minutes (3000 seconds). | ||
set-tx-query-timeout | The query-timeout is applied to the whole transactions instead of on individual queries. The default is true. | ||
idle-timeout-minutes | Indicates the maximum time in minutes that a connection may be idle before it is closed. The default is 15 minutes, setting this to 0 disables it. | ||
blocking-timeout-millis | The amount of milliseconds to wait before a connection from the connection pool becomes available. If no new connection is found in X milliseconds (default is 5000) an exception is thrown.
|
Read using CLI
To know what all module options are available under PlanonDS
/subsystem=datasources/data-source=PlanonDS/:read-resource(recursive=false)
To read a particular attribute
/subsystem=datasources/data-source=PlanonDS/:read-attribute(name=blocking-timeout-wait-millis)
Write / modify the value of a particular attribute
/subsystem=datasources/data-source=PlanonDS/:write-attribute(name=background-validation-millis,
value=20000)
value=20000)