[jboss-jira] [JBoss JIRA] (WFLY-6015) Testing JDBC connection is causing it to be added

[Renann Prado (JIRA)]

     [ https://issues.jboss.org/browse/WFLY-6015?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Renann Prado updated WFLY-6015:
-------------------------------
    Steps to Reproduce: 
1 - Create a new datasource through web admin console
2 - When in final step, click to test the connection
3 - Even it being a *test* it seems that it tries to add the datasource, so if you try to test again you'll get:

Unexpected HTTP response: 500

{code:json}

Request
{
    "name" => "MySqlDS",
    "use-ccm" => false,
    "pool-name" => "MySqlDS_Pool",
    "connection-url" => "jdbc:mariadb://192.168.0.119:3306",
    "jta" => false,
    "driver-class" => "org.mariadb.jdbc.Driver",
    "driver-name" => "mariadb-java-client-1.3.4.jar",
    "valid-connection-checker-class-name" => "org.jboss.jca.adapters.jdbc.extensions.mysql.MySQLValidConnectionChecker",
    "background-validation" => true,
    "exception-sorter-class-name" => "org.jboss.jca.adapters.jdbc.extensions.mysql.MySQLExceptionSorter",
    "jndi-name" => "java:/MySqlDS",
    "user-name" => "root",
    "password" => "123",
    "enabled" => true,
    "operation" => "add",
    "address" => [
        ("subsystem" => "datasources"),
        ("data-source" => "MySqlDS")
    ]
}

Response

Internal Server Error
{
    "outcome" => "failed",
    "failure-description" => "WFLYCTL0158: Operation handler failed: org.jboss.msc.service.DuplicateServiceException: Service org.wildfly.data-source.MySqlDS is already registered",
    "rolled-back" => true,
    "response-headers" => {"process-state" => "reload-required"}
}
{code}


{code:java}
01:52:14,722 ERROR [org.jboss.as.controller.management-operation] (XNIO-3 task-10) WFLYCTL0013: Operation ("add") failed - address: ([
    ("subsystem" => "datasources"),
    ("data-source" => "MySqlDS")
]): org.jboss.msc.service.DuplicateServiceException: Service org.wildfly.data-source.MySqlDS is already registered
{code}


  was:
1 - Create a new datasource through web admin console
2 - When in final step, click to test the connect
3 - Even it being a *test* it seems that it tries to add the datasource, so if you try to test again you'll get:

Unexpected HTTP response: 500

{code:json}

Request
{
    "name" => "MySqlDS",
    "use-ccm" => false,
    "pool-name" => "MySqlDS_Pool",
    "connection-url" => "jdbc:mariadb://192.168.0.119:3306",
    "jta" => false,
    "driver-class" => "org.mariadb.jdbc.Driver",
    "driver-name" => "mariadb-java-client-1.3.4.jar",
    "valid-connection-checker-class-name" => "org.jboss.jca.adapters.jdbc.extensions.mysql.MySQLValidConnectionChecker",
    "background-validation" => true,
    "exception-sorter-class-name" => "org.jboss.jca.adapters.jdbc.extensions.mysql.MySQLExceptionSorter",
    "jndi-name" => "java:/MySqlDS",
    "user-name" => "root",
    "password" => "123",
    "enabled" => true,
    "operation" => "add",
    "address" => [
        ("subsystem" => "datasources"),
        ("data-source" => "MySqlDS")
    ]
}

Response

Internal Server Error
{
    "outcome" => "failed",
    "failure-description" => "WFLYCTL0158: Operation handler failed: org.jboss.msc.service.DuplicateServiceException: Service org.wildfly.data-source.MySqlDS is already registered",
    "rolled-back" => true,
    "response-headers" => {"process-state" => "reload-required"}
}
{code}


{code:java}
01:52:14,722 ERROR [org.jboss.as.controller.management-operation] (XNIO-3 task-10) WFLYCTL0013: Operation ("add") failed - address: ([
    ("subsystem" => "datasources"),
    ("data-source" => "MySqlDS")
]): org.jboss.msc.service.DuplicateServiceException: Service org.wildfly.data-source.MySqlDS is already registered
{code}




> Testing JDBC connection is causing it to be added
> -------------------------------------------------
>
>                 Key: WFLY-6015
>                 URL: https://issues.jboss.org/browse/WFLY-6015
>             Project: WildFly
>          Issue Type: Bug
>    Affects Versions: 10.0.0.CR5
>         Environment: Mac OS X El Captain with latest update
> java version "1.8.0_66"
> Java(TM) SE Runtime Environment (build 1.8.0_66-b17)
> Java HotSpot(TM) 64-Bit Server VM (build 25.66-b17, mixed mode)
> MariaDB - with MariaDB JDBC driver deployed
>            Reporter: Renann Prado
>            Assignee: Jason Greene
>
> Testing JDBC connection is causing it to be added.



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