oops, I see you have it specified. So I'm not sure why you're running into this issue. We have it set and it works fine.
On Fri, May 1, 2009 at 1:42 PM, Sanjiv Jivan <sanjiv.ji...@gmail.com> wrote: > You need to set "validationQuery" on the BasicDataSource definition in > order to automatically handle lost database connections. For MySQL you can > use "select 1" and for Oracle you can use "select 0 from dual" > > Sanjiv > > > On Fri, May 1, 2009 at 12:40 PM, Albert.Chao <albert.c...@groupdca.com>wrote: > >> Matt, >> >> >> >> The issue is sometime we need to shut down db to do maintenance work. >> >> Once the database back on, the appfuse/tomcat can’t find connection to >> database. >> >> We need to restart appfuse/tomcat to let connection pool work again. >> >> >> >> Is it always necessary to restart app server? >> >> How to configure appfuse to avoid restarting app server? >> >> >> >> Albert >> >> >> ------------------------------ >> >> *From:* Matt Raible [mailto:m...@raibledesigns.com] >> *Sent:* Friday, May 01, 2009 12:24 PM >> *To:* users@appfuse.dev.java.net >> *Subject:* Re: [appfuse-user] gracely handle database disconnection >> >> >> >> How does the database get disconnected? Unfortunately, I'm not sure how to >> reconnect when it fails if it doesn't already happen automatically. >> >> On Fri, May 1, 2009 at 10:09 AM, Albert.Chao <albert.c...@groupdca.com> >> wrote: >> >> Hi all, >> >> >> >> Could someone help me to solve “disconnected database when user login”? >> >> >> >> I have these values in applicationConext-resource.xml. >> >> I started webserver / database then shutdown database to do this test >> case. >> >> When I login, I still get >> >> >> >> org.springframework.transaction.CannotCreateTransactionException: Could not >> open Hibernate Session for transaction; nested exception is >> org.hibernate.exception.JDBCConnectionException: Cannot open connection >> >> at >> org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:550) >> >> >> >> I have put <global-exception-mappings> <exception-mapping >> exception="java.lang.Exception" result="home"/> >> >> It still gives me stack error >> >> >> >> >> >> How to solve this issue? >> >> >> >> applicationConext-resource.xml >> >> <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" >> destroy-method="close"> >> >> <property name="driverClassName" value="${jdbc.driverClassName}" >> /> >> >> <property name="url" value="${jdbc.url}"/> >> >> <property name="username" value="${jdbc.username}"/> >> >> <property name="password" value="${jdbc.password}"/> >> >> <property name="maxActive" value="100"/> >> >> <property name="maxWait" value="1000"/> >> >> <property name="poolPreparedStatements" value="true"/> >> >> <property name="defaultAutoCommit" value="true"/> >> >> <property name="validationQuery" value="select 1 from dual"/> >> >> <property name="testOnBorrow" value="true"/> >> >> </bean> >> >> >> > >
