| Copy of dev-test from jdbc-devtests, in order |
| to have a monitoring test for application scoped connection pools |
| |
| Test case for issue : GLASSFISH-16898 |
| |
| |
| 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. |
| ------------------------------------------------------------------------------------- |
