Details
-
Bug
-
Resolution: Done
-
Critical
-
7.4.0.GA
-
Observed on OpenShift templates rhpam74-kieserver-mysql.yaml and rhpam74-kieserver-postgresql.yaml , could be reproduced also in other environments
-
CR1
-
CR2
-
https://github.com/jboss-container-images/rhpam-7-openshift-image/pull/319, https://github.com/jboss-container-images/rhpam-7-openshift-image/pull/320, https://github.com/ansibleplaybookbundle/rhpam-apb/pull/79, https://github.com/ansibleplaybookbundle/rhpam-apb/pull/80, https://github.com/kiegroup/kie-cloud-operator/pull/214, https://github.com/kiegroup/kie-cloud-operator/pull/215
-
-
2019 Week 26-28
Description
When user deploys template rhpam74-kieserver-postgresql.yaml then Kie server datasources don't contain validation subelement, where connection checkers and exception sorters are defined.
The validation subelement is available on 7.3 templates, for example see deployment of rhpam73-kieserver-postgresql.yaml
7.4 datasources:
<datasource jta="true" jndi-name="java:jboss/datasources/ExampleDS" pool-name="ExampleDS" enabled="true" use-java-context="true" statistics-enabled="${wildfly.datasources.statistics-enabled:${wildfly.statistics-enabled:false}}"> <connection-url>jdbc:h2:mem:test;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=FALSE</connection-url> <driver>h2</driver> <security> <user-name>sa</user-name> <password>sa</password> </security> </datasource><xa-datasource jndi-name="java:/jboss/datasources/rhpam_EJBTimer" pool-name="ejb_timer-EJB_TIMER" enabled="true" use-java-context="true" statistics-enabled="${wildfly.datasources.statistics-enabled:${wildfly.statistics-enabled:false}}"> <xa-datasource-property name="DatabaseName">rhpam7</xa-datasource-property> <xa-datasource-property name="PortNumber">5432</xa-datasource-property> <xa-datasource-property name="ServerName">myapp-postgresql</xa-datasource-property> <driver>postgresql</driver> <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation> <xa-pool> <min-pool-size>10</min-pool-size> <max-pool-size>10</max-pool-size> </xa-pool> <security> <user-name>rhpam</user-name> <password>hLDDEd6!</password> </security> </xa-datasource>
<datasource jta="true" jndi-name="java:/jboss/datasources/rhpam" pool-name="rhpam-RHPAM" enabled="true" use-java-context="true" statistics-enabled="${wildfly.datasources.statistics-enabled:${wildfly.statistics-enabled:false}}"> <connection-url>jdbc:postgresql://myapp-postgresql:5432/rhpam7</connection-url> <driver>postgresql</driver> <security> <user-name>rhpam</user-name> <password>hLDDEd6!</password> </security> </datasource>
7.3 datasources:
<datasource jta="true" jndi-name="java:jboss/datasources/ExampleDS" pool-name="ExampleDS" enabled="true" use-java-context="true"> <connection-url>jdbc:h2:mem:test;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=FALSE</connection-url> <driver>h2</driver> <security> <user-name>sa</user-name> <password>sa</password> </security> </datasource><xa-datasource jndi-name="java:/jboss/datasources/rhpam_EJBTimer" pool-name="ejb_timer-EJB_TIMER" enabled="true" use-java-context="true"> <xa-datasource-property name="DatabaseName">rhpam7</xa-datasource-property> <xa-datasource-property name="PortNumber">5432</xa-datasource-property> <xa-datasource-property name="ServerName">myapp-postgresql</xa-datasource-property> <driver>postgresql</driver> <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation> <xa-pool> <min-pool-size>10</min-pool-size> <max-pool-size>10</max-pool-size> </xa-pool> <security> <user-name>rhpam</user-name> <password>nMswmW0!</password> </security> <validation> <validate-on-match>true</validate-on-match> <background-validation>false</background-validation> <valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.postgres.PostgreSQLValidConnectionChecker"></valid-connection-checker> <exception-sorter class-name="org.jboss.jca.adapters.jdbc.extensions.postgres.PostgreSQLExceptionSorter"></exception-sorter> </validation> </xa-datasource> <datasource jta="true" jndi-name="java:/jboss/datasources/rhpam" pool-name="rhpam-RHPAM" enabled="true" use-java-context="true"> <connection-url>jdbc:postgresql://myapp-postgresql:5432/rhpam7</connection-url> <driver>postgresql</driver> <security> <user-name>rhpam</user-name> <password>nMswmW0!</password> </security> <validation> <validate-on-match>true</validate-on-match> <background-validation>false</background-validation> <valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.postgres.PostgreSQLValidConnectionChecker"></valid-connection-checker> <exception-sorter class-name="org.jboss.jca.adapters.jdbc.extensions.postgres.PostgreSQLExceptionSorter"></exception-sorter> </validation> </datasource> <!-- ##DATASOURCES## -->
