Bugs item #644496, was opened at 2002-11-27 02:48 You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=644496&group_id=22866
Category: None Group: None Status: Open Resolution: None Priority: 5 Submitted By: longjianglei (catherine_long) Assigned to: Nobody/Anonymous (nobody) Summary: a problem of JCA's connection pool Initial Comment: Operating System :windows2000 professional JDK Version :v1.3.1 Server trace from the console :none Steps to reproduce the bug : 1.Enviroment: *a jboss server *a MSSQL database server They are not in the same computer. *we use LocalTX *jboss version is 3.0.2 2.Write a EJB on jboss server which has a test method that access the database continuously. 3.At beginning,the EJB's client call this test method,we can see accessing database is OK. 4.Then we disconnect the network between the jboss server and database,we found accessing database fail. 5.When we reconnect the network, we found accessing database always fail and can not success again. Conclusion: 1.We have traced the src code of JCA.We found that when a SQLException ocurred during accessing database,JCA does not kill the bad connection.So,when this connection is put back to connection pool,user will get an invalid connection when they re-get a connection.In the worst case,all of the connections in connection pool are invalid,user can not get any connection again. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=644496&group_id=22866 ------------------------------------------------------- This SF.net email is sponsored by: Get the new Palm Tungsten T handheld. Power & Color in a compact size! http://ads.sourceforge.net/cgi-bin/redirect.pl?palm0002en _______________________________________________ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
