Bugs item #551762, was opened at 2002-05-03 11:03 Message generated for change (Comment added) made by letiemble You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=551762&group_id=22866
Category: JBossServer Group: v2.4 (stable) >Status: Closed >Resolution: Invalid Priority: 5 Submitted By: Matt Goodall (mgoodall) >Assigned to: Laurent Etiemble (letiemble) Summary: Connection pool wrapper problems Initial Comment: Statement and ResultSet objects that belong to a connection from a pool are not aware of the pool. Statement.getConnection() returns the *real* connection which can then be closed. Sample code to demonstrate the error: Connection conn = datasource.getConnection(); Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery(); Statement stmt2 = rs.getStatement(); Connection conn2 = stmt2.getConnection(); At this point conn != conn2, conn2 is the real connection that conn wraps. Symptoms are that the connection is actually closed and not simply returned to the pool. When the connection is closed a commit takes places even though that may be in the middle of a transaction. If you're using container managed transactions you'll also get a HeuristicRollbackException. Fixing the problem will involve correctly wrapping the pool managed Statement and ResultSet objects. ---------------------------------------------------------------------- >Comment By: Laurent Etiemble (letiemble) Date: 2003-10-10 10:43 Message: Logged In: YES user_id=437455 Statement and ResultSet are not to be pooled or wrapped. The correct way to use is : - get a Connection (fetched from the pool) - create a Statement - get a ResultSet - close the ResultSet - close the Statement - close the connection (returned to the pool) ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=551762&group_id=22866 ------------------------------------------------------- This SF.net email is sponsored by: SF.net Giveback Program. SourceForge.net hosts over 70,000 Open Source Projects. See the people who have HELPED US provide better services: Click here: http://sourceforge.net/supporters.php _______________________________________________ JBoss-Development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
