> is the ResultSet not closed when Result doesn't fit in one page? That's right. Resultset is only closed - if all records are fetched (This is the case when all rows fit on one page) - a new query is sent - after session time out - this is implemented in DataSourceList which implement HttpSessionBindingListener.
So it could happen that a connection stays open until the session dies! Hope that helps! Cheers Henner ------------------------------------------------------- This SF.Net email is sponsored by: IBM Linux Tutorials Free Linux tutorial presented by Daniel Robbins, President and CEO of GenToo technologies. Learn everything from fundamentals to system administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click _______________________________________________ DbForms Mailing List http://www.wap-force.net/dbforms