-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Thomas,
Thomas Haines wrote:
| I've used the validation query within the as you suggested.
| This has stopped the "first connection after a while is a dead one"
| problem, and all is well in the land of my webapp!
I was reading the changelog for Co
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Martin,
Martin wrote:
| I see autoReconnect functionality in mysql-connector-java-5.1.6.tar.gz
| driver distro located at
| http://ftp.plusline.de/mysql/Downloads/Connector-J/
Why not just go to the canonical source? MySQL's website has everything
y
", "true");
|
|
|
| FWIW
| Martin-
| - Original Message - From: "Christopher Schultz"
| <[EMAIL PROTECTED]>
| To: "Tomcat Users List"
| Sent: Saturday, June 21, 2008 11:33 AM
| Subject: Re: Tomcat Connection Pooling - wait_timeout
|
|
| Thomas,
|
| Thomas Ha
Chris / David / Youssef
Thanks for the help. Problem has been resolved! Comments inline.
| a) downgrade to MySQL Connector/J 5.0.8 and see if this fixes it;
This may fix your problem, but probably not.
Confirmed, this had no effect.
| b) add a while (!verified && attempts<2) type loop in
ga-bin.jar?rev=56
FWIW
Martin-
- Original Message -
From: "Christopher Schultz" <[EMAIL PROTECTED]>
To: "Tomcat Users List"
Sent: Saturday, June 21, 2008 11:33 AM
Subject: Re: Tomcat Connection Pooling - wait_timeout
-BEGIN PGP SIGNED MESSAGE-
Christopher Schultz wrote:
Thomas Haines wrote:
| mysql connector 5.1.6
Is that a pre-release version, or did 5.1 become GA recently?
5.1.6 is the current release version of Connector/J.
5.1 server is still a release candidate however.
--David
-
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Thomas,
Thomas Haines wrote:
| mysql connector 5.1.6
Is that a pre-release version, or did 5.1 become GA recently?
| ERROR (21-06-08 07:59) [servlets.ViewEmail]
| com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet
| successful
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Youssef,
Youssef Mohammed wrote:
| people were suffering from this exception in hibernate forums, it was
| suggested to switch from DBCP to c3po.
Wow... switch connection pools as a fix to pool exhaustion problems?
That's odd...
| Note also that th
Regarding the one that's working, it's probably working because it isn't
letting the connection sit idle for such a long time.
There are a few things you might want to consider:
1. Just increase the connection timeout for your mysql service. The
default is 8 hours. I have one third party app
Hi Tom;
I am sorry, you seem to be right on that. In older versions, it wasn't
like that. So I would suggest that you first try to turn DBCP off.
If you get the same error, then it has nothing to do with DBCP. Otherwise,
you might consider other pooling.
On Sat, Jun 21, 2008 at 9:47 AM, Thomas
Hello Youssef
My understanding was that Tomcat 6 uses a data source factory to
create the data source, and uses Jakarta Commons DBCP to supply a data
source factory and implement connection pooling.
My configuration of the javax.sql.DataSource mimics:
http://tomcat.apache.org/tomcat-6.0-doc
people were suffering from this exception in hibernate forums, it was
suggested to switch from DBCP to c3po.
Note also that the config you provided is not using any pooling at all.
Datasources are not pooled by default.
On Sat, Jun 21, 2008 at 8:18 AM, Thomas Haines <
[EMAIL PROTECTED]> wrote:
>
this class what i was talking about
http://download-uk.oracle.com/docs/cd/B10501_01/java.920/a96654/oci_func.htm#1014118
On Mon, Jun 9, 2008 at 8:53 PM, Youssef Mohammed <[EMAIL PROTECTED]>
wrote:
> for oracle database, you can just use their native driver (oci driver),
> they have a Pooled Dat
yes, i believe my oracle db reboot once in a while, but I have no control
over rebooting db server since its for weekly maintenance. I will try to use
validationQuery as Thomas mentioned. Thanks
On Mon, Jun 9, 2008 at 1:43 PM, Propes, Barry L <[EMAIL PROTECTED]>
wrote:
> is this possibly Oracle r
Thanks Thomas, validationQuery method seems promising. I will configure and
see if the issue is still there when the db server reboot. Thanks a lot.
On Mon, Jun 9, 2008 at 1:21 PM, Mark Thomas <[EMAIL PROTECTED]> wrote:
>
> Htin Kyaw Nyo wrote:
>
>> Hi
>>
>> I am using tomcat55 and ojdbc14_g an
for oracle database, you can just use their native driver (oci driver), they
have a Pooled DataSource that will manage the pooling natively ...
you don't need dbcp then.
On Mon, Jun 9, 2008 at 5:26 PM, Htin Kyaw Nyo <[EMAIL PROTECTED]> wrote:
> Hi
>
> I am using tomcat55 and ojdbc14_g and tomca
is this possibly Oracle rebooting by its own settings?
-Original Message-
From: Htin Kyaw Nyo [mailto:[EMAIL PROTECTED]
Sent: Monday, June 09, 2008 9:27 AM
To: Tomcat Users List
Subject: tomcat connection pooling problem
Hi
I am using tomcat55 and ojdbc14_g and tomcat connection pooling
Htin Kyaw Nyo wrote:
Hi
I am using tomcat55 and ojdbc14_g and tomcat connection pooling. I am
getting this error when i leave tomcat run for a couple of days. I searched
around the internet and people blaming firewall and connection issues by db
server. here is a brief error:
java.sql.SQLExcept
Tomcat Datasources should be able to take care of connection pooling for you
unless you have a specific requirement for which you need your own pool.
The Datasource configuration/usage etc. is explained in tomcat docs.
-Sameer
prakash shanmugam <[EMAIL PROTECTED]> wrote: hi,
i am using tomcat4
19 matches
Mail list logo
