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
: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 on Axis2 and Axis is stuck. My app. Could not talk to Axis anymore. If I reboot Axis2, then everything works again. I google this an

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

Question about MySQL timeout problem

2011-12-09 Thread Ted Zeng
Hi all, After my app. Runs ok with Axis2 for a while, I get the following exception on Axis2 and Axis is stuck. My app. Could not talk to Axis anymore. If I reboot Axis2, then everything works again. I google this and found out most are reported by Hibernate users and their solutions. How shou