Re: Question about MySQL timeout problem

2011-12-12 Thread Ted Zeng
tion first and then auto reconnect, but the original request will fail. You need to setup 'autoreconnect+connection test on borrow' at the pool level... From: Ted Zeng [mailto:z...@adobe.com] Sent: Monday, December 12, 2011 11:39 AM To: java-user@axis.apache.org Subject: Re: Question a

RE: Question about MySQL timeout problem

2011-12-12 Thread Hodchenkov, Paul
st on borrow' at the pool level... From: Ted Zeng [mailto:z...@adobe.com] Sent: Monday, December 12, 2011 11:39 AM To: java-user@axis.apache.org Subject: Re: Question about MySQL timeout problem It looks like I fixed this problem with setting autoReconnect=true In DriverManager.getConnectio

Re: Question about MySQL timeout problem

2011-12-12 Thread Ted Zeng
It looks like I fixed this problem with setting autoReconnect=true In DriverManager.getConnection() in the ServiceLifeCycle code. I am using connection pool. I am pretty much following the Example code (DBService). It seems the sample code should add "autoReconnect=true" to it. As the code stand

RE: Question about MySQL timeout problem

2011-12-12 Thread Hodchenkov, Paul
Use connection pool in axis2 service (c3p0 for example) From: Ted Zeng [mailto:z...@adobe.com] Sent: Friday, December 09, 2011 11:24 PM To: java-user@axis.apache.org Subject: Question about MySQL timeout problem Hi all, After my app. Runs ok with Axis2 for a while, I get the following exception