-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:
>
Hello
I am experiencing a reproducible problem with connection pooling in
Tomcat, although I suspect it is not a Tomcat issue per se.
I am running:
mysql server 5.0.58
tomcat 6.0.16
mysql connector 5.1.6
java version 1.5.0_13
all on CentOS 5
The following error occurs when there has been no
ave 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 tomcat connection
ly 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 ojd
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:
&
55 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.SQLException: Io exception: Connec
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
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
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.SQLException: Io exception
=localhost,class=
javax.sql.DataSource,name="jdbc/PhoenixDB"
When trying to use the DB2DataSourceFactory instead of the dbcp one...
Thanks,
-P
- Original Message
From: Tim Lucia <[EMAIL PROTECTED]>
To: Tomcat Users List
Sent: Friday, February 2, 2007 1:29:05 PM
Subject: RE: DB2/Tomcat Co
ia <[EMAIL PROTECTED]>
To: Tomcat Users List
Sent: Friday, February 2, 2007 1:29:05 PM
Subject: RE: DB2/Tomcat Connection pooling problem
> Also in V6, it seems to be using a version of dbcp associated with tomcat
> as opposed to commons. (org.apache.tomcat.dbcp.*) Has some underlying
> Also in V6, it seems to be using a version of dbcp associated with tomcat
> as opposed to commons. (org.apache.tomcat.dbcp.*) Has some underlying
> behavior changed as well here?
This is the standard behavior with 5.5.x -- DBCP is repackaged under the
Tomcat package (presumably) to avoid conflic
Hello all,
I am currently working on getting Tomcat and DB2 to work together here and have
been having a heck of a time.
I'm at a point where I'm able to reference the JNDI resource in my test servlet
(finally), and now am getting a connection pool issue: "Cannot create
PoolableConnectionFactory
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
hi,
i am using tomcat4 with MySql5 for web application development..
i am trying to implement connection pooling in Tomcat...
can anybody give me some links or documents or pdfs by means of which i can
learn details about connection pooling in tomcat...
thanks in advance..
prakash
26 matches
Mail list logo
