Question: Is it possible to shutdown the database and restart it? Will JBoss complain about stale connections?
Answer; You can configure the following in your -ds.xml | <check-valid-connection-sql>some cheap sql statement</check-valid-connection-sql> | e.g. for Oracle "select 1 from dual" | JBoss will run the SQL statement before handing out the connection from the pool. If the SQL fails, the connection will be destroyed/closed and new ones will be created. Regards, Adrian <a href="http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3825665#3825665";>View the original post</a> <a href="http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3825665>Reply to the post</a> ------------------------------------------------------- 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 _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
