Uploaded image for project: 'JBoss Enterprise Application Platform'
  1. JBoss Enterprise Application Platform
  2. JBEAP-1203

Data sources other than h2 cannot be added to domain servers

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Blocker
    • 7.0.0.ER1
    • 7.0.0.DR11
    • JCA
    • None
    • Hide

      Deploy a postgres driver

      deploy ~/tmp/postgresql-9.4-1201.jdbc41.jar --server-groups=main-server-group

      Attempt to add a data source

      /profile=full/subsystem=datasources/data-source=test-pg:add(driver-name=postgresql-9.4-1201.jdbc41.jar, connection-url=jdbc:postgresql://localhost:test,user-name=user,password=password, jndi-name=java:jboss/datasources/test-pg)
      Show
      Deploy a postgres driver deploy ~/tmp/postgresql-9.4-1201.jdbc41.jar --server-groups=main-server-group Attempt to add a data source /profile=full/subsystem=datasources/data-source=test-pg:add(driver-name=postgresql-9.4-1201.jdbc41.jar, connection-url=jdbc:postgresql: //localhost:test,user-name=user,password=password, jndi-name=java:jboss/datasources/test-pg)

    Description

      This seems to work okay with the h2 driver, but adding a postgres driver add operations fail.

      The driver is deployed and is on the main-server-group which defaults to the full profile.

      [domain@localhost:9990 /] /server-group=main-server-group:read-children-resources(child-type=deployment,recursive=true,include-runtime=true)
{
    "outcome" => "success",
    "result" => {"postgresql-9.4-1201.jdbc41.jar" => {
        "enabled" => true,
        "name" => "postgresql-9.4-1201.jdbc41.jar",
        "runtime-name" => "postgresql-9.4-1201.jdbc41.jar"
    }}
}

      Attempting to add the data source results in the following error:

      [domain@localhost:9990 /] /profile=full/subsystem=datasources/data-source=test-pg:add(driver-name=postgresql-9.4-1201.jdbc41.jar, connection-url=jdbc:postgresql://localhost:test,user-name=user,password=password, jndi-name=java:jboss/datasources/test-pg)
{
    "outcome" => "failed",
    "result" => undefined,
    "failure-description" => {"WFLYDC0074: Operation failed or was rolled back on all servers. Server failures:" => {"server-group" => {"main-server-group" => {"host" => {"master" => {
        "server-one" => {"WFLYCTL0080: Failed services" => {"jboss.data-source.java:jboss/datasources/test-pg" => "org.jboss.msc.service.StartException in service jboss.data-source.java:jboss/datasources/test-pg: WFLYJCA0033: Error during the deployment of test-pg
    Caused by: org.jboss.msc.service.StartException in anonymous service: WFLYJCA0032: Unable to start the ds because it generated more than one cf"}},
        "server-two" => {"WFLYCTL0080: Failed services" => {"jboss.data-source.java:jboss/datasources/test-pg" => "org.jboss.msc.service.StartException in service jboss.data-source.java:jboss/datasources/test-pg: WFLYJCA0033: Error during the deployment of test-pg
    Caused by: org.jboss.msc.service.StartException in anonymous service: WFLYJCA0032: Unable to start the ds because it generated more than one cf"}}
    }}}}}},
    "rolled-back" => true,
    "server-groups" => {"main-server-group" => {"host" => {"master" => {
        "server-one" => {"response" => {
            "outcome" => "failed",
            "failure-description" => {"WFLYCTL0080: Failed services" => {"jboss.data-source.java:jboss/datasources/test-pg" => "org.jboss.msc.service.StartException in service jboss.data-source.java:jboss/datasources/test-pg: WFLYJCA0033: Error during the deployment of test-pg
    Caused by: org.jboss.msc.service.StartException in anonymous service: WFLYJCA0032: Unable to start the ds because it generated more than one cf"}},
            "rolled-back" => true
        }},
        "server-two" => {"response" => {
            "outcome" => "failed",
            "failure-description" => {"WFLYCTL0080: Failed services" => {"jboss.data-source.java:jboss/datasources/test-pg" => "org.jboss.msc.service.StartException in service jboss.data-source.java:jboss/datasources/test-pg: WFLYJCA0033: Error during the deployment of test-pg
    Caused by: org.jboss.msc.service.StartException in anonymous service: WFLYJCA0032: Unable to start the ds because it generated more than one cf"}},
            "rolled-back" => true
        }}
    }}}}
}

      Attachments

        Issue Links

          clones

          Bug - A problem that impairs or prevents the functions of the product. WFLY-5426 Data sources other than h2 cannot be added to domain servers

          • Blocker - To be worked above all other priorities. This term is chosen when the severity of the issue is very high, has no workaround, or the effort for the change is comparatively low. Issues that may be very publicly visible and could generate significant media attention may also drive a higher priority.
          • Closed
          is caused by

          Enhancement - An enhancement to or refactoring of existing functionality that is not configurable by an end user (typically a change made by an internal team that affects users) WFLY-3634 installed-drivers should show only drivers installed on current profile

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Closed

          Activity

            People

              smaestri@redhat.com Stefano Maestri
              msimka@redhat.com Martin Simka
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: