blob: 96396b390937755d18601e6f02b86c1554557a8f [file] [log] [blame]
This devtest tries to test whether the appserver
destroys the connection when it is marked as bad.
-------------------------------------------------------------------------------------
test1() READ_ONLY OPERATION TO DB
XA DataSource Name - "UnshareableDataSource"
ejb-descriptor - datasource is "unshareable"
Tx Attribute : NOT SUPPORTED
Pool - steady, max-pool-size : 5
Test1 will retrieve connection from pool and mark it as bad. Iterates for 5 times.
Test1 passes when the monitoring information "num-conn-destroyed-count" is 5
Cumulative "destroyed" count - UnshareableDataSource(test1 ) : 5
-------------------------------------------------------------------------------------
test2() : WRITE OPERATION TO DB
XA DataSource Name - "UnshareableDataSource"
ejb-descriptor - datasource is "unshareable"
Tx Attribute : NOT SUPPORTED
Pool - steady, max-pool-size : 5
Test2 will retrieve connection from pool and mark it as bad. Iterates for 5 times.
Test2 passes when the monitoring information "num-conn-destroyed-count" is 5
Cumulative "destroyed" count - UnshareableDataSource (test1 & test2 ) : 10
-------------------------------------------------------------------------------------
test3() : READ_ONLY OPERATION TO DB
XA DataSource Name - "ShareableDataSource"
ejb-descriptor - datasource is "shareable"
Tx Attribute : NOT SUPPORTED
Pool - steady, max-pool-size : 5
Cumulative "destroyed" count - ShareableDataSource (test3 ) : 5
Test3 will retrieve connection from pool and mark it as bad. Iterates for 5 times.
Test3 passes when the monitoring information "num-conn-destroyed-count" is 5
-------------------------------------------------------------------------------------
test4() : WRITE OPERATION TO DB
XA DataSource Name - "ShareableDataSource"
ejb-descriptor - datasource is "shareable"
Tx Attribute : NOT SUPPORTED
Pool - steady, max-pool-size : 5
Test4 will retrieve connection from pool and mark it as bad. Iterates for 5 times.
Test4 passes when the monitoring information "num-conn-destroyed-count" is 5
Cumulative "destroyed" count - ShareableDataSource(test4 ) : 10
-------------------------------------------------------------------------------------
test5() : READ_ONLY OPERATION TO DB
XA DataSource Name - "UnshareableDataSource"
ejb-descriptor - datasource is "Unshareable"
Tx Attribute : REQUIRED
Pool - steady, max-pool-size : 5
Cumulative "destroyed" count - UnshareableDataSource (test1 & test2 & test5 ) : 15
Test5 will retrieve connection from pool and mark it as bad. Iterates for 5 times.
Test5 passes when the monitoring information "num-conn-destroyed-count" is 5
-------------------------------------------------------------------------------------
test6() : WRITE OPERATION TO DB
XA DataSource Name - "UnshareableDataSource"
ejb-descriptor - datasource is "Unshareable"
Tx Attribute : REQUIRED
Pool - steady, max-pool-size : 5
Cumulative "destroyed" count - UnshareableDataSource (test1 & test2 & test5 & test6 ) : 20
Test6 will retrieve connection from pool and mark it as bad. Iterates for 5 times.
Test6 passes when the monitoring information "num-conn-destroyed-count" is 5
-------------------------------------------------------------------------------------
test7() : READ_ONLY OPERATION TO DB
XA DataSource Name - "ShareableDataSource"
ejb-descriptor - datasource is "Shareable"
Tx Attribute : REQUIRED
Pool - steady, max-pool-size : 5
Cumulative "destroyed" count - ShareableDataSource (test3 & test4 & test7 ) : 11
Test7 will retrieve connection from pool and mark it as bad. Iterates for 5 times.
Test7 passes when the monitoring information "num-conn-destroyed-count" is 1 since
the connection is shared within the transaction
-------------------------------------------------------------------------------------
test8() : WRITE OPERATION TO DB
XA DataSource Name - "ShareableDataSource"
ejb-descriptor - datasource is "Shareable"
Tx Attribute : REQUIRED
Pool - steady, max-pool-size : 5
Cumulative "destroyed" count - ShareableDataSource (test3 & test4 & test7 & test8 ) : 12
Test8 will retrieve connection from pool and mark it as bad. Iterates for 5 times.
Test8 passes when the monitoring information "num-conn-destroyed-count" is 1 since
the connection is shared within the transaction
-------------------------------------------------------------------------------------
test9() : WRITE-WRITE OPERATION TO DBs
Local - XA
WRITE - WRITE
XA DataSource Name - "ShareableDataSource"
Local DataSource Name - "LocalDataSource"
ejb-descriptors for both resources - datasource is "Shareable"
Tx Attribute : REQUIRED
Both Pools - steady, max-pool-size : 5
Cumulative "destroyed" count - ShareableDataSource (test3 & test4 & test7 & test8 & test9 ) : 13
Cumulative "destroyed" count - LocalDataSource (test9 ) : 1
Test9 will retrieve connection from pool and mark it as bad. Iterates once.
Test9 passes when the monitoring information "num-conn-destroyed-count" for
ShareableDataSource is 1 &
"num-conn-destroyed-count" for LocalDataSource is 1.
-------------------------------------------------------------------------------------
test10() : READ-WRITE OPERATION TO DBs
Local - XA
WRITE - WRITE
XA DataSource Name - "ShareableDataSource"
Local DataSource Name - "LocalDataSource"
ejb-descriptors for both resources - datasource is "Shareable"
Tx Attribute : REQUIRED
Both Pools - steady, max-pool-size : 5
Cumulative "destroyed" count - ShareableDataSource (test3 & test4 & test7 & test8 & test9 & test10 ) : 14
Cumulative "destroyed" count - LocalDataSource (test9 & test10) : 2
Test10 will retrieve connection from pool and mark it as bad. Iterates once.
Test10 passes when the monitoring information "num-conn-destroyed-count" for
ShareableDataSource is 1 & "num-conn-destroyed-count" for LocalDataSource is 1.
-------------------------------------------------------------------------------------
test11() : READ-READ OPERATION TO DBs
Local - XA
READ - READ
XA DataSource Name - "ShareableDataSource"
Local DataSource Name - "LocalDataSource"
ejb-descriptors for both resources - datasource is "Shareable"
Tx Attribute : REQUIRED
Both Pools - steady, max-pool-size : 5
Cumulative "destroyed" count - ShareableDataSource (test3 & test4 & test7 & test8 & test9 & test10 & test11 ) : 15
Cumulative "destroyed" count - LocalDataSource (test9 & test10 & test11) : 3
Test11 will retrieve connection from pool and mark it as bad. Iterates once.
Test11 passes when the monitoring information "num-conn-destroyed-count" for
ShareableDataSource is 1 & "num-conn-destroyed-count" for LocalDataSource is 1.
-------------------------------------------------------------------------------------
test12() : WRITE-READ OPERATION TO DBs
Local - XA
WRITE - READ
XA DataSource Name - "ShareableDataSource"
Local DataSource Name - "LocalDataSource"
ejb-descriptors for both resources - datasource is "Shareable"
Tx Attribute : REQUIRED
Both Pools - steady, max-pool-size : 5
Cumulative "destroyed" count - ShareableDataSource (test3 & test4 & test7 & test8 & test9 & test10 & test11 & test12 ) : 16
Cumulative "destroyed" count - LocalDataSource (test9 & test10 & test11 & test12) : 4
Test12 will retrieve connection from pool and mark it as bad. Iterates once.
Test12 passes when the monitoring information "num-conn-destroyed-count" for
ShareableDataSource is 1 & "num-conn-destroyed-count" for LocalDataSource is 1.
-------------------------------------------------------------------------------------