Background validation and connection checkers are not generated in standalone-openshift.xml in JBoss EAP over Openshift
Issue
It is creating datasource by putting all datasource configuration into an Openshift secret and make use of the environment file. But the background validation and connection checkers was not generated.
DATASOURCES=SAMPLEAPP
SAMPLEAPP_DATABASE={database}
SAMPLEAPP_JNDI={jndi}
SAMPLEAPP_DRIVER={driver}
SAMPLEAPP_USERNAME=redhat
SAMPLEAPP_PASSWORD=redhat123!
SAMPLEAPP_TX_ISOLATION=TRANSACTION_READ_UNCOMMITTED
SAMPLEAPP_JTA=true
SAMPLEAPP_URL=jdbc:sqlserver://{host}:{port};databaseName={databaseName}
SAMPLEAPP_NONXA=true
SAMPLEAPP_BACKGROUND_VALIDATION=true
SAMPLEAPP_BACKGROUND_VALIDATION_MILLIS=10000
SAMPLEAPP_CONNECTION_CHECKER={class_checker}
SAMPLEAPP_MIN_POOL_SIZE=2
SAMPLEAPP_MAX_POOL_SIZE=25
The generated datasource:
<datasource jta="true" jndi-name="{jndi}" pool-name="sampleapp-SAMPLEAPP" enabled="true" use-java-context="true" statistics-enabled="${wildfly.datasources.statistics-enabled:${wildfly.statistics-enabled:false}}">
<connection-url>jdbc:sqlserver://{host}:{port};databaseName={databaseName}</connection-url>
<driver>{driver}</driver>
<pool>
<min-pool-size>2</min-pool-size>
<max-pool-size>25</max-pool-size>
</pool>
<security>
<user-name>redhat</user-name>
<password>redhat123!</password>
</security>
</datasource>
Environment
- Red Hat JBoss Enterprise Application Platform (EAP)
- 7
- Openshift
- 3.11
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.