David,
Oracle have a view named v$sqlarea that contains all SQL Queries, and in my
case "Select * from dual" appears :( So validationQuery is sending this
query.
Christopher,
I don't expect many long-time queries... So what's your opinion?
Tnks all!
Christopher Schultz-2 wrote:
>
> -
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
CC,
On 3/23/2009 11:24 AM, CutKiller wrote:
> But the validationQuery was set at the Resources Tags.
>
>debug="0" reloadable="true" crossContext="true">
What version of TC are you running? You shouldn't be setting the path
attribute, though
I couldn't tell you as I don't run an Oracle instance. Talk with your
DBA regarding what kind of logging data might be available. In
particular you are asking for logs showing the sql commands coming from
your webapp and the date/time they were executed.
--David
CutKiller wrote:
> David,
>
> P
David,
Please what's the name of the logs that you mentioned? My DB is Oracle.
Tnks
David Smith-2 wrote:
>
> Changing the timeout in the firewall is exactly what makes me think one
> of three things are going on:
>
> 1. The validation query isn't active in your environment. Maybe you
> di
can easily be subject to manipulation,
> we can not accept any liability for the content provided.
>
>
>
>
>
>
>> Date: Tue, 24 Mar 2009 07:03:57 -0700
>> From: rjrferre...@gmail.com
>> To: users@tomcat.apache.org
>> Subject: Re: Tomcat and Database Pro
Subject: Re: Tomcat and Database Problem
>
>
> Hi David,
>
>
> Yes I know that a 403 doesn't seem to have anything with this situation, but
> it's the only error :)
>
> Strange...Strange... I don't know what to do...
>
>
> If I raise de connec
Changing the timeout in the firewall is exactly what makes me think one
of three things are going on:
1. The validation query isn't active in your environment. Maybe you
didn't restart your webapp and/or tomcat after adding it or another
element is superseding it.
2. Your code is holding on to
Hi David,
Yes I know that a 403 doesn't seem to have anything with this situation, but
it's the only error :)
Strange...Strange... I don't know what to do...
If I raise de connection timeout in the firewall I solve the problem. The
problem here, is that i don't have permissions to do anything
Are you sure the validation query is active in the connection pool?
There aren't any other elements in other xml fragments
superseding the one below? Seems a litle strange that your firewall
would should down a connection in the tiny (microseconds) sliver of time
between the validation query and
If helps, the connection state is "connection reset"
CutKiller wrote:
>
>
> No errors... :(
>
> For example when i sign in on the App, appears one error on tomcat log...
> A 403 something...
>
>
>
>
> David Smith-2 wrote:
>>
>> Any indication in the logs of what's happening around the t
No errors... :(
For example when i sign in on the App, appears one error on tomcat log... A
403 something...
David Smith-2 wrote:
>
> Any indication in the logs of what's happening around the time you get a
> bad connection? Seems weird to me that the validation query isn't
> working.
>
>
Any indication in the logs of what's happening around the time you get a
bad connection? Seems weird to me that the validation query isn't working.
--David
CutKiller wrote:
> Tnks David.
>
>
> But the validationQuery was set at the Resources Tags.
>
>debug="0" reloadable="true" crossCont
Tnks David.
But the validationQuery was set at the Resources Tags.
David Smith-2 wrote:
>
> CutKiller wrote:
>> If I raise the timeout value in the firewall parameters the connection
>> problem was solved but i don't have permissions to do that in real
>> environment.
>>
>>
CutKiller wrote:
> If I raise the timeout value in the firewall parameters the connection
> problem was solved but i don't have permissions to do that in real
> environment.
>
> The connections are dead, but this connections stays in tomcat pool with no
> problems. Tomcat, in a perfect scenario
If I raise the timeout value in the firewall parameters the connection
problem was solved but i don't have permissions to do that in real
environment.
The connections are dead, but this connections stays in tomcat pool with no
problems. Tomcat, in a perfect scenario, should recognize the loss
CutKiller wrote:
> Hi all I have this scenario:
>
> |Tomcat| -> |Firewall| -> |Database|
>
> Sometimes the connection to the database is lost. The cause of this fact
> maybe lives in the Firewall. But, the major problem, resides in Tomcat. He
> doesn't recognize the connection break. What can i d
Tnks Filip.
But i allready try that solution, and the problem continues
Filip Hanik - Dev Lists wrote:
>
> use the validationQuery attribute for your connection pool.
>
> the validationQuery executes a query against the database before the
> connection is returned to the application, a
use the validationQuery attribute for your connection pool.
the validationQuery executes a query against the database before the
connection is returned to the application, and validates that the
connection actually works
Filip
CutKiller wrote:
Hi all I have this scenario:
|Tomcat| -> |Fire
18 matches
Mail list logo
