| brian |
Tue Aug 26 00:22:06 BST 2008 |
| |
Hi!
When I try to get a statement object from a result set (PoolResultSet) the code returns a plain old Statement, not a PoolStatement.
This is causing problems for me when I try to close the statement from the result set, because I am actually closing the Statement, not the PoolStatement, so the system still thinks there's an open statement.
Something similar is also happening with PoolStatement and PoolConnection. When I try to get the connection from the statement, I get a plain Connection instead of a PoolConnection. So when I close it, the system still thinks I have open connections. This is causing my program to run out of connections, even though mysql doesn't report the same number of open connections.
I'm running standalone (for the moment). Any ideas on how to get this to work?
Thanks!
/Brian |
| |
| sedj |
Tue Aug 26 21:53:16 BST 2008 |
| |
There is a bug in primrose ...
If you close a Statement from a result set , ie :
resultSet.getStatement().close();
it will not work correctly.
Ideally you should close the result set, then the statement object obtained originally from the connection, then the connection obained from the JNDI lookup.
IE :
Connection c = getConnection();
Statement s = c.createStatement();
ResultSet rs = s.executeQuery("select * from bla");
...
rs.close();
s.close();
c.close();
This bug has been fixed in the next version of primrose, but currently is a bug with the current version. |
| guest |
Sat Jun 05 02:46:49 BST 2010 |
| |
| rn1UrK mewxcqivejsa, [url=http://lbmttulwtlts.com/]lbmttulwtlts[/url], [link=http://frrgalbswrmz.com/]frrgalbswrmz[/link], http://jhzdexclfenl.com/ |
| guest |
Sat Jun 05 02:46:49 BST 2010 |
| |
| rn1UrK mewxcqivejsa, [url=http://lbmttulwtlts.com/]lbmttulwtlts[/url], [link=http://frrgalbswrmz.com/]frrgalbswrmz[/link], http://jhzdexclfenl.com/ |
|
