hm0X
> HbcAn2KPdmbsjMcoEsIbVJgiqqSnZFdH
> =qsgv
> -END PGP SIGNATURE-
>
> -------------
> To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
> For additional commands, e-mai
-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
gt;>>>>>>>
>>>>>>>> Right and it would recognize dead connections if validationQuery is
>>>>>>>> provided on the connection pool. The pool will execute the
>>>>>>>> validation
>>>>>>>> query before handing your webapp the co
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
>>> Posting details of your setup would be helpful including the
>>>>>> >>>>> ... /> tag that configures your pool and relevant code where things
>>>>>> are
>>>>>> breaking.
>>>>>>
>
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
gt;
>>>>>>> |Tomcat| -> |Firewall| -> |Database|
>>>>>>>
>>>>>>> Sometimes the connection to the database is lost. The cause of this
>>>>>>> fact
>>>>>>> maybe lives in the Firewall.
t;>>> 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 do, for
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
nsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
>>> For additional commands, e-mail: users-h...@tomcat.apache.org
>>>
>>>
>>>
>>>
>>
>>
>
>
> --
> David Smith
> Programmer/Analyst
> College of Agricul
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
ers-unsubscr...@tomcat.apache.org
> For additional commands, e-mail: users-h...@tomcat.apache.org
>
>
>
--
View this message in context:
http://www.nabble.com/Tomcat-and-Database-Problem-tp22658620p22661559.html
Sent from the Tomcat - User mailing list archive at Nabble.com.
---
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
gt;
>
>
> -
> To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
> For additional commands, e-mail: users-h...@tomcat.apache.org
>
>
>
--
View this message i
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
knows when
the connections break?
Best Regards,
Rodrigo
--
View this message in context:
http://www.nabble.com/Tomcat-and-Database-Problem-tp22658620p22658620.html
Sent from the Tomcat - User mailing list archive at Nabble.com.
-
19 matches
Mail list logo
