-
1. Re: scrollable/updateable PreparedStatement bug in jBoss 2.4
johnnycannuk Feb 20, 2002 2:15 PM (in response to thomasp)Yeah this is a bug....
Check out http://main.jboss.org/thread.jsp?forum=46&thread=7336
I posted the fix details and link to the patch there.
Mike -
2. Re: scrollable/updateable PreparedStatement bug in jBoss 2.4
thomasp Feb 21, 2002 3:29 AM (in response to thomasp)Mike,
thank you very much for your answer. I already thought it would be some stuff like that. I'm currently fighting with small-size pools, it seems it does not release my connection. That's going to be a little bit more funny...
Thomas -
3. Re: scrollable/updateable PreparedStatement bug in jBoss 2.4
thomasp Feb 21, 2002 3:38 AM (in response to thomasp)Sorry Mike,
I just wanted to mention that with this patch you do not use the pool anymore. But another fix would be bigger, I think ;)
Thank you -
4. Re: scrollable/updateable PreparedStatement bug in jBoss 2.4
davidjencks Feb 25, 2002 10:30 PM (in response to thomasp)You can get the oracle (or whatever) connection from the jboss wrapper by calling ((JDBCConnection)conn).getUnderlyingConnection(), and do what you like with it. When you are done, be SURE to close the jboss connection, not the Oracle one, or you will be very sorry. Be sure to release all resources quickly to minimize the chances of interfering with the pooling.
This won't use the prepared statement caching of the jboss wrappers, but the Oracle driver's caching is probably better anyway. -
5. Re: scrollable/updateable PreparedStatement bug in jBoss 2.4
johnnycannuk Mar 3, 2002 2:45 PM (in response to thomasp)Thomasp
If my fix doesn't use the pool, then none of the other calls to createStatement or prepareCall do either...my imlementation is a cut and paste of createStatement style...
Mike