Uploaded image for project: 'Red Hat Fuse'
  1. Red Hat Fuse
  2. ENTESB-3430

jdbc:databases shows duplicated datasources (all with error status) when using xa transactions

XMLWordPrintable

    • % %
    • Hide

      FULL WAY with the XA transactions example:
      1. Clone the example on jboss-fuse-6.2 branch:

      git clone -b jboss-fuse-6.2 git@github.com:FuseByExample/esb-transactions.git

      2. Update versions in the root pom.xml (according to jboss-fuse-6.2.0.redhat-123). Change these properties:

              <jboss.fuse.bom.version>6.2.0.redhat-123</jboss.fuse.bom.version>
        <karaf.version>2.4.0.redhat-620123</karaf.version>
        <camel.version>2.15.1.redhat-620123</camel.version>
        <activemq.version>5.11.0.redhat-620123</activemq.version>

      3. Install it to the jboss-fuse-6.2.0.redhat-123 using README.md.

      4. Everything seems to be fine. But try to list datasource and their states using the jdbc feature:
      4a. Install the jdbc feature: features:install -v jdbc
      4b. List datasources: jdbc:datasources
      Output looks very confusing:

      JBossFuse:karaf@root> jdbc:datasources
      Name Product Version URL Status
      jdbc/transactionsdbxa Error
      jdbc/transactionsdb Error
      jdbc/transactionsdb Error
      jdbc/transactionsdbxa Error

      The datasources are duplicated and they are in an error status. The example works correctly including datastoring, but an administrator could not see true status of datasources.

      QUICK WAY:
      features:install -v jdbc
      features:install -v jndi
      jdbc:create -t h2 -url 'jdbc:h2:mem:testdb;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=FALSE' -u admin -p admin -i testdbDS
      (now jdbc:datasources output is OK)
      features:install -v connector
      (now jdbc:datasources output is bad)

      Show
      FULL WAY with the XA transactions example: 1. Clone the example on jboss-fuse-6.2 branch: git clone -b jboss-fuse-6.2 git@github.com:FuseByExample/esb-transactions.git 2. Update versions in the root pom.xml (according to jboss-fuse-6.2.0.redhat-123). Change these properties: <jboss.fuse.bom.version>6.2.0.redhat-123</jboss.fuse.bom.version> <karaf.version>2.4.0.redhat-620123</karaf.version> <camel.version>2.15.1.redhat-620123</camel.version> <activemq.version>5.11.0.redhat-620123</activemq.version> 3. Install it to the jboss-fuse-6.2.0.redhat-123 using README.md. 4. Everything seems to be fine. But try to list datasource and their states using the jdbc feature: 4a. Install the jdbc feature: features:install -v jdbc 4b. List datasources: jdbc:datasources Output looks very confusing: JBossFuse:karaf@root> jdbc:datasources Name Product Version URL Status jdbc/transactionsdbxa Error jdbc/transactionsdb Error jdbc/transactionsdb Error jdbc/transactionsdbxa Error The datasources are duplicated and they are in an error status. The example works correctly including datastoring, but an administrator could not see true status of datasources. QUICK WAY: features:install -v jdbc features:install -v jndi jdbc:create -t h2 -url 'jdbc:h2:mem:testdb;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=FALSE' -u admin -p admin -i testdbDS (now jdbc:datasources output is OK) features:install -v connector (now jdbc:datasources output is bad)

      I am trying an XA transactions with the camel on the Fuse-6.2 using this example:
      https://github.com/FuseByExample/esb-transactions/tree/jboss-fuse-6.2 (I suppose a correct branch for trying with the jboss-fuse-6.2 is the branch jboss-fuse-6.2).

      After I have installed this example into the Fuse, there is something wrong with datasources (jdbc:datasources shows them duplicated and with error status).

            ggrzybek Grzegorz Grzybek
            mswiech_jira Martin Swiech (Inactive)
            Martin Swiech Martin Swiech (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: