Use connection pool in axis2 service (c3p0 for example)
From: Ted Zeng [mailto:[email protected]]
Sent: Friday, December 09, 2011 11:24 PM
To: [email protected]
Subject: Question about MySQL timeout problem
Hi all,
After my app. Runs ok with Axis2 for a while, I get the following exception
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
Hi Ted,
autoReconnect=true is not a proper solution: mysql close the connection if it
was idle for 2 hours. So if you access the closed connection you will have
exception first and then auto reconnect, but
the original request will fail. You need to setup 'autoreconnect+connection
test on borro
What is the best practices to retrieve identifier in service operation method?
Is identifier from CallbackHandler stored in local thread?
Regards, Tomaz
<>
-
To unsubscribe, e-mail: [email protected]
For addi
Hi Paul,
Thanks for pointing this. I am new to this Pool connection concept.
I have used mysql before and never had this timeout problem as I always close
the connection right away.
After googling a couple of hours and I am still not sure how to set
"testOnBorrow = true" in Axis.
I am using st
Hell Everyone,
I have class defined as follows :
public class StateBean {
public StateBean()
{
}
public String stateName;
public String stateCode;
public ArrayList countryList1;
public final ArrayList getCountryList() {
return countryList;
}
public final void setCountryList1(ArrayLi
Ive always had to create an array from my arraylists and return the array. We
were using axis2 1.3.1.
From: [email protected]
[mailto:[email protected]] On
Behalf Of Sathunuri, Hariprasad
Thanks a lot Chris for the quick response. I am struggling with it from past 2
days.
I am using axis 2-1.6.1 but using the code generator eclipse plugin 1.3.0. Do
you know if it has been fixed in latest version ?
Thanks in advance,
Hari
From: Meeusen, Christopher W. [mailto:meeusen.christop
Now Axis2 trunk fully support for Java Collection API and this will be
available on 1.7.0 release. You can try with latest snapshots.
Thanks!
On Tuesday, December 13, 2011, Sathunuri, Hariprasad (US - Arlington) <
[email protected]> wrote:
> Hell Everyone,
>
>
>
> I have class defined as fo