[jboss-jira] [JBoss JIRA] (WFLY-7214) Warning of IllegalStateException on test-connection-pool for DataSources added after previous failure addition

[Lin Gao (JIRA)]

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

Lin Gao updated WFLY-7214:
--------------------------
    Description: 
When a data-source was failed to be added because of missing connection-properties:
{code:}
/subsystem=datasources/data-source=XXX:add(jndi-name=java:/XXX, datasource-class=XXX,driver-name=h2, connection-url="jdbc:h2:test")
{code}
, it can be added by correcting the information, like:
{code:}
[standalone at localhost:9990 /] /subsystem=datasources/data-source=XXX:add(jndi-name=java:/XXX, driver-name=h2,connection-url="jdbc:h2:test")
{"outcome" => "success"}
{code}

But the {{test-connection-in-pool()}} operation failed with {{IllegalStateException}} of the new created data-source:

{code:}
[standalone at localhost:9990 /] /subsystem=datasources/data-source=XXX:test-connection-in-pool()
{
    "outcome" => "failed",
    "failure-description" => "WFLYJCA0040: failed to invoke operation: WFLYJCA0047: Connection is not valid",
    "rolled-back" => true
}
{code}


{panel:title=NOTE FOR THE VERIFY}
Changing the Step 1 to: 
{code:}
/subsystem=datasources/data-source=XXX:add(jndi-name=java:/XXX, datasource-class=XXX,driver-name=h2)
{code}
for the verifying
{panel}


  was:
When a data-source was failed to be added either because of missing connection-properties:
{code:}
/subsystem=datasources/data-source=XXX:add(jndi-name=java:/XXX, datasource-class=XXX,driver-name=h2, connection-url="jdbc:h2:test")
{code}
, it can be added by correcting the information, like:
{code:}
[standalone at localhost:9990 /] /subsystem=datasources/data-source=XXX:add(jndi-name=java:/XXX, driver-name=h2,connection-url="jdbc:h2:test")
{"outcome" => "success"}
{code}

But the {{test-connection-in-pool()}} operation failed with {{IllegalStateException}} of the new created data-source:

{code:}
[standalone at localhost:9990 /] /subsystem=datasources/data-source=XXX:test-connection-in-pool()
{
    "outcome" => "failed",
    "failure-description" => "WFLYJCA0040: failed to invoke operation: WFLYJCA0047: Connection is not valid",
    "rolled-back" => true
}
{code}




> Warning of IllegalStateException on test-connection-pool for DataSources added after previous failure addition
> --------------------------------------------------------------------------------------------------------------
>
>                 Key: WFLY-7214
>                 URL: https://issues.jboss.org/browse/WFLY-7214
>             Project: WildFly
>          Issue Type: Bug
>          Components: JCA
>            Reporter: Lin Gao
>            Assignee: Lin Gao
>
> When a data-source was failed to be added because of missing connection-properties:
> {code:}
> /subsystem=datasources/data-source=XXX:add(jndi-name=java:/XXX, datasource-class=XXX,driver-name=h2, connection-url="jdbc:h2:test")
> {code}
> , it can be added by correcting the information, like:
> {code:}
> [standalone at localhost:9990 /] /subsystem=datasources/data-source=XXX:add(jndi-name=java:/XXX, driver-name=h2,connection-url="jdbc:h2:test")
> {"outcome" => "success"}
> {code}
> But the {{test-connection-in-pool()}} operation failed with {{IllegalStateException}} of the new created data-source:
> {code:}
> [standalone at localhost:9990 /] /subsystem=datasources/data-source=XXX:test-connection-in-pool()
> {
>     "outcome" => "failed",
>     "failure-description" => "WFLYJCA0040: failed to invoke operation: WFLYJCA0047: Connection is not valid",
>     "rolled-back" => true
> }
> {code}
> {panel:title=NOTE FOR THE VERIFY}
> Changing the Step 1 to: 
> {code:}
> /subsystem=datasources/data-source=XXX:add(jndi-name=java:/XXX, datasource-class=XXX,driver-name=h2)
> {code}
> for the verifying
> {panel}



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)