Re: Database connection pooling

2011-12-30 Thread Ted Zeng
u can store them in the pool and put them back to the pool after each usage. On 12/30/2011 2:49 PM, Ted Zeng wrote: Database connection pooling Hi all, I am new to Axis2 and database connection pooling. I read the article "Exposing a Database as a Web Service" by Deepal Jayasingh

Database connection pooling

2011-12-30 Thread Ted Zeng
tion ignore) {} } I hope my approach is right. I am testing the code. Not sure why the first call take a couple of seconds. But Fine after that. I need to wait to 6 hours (I don't know how to modify the mysql timeout yet) to test the Timeout condition. Thanks, Happy Holiday! Ted Zeng Adobe Systems

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 Ted Zeng
s the code stands now, It should fail eventually when the database connection times out. Thanks, -ted On 12/11/11 10:59 PM, "Hodchenkov, Paul" wrote: Use connection pool in axis2 service (c3p0 for example) From: Ted Zeng [mailto:z...@adobe.com] Sent: Friday, December 09, 2011 11

Question about MySQL timeout problem

2011-12-09 Thread Ted Zeng
should I resolve this? Is there a setting for Axis2 I need to set. -Ted Zeng Adobe Systems Inc. --- com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 39,903,899 milliseconds ago. The last packet sent successfully to the

Re: Question about passing parameter with string "null"

2011-12-09 Thread Ted Zeng
ds, Paul On Sun, Dec 4, 2011 at 3:33 AM, Ted Zeng wrote: Hi all, I pass some parameters as strings. Things work fine, except when a string is "null". Then the "null" would shift to the end. So I have a parameter list: "1", "null", "3" Then the se

Re: Question about passing parameter with string "null"

2011-12-03 Thread Ted Zeng
I forgot to mention I am using the latest Axis2. -ted On 12/3/11 2:03 PM, "Ted Zeng" wrote: Hi all, I pass some parameters as strings. Things work fine, except when a string is "null". Then the "null" would shift to the end. So I have a parameter list: "1

Question about passing parameter with string "null"

2011-12-03 Thread Ted Zeng
ecking the parameters Before sending out and modify the "null" to something else? Ted Zeng AIR Android Adobe Systems

RE: [Axis2] How to connect MySQL with the standalone version

2011-11-03 Thread Ted Zeng
he net and find anything related to setting up MySQL is about Tomcat, etc. not the standalone version. I thought this should be a simple problem. But I could not find the answer from the Axis2 web. I hope someone here could help me out. Thanks, -Ted Zeng Adobe Systems Inc. com.mysql.jdbc.exce

[Axis2] How to connect MySQL with the standalone version

2011-11-03 Thread Ted Zeng
someone here could help me out. Thanks, -Ted Zeng Adobe Systems Inc. com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. at