Read and respond to this message at: https://sourceforge.net/forum/message.php?msg_id=2901760 By: hkollmann
Connection is held open until all data rows are fetched are a new query is done or session time out happens. This is by design to enable datalist navigation. Holding a connection open is not a real problem if you do not use connection pooling. With connection pooling you must close the connection before you can reuse it. This is a problem with dbforms and datalist navigation. To overcome this problem you can use the SinglePerThreadConnectionProvider wich will open a connection for each tomcat thread and held this open. Because one connection can handle more then one statement this should work. Hope that helps Henner ______________________________________________________________________ You are receiving this email because you elected to monitor this forum. To stop monitoring this forum, login to SourceForge.net and visit: https://sourceforge.net/forum/unmonitor.php?forum_id=55829 ------------------------------------------------------- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://productguide.itmanagersjournal.com/ _______________________________________________ DbForms Mailing List http://www.wap-force.net/dbforms
