Uploaded image for project: 'Red Hat Process Automation Manager'
  1. Red Hat Process Automation Manager
  2. RHPAM-2226

Validation subelement is missing for datasources

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Critical Critical
    • 7.4.0.GA
    • 7.4.0.GA
    • Cloud

    • Observed on OpenShift templates rhpam74-kieserver-mysql.yaml and rhpam74-kieserver-postgresql.yaml , could be reproduced also in other environments

    • 2019 Week 26-28

      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## -->

              dward-se-jboss David Ward
              ksuta Karel Suta
              Karel Suta Karel Suta
              Karel Suta Karel Suta
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Created:
                Updated:
                Resolved: