Uploaded image for project: 'KIE Cloud'
  1. KIE Cloud
  2. KIECLOUD-74

DB2 cannot be used as external DB for rhpam72-kieserver-externaldb.yaml

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Major Major
    • 7.3.0.GA
    • 7.2.0.GA
    • RHPAM
    • None

      When rhpam72-kieserver-externaldb.yaml is deployed against DB2 database then malformed datasource is created:

            <subsystem xmlns="urn:jboss:domain:bean-validation:1.0"/>
              <subsystem xmlns="urn:jboss:domain:datasources:5.0">
                  <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/ejb_timer" pool-name="ejb_timer-EJB_TIMER" enabled="true" use-java-context="true"> <xa-datasource-property name="DatabaseName">dballo</xa-datasource-property> <xa-datasource-property name="DriverType">4</xa-datasource-property><xa-datasource-property name="PortNumber">50000</xa-datasource-property> <xa-datasource-property name="ServerName">xxxxxxxx</xa-datasource-property> <driver>db2</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>dballo12</user-name> <password>dballo12</password> </security> </xa-datasource>
      <xa-datasource jndi-name="java:jboss/datasources/jbpmDS" pool-name="rhpam-RHPAM" enabled="true" use-java-context="true"> <driver>db2</driver> <security> <user-name>dballo12</user-name> <password>dballo12</password> </security> </xa-datasource>
      <!-- ##DATASOURCES## -->
                      <drivers>
                          <driver name="h2" module="com.h2database.h2">
                              <xa-datasource-class>org.h2.jdbcx.JdbcDataSource</xa-datasource-class>
                          </driver>
                          <driver name="mysql" module="com.mysql">
                              <xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class>
                          </driver>
                          <driver name="postgresql" module="org.postgresql">
                              <xa-datasource-class>org.postgresql.xa.PGXADataSource</xa-datasource-class>
                          </driver>
                           <driver name="db2" module="com.ibm"><xa-datasource-class>com.ibm.db2.jcc.DB2XADataSource</xa-datasource-class><driver-class>com.ibm.db2.jcc.DB2Driver</driver-class></driver><!-- ##DRIVERS## -->
                      </drivers>
                  </datasources>
              </subsystem>
      

      The issue is that there is no xa-datasource-property for jbpmDS:

      14:42:21,637 ERROR [org.jboss.as.controller.management-operation] (ServerService Thread Pool -- 42) WFLYCTL0013: Operation ("add") failed - address: ([
          ("subsystem" => "datasources"),
          ("xa-data-source" => "rhpam-RHPAM")
      ]) - failure description: "WFLYJCA0069: At least one xa-datasource-property is required for an xa-datasource"
      

              rhn-support-fspolti Filippe Spolti
              ksuta Karel Suta
              Karel Suta Karel Suta
              Karel Suta Karel Suta
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: