[jboss-jira] [JBoss JIRA] (WFLY-7214) Warning of IllegalStateException on test-connection-pool for DataSources added after previous failure addition
[
https://issues.jboss.org/browse/WFLY-7214?page=com.atlassian.jira.plugin....
]
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@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@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@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@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@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@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)