-BEGIN PGP SIGNED MESSAGE-
Hash: SHA256
Jeffrey,
On 4/5/13 10:27 AM, Jeffrey Janner wrote:
> Yes, it connects to an Oracle DB, and I strongly suspect they may
> be seeing a connection pool leak in a little-used bit of code.
If you think you have a connection leak, debug that first. Can y
And that's right . You can define any SQL , but you prefer the easiest (
and fastest )
Indeed , you could use SELECT 1 FROM DUAL in MySQL, but it's not required
by using FROM DUAL
>From MySQL doc
"DUAL is purely for the convenience of people who require that all SELECT
statements should have FROM
Ok, thanks for clarification. I thought it had to be "from some faux table or
object."
-Original Message-
From: Jose María Zaragoza [mailto:demablo...@gmail.com]
Sent: Friday, April 05, 2013 3:44 PM
To: Tomcat Users List
Subject: Re: Tomcat7 - ajax and connection pool : "connection clo
'select 1 from dual' works in Oracle DB
In MySQL, "select 1"
2013/4/5 Propes, Barry L
> I could be wrong, but is that validationQuery attribute correct?
>
> "SELECT 1" ? - I have validationQuery="select 1 from dual" in mine, and
> my doc states it has to be a valid SQL statement returning at
I could be wrong, but is that validationQuery attribute correct?
"SELECT 1" ? - I have validationQuery="select 1 from dual" in mine, and my doc
states it has to be a valid SQL statement returning at least one row.
That may not factor in at all, just noticed it. Looked maybe out of kilter.
---
On Fri, Apr 5, 2013 at 9:07 AM, Anton Piatek1 wrote:
> I am seeing what at first appears to be a bug, but given the lack of other
> reports I can't believe I am the only person seeing this, so maybe it is
> user-error.
>
> I have tomcat (was 7.0.30, but I just tried with 7.0.39) running a website
Hi Konstantin:
About this link
http://commons.apache.org/proper/commons-dbcp/configuration.html
If you have enabled "removeAbandoned" then it is possible that a connection
is reclaimed by the pool because it is considered to be abandoned. This
mechanism is triggered when (getNumIdle() < 2) and (
2013/4/5 Jean-Claude Haw-King-Chon :
> Le 05/04/2013 13:09, Konstantin Kolinko a écrit :
>>
>> 2013/4/5 Jean-Claude Haw-King-Chon :
>>>
>>> Hi,
>>>
>>> I use the connection pool of tomcat7 and set a connection in a
>>> ThreadLocal.
>>> The context is a web application : the threadLocal is configure
Le 05/04/2013 13:09, Konstantin Kolinko a écrit :
2013/4/5 Jean-Claude Haw-King-Chon :
Hi,
I use the connection pool of tomcat7 and set a connection in a ThreadLocal.
The context is a web application : the threadLocal is configured when the
http request is initialized. The jdbc connection is cl
Jeffrey Janner wrote:
-Original Message-
From: André Warnier [mailto:a...@ice-sa.com]
Sent: Thursday, April 04, 2013 12:34 PM
To: Tomcat Users List
Subject: Re: Tomcat and Window nonpaged pool
Jeffrey Janner wrote:
-Original Message-
From: Harris, Jeffrey E. [mailto:jeffrey.har.
> -Original Message-
> From: André Warnier [mailto:a...@ice-sa.com]
> Sent: Thursday, April 04, 2013 12:34 PM
> To: Tomcat Users List
> Subject: Re: Tomcat and Window nonpaged pool
>
> Jeffrey Janner wrote:
> >> -Original Message-
> >> From: Harris, Jeffrey E. [mailto:jeffrey.har..
Am 05.04.2013 15:34, schrieb Daniel Mikusa:
Am 04.04.2013 15:01, schrieb Daniel Mikusa:
The tomcat version is 6.0.18, running on Linux 2.6.24, Java version is 1.6.0_13.
That's incredibly old, you should look at upgrading ASAP.
I know. That's not really my call, unfortunatly.
--
On Apr 5, 2013, at 6:02 AM, Andy Pahne wrote:
> Am 04.04.2013 15:01, schrieb Daniel Mikusa:
>
>
> The tomcat version is 6.0.18, running on Linux 2.6.24, Java version is
> 1.6.0_13.
That's incredibly old, you should look at upgrading ASAP.
>
>
>
>> It would be helpful to post your configura
I am seeing what at first appears to be a bug, but given the lack of other
reports I can't believe I am the only person seeing this, so maybe it is
user-error.
I have tomcat (was 7.0.30, but I just tried with 7.0.39) running a website
which uses websockets. The websockets code in tomcat isn't t
Fist of all, do NOT top post. Use the power of your wondeful mail client.
Am 2013-04-05 13:05, schrieb Jean-Claude Haw-King-Chon:
I wish to avoid passing the connection through the layers of the
application (from controller to DAO).
The controller initialize the connection and must pass it to th
2013/4/5 Jean-Claude Haw-King-Chon :
> Hi,
>
> I use the connection pool of tomcat7 and set a connection in a ThreadLocal.
> The context is a web application : the threadLocal is configured when the
> http request is initialized. The jdbc connection is closed and removed from
> the threadLocal when
I wish to avoid passing the connection through the layers of the
application (from controller to DAO).
The controller initialize the connection and must pass it to the Dao
layer. I don't want to pass the datasource or connection to the business
layer as a parameter.
Futher, the data source can
Am 2013-04-05 11:37, schrieb Jean-Claude Haw-King-Chon:
Hi,
I use the connection pool of tomcat7 and set a connection in a
ThreadLocal. The context is a web application : the threadLocal is
configured when the http request is initialized. The jdbc connection is
closed and removed from the thread
Am 04.04.2013 15:01, schrieb Daniel Mikusa:
The tomcat version is 6.0.18, running on Linux 2.6.24, Java version is
1.6.0_13.
It would be helpful to post your configuration, minus comments, as well as the
exact version of Tomcat that you are running.
SSLEngine="on" />
classNa
Hi,
I use the connection pool of tomcat7 and set a connection in a
ThreadLocal. The context is a web application : the threadLocal is
configured when the http request is initialized. The jdbc connection is
closed and removed from the threadLocal when the resquest is destroyed.
If I'm not mi
Chris Arnold wrote:
I didn't think I needed a second worker but because the working
config only worked for http://share.domain1.com and nothing else, I
wanted to verify it should work or I needed another worker and you
verified I do not need another worker and in fact, the existing
config for htt
21 matches
Mail list logo
