[jboss-jira] [JBoss JIRA] (WFLY-5426) Data sources other than h2 cannot be added to domain servers

[James Perkins (JIRA)]

James Perkins created WFLY-5426:
-----------------------------------

             Summary: Data sources other than h2 cannot be added to domain servers
                 Key: WFLY-5426
                 URL: https://issues.jboss.org/browse/WFLY-5426
             Project: WildFly
          Issue Type: Bug
          Components: JCA
    Affects Versions: 9.0.0.Final
            Reporter: James Perkins
            Assignee: Stefano Maestri
            Priority: Critical
             Fix For: 10.0.0.Final


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.
{code}
[domain at 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"
    }}
}
{code}

Attempting to add the data source results in the following error:
{code}
[domain at 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
        }}
    }}}}
}
{code}



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)