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

[Tom Jenkinson (JIRA)]

    [ https://issues.jboss.org/browse/WFLY-5426?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13116001#comment-13116001 ] 

Tom Jenkinson commented on WFLY-5426:
-------------------------------------

PR was merged - can this be closed?

> 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: Blocker
>             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)