Bugs item #551762, was opened at 2002-05-03 09:03 You can respond by visiting: http://sourceforge.net/tracker/?func=detail&atid=376685&aid=551762&group_id=22866
Category: JBossServer Group: v2.4 (stable) Status: Open Resolution: None Priority: 5 Submitted By: Matt Goodall (mgoodall) Assigned to: Nobody/Anonymous (nobody) 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. ---------------------------------------------------------------------- You can respond by visiting: http://sourceforge.net/tracker/?func=detail&atid=376685&aid=551762&group_id=22866 _______________________________________________________________ Have big pipes? SourceForge.net is looking for download mirrors. We supply the hardware. You get the recognition. Email Us: [EMAIL PROTECTED] _______________________________________________ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development