RE: [JBoss-user] Can't find connection left open

2003-08-27 Thread Brian McSweeney
Hi Alex, Thanks for the reply. This solved the problem. Thanks very much for your help. Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Alexey Loubyansky Sent: 26 August 2003 18:02 To: [EMAIL PROTECTED] Subject: Re: [JBoss-user] Can't

Re: [JBoss-user] Can't find connection left open

2003-08-26 Thread Alexey Loubyansky
It seems to be ok. One nuance, though. You are reusing variables stmt and rs for two PreparedStatement and ResultSet instances. > stmt = conn.prepareStatement( > SQL_FIND_PRODUCTS_COUNT_BY_CATEGORY, ResultSet.TYPE_SCROLL_INSENSITIVE, > ResultSet.CONCUR_READ_ONLY ); and then >

[JBoss-user] Can't find connection left open

2003-08-26 Thread Brian McSweeney
Hi everyone,   I have a problem where JBoss is telling me that it’s   “closing a connection you left open. Please do your own housekeeping.”   However, I can’t see where I’m leaving the connection open.   I’m using JBoss 3.2.1 and my database is mysql. I’m doing a page-by-page ite