Re: tomcat with laptop + windows sleep

2018-06-03 Thread Alex O'Ree
I did not copy any tomcat specific jars. I have validation queries
implemented programmatically.

On Sun, Jun 3, 2018 at 8:44 AM, Felix Schumacher <
felix.schumac...@internetallee.de> wrote:

>
>
> Am 02.06.2018 um 20:51 schrieb Alex O'Ree:
>
>> I think I've narrowed it down to an issue specific with terracotta quartz
>> based jobs. I've wired it into using tomcat's jdbc connection pooling. I'm
>> also using a super
>> old version of it so that could be part of the problem. Interestingly this
>> didn't happen with tomcat7 but it's more than probably some other change
>> on
>> my
>> end caused this rather strange situation.  Anyhow, it's probably not
>> tomcat.
>>
>
> You copied the jdbc pool jars from tomcat 7 into tomcat 8.5? Why?
>
>
>> Context.xml is something like this
>>
>>
>> > type="javax.sql.DataSource"
>> maxActive="50" maxIdle="30" maxWait="1"
>> username="user" password="a password"
>> driverClassName="org.postgresql.Driver"
>> factory="my.custom.EncryptedConnectionFactory"
>> url="jdbc:postgresql://localhost:5432/my_database"
>> />
>>
>
> You could enable validation queries, so that the pool will check the
> connections validity before handing it out to your application.
>
> Regards,
>  Felix
>
>
>> The encrypted connection factory extends the default one and supports a
>> basic ciphered password
>>
>>
>>
>>
>> On Sat, Jun 2, 2018, 1:34 PM Felix Schumacher > internetallee.de> wrote:
>>
>>
>>> Am 24. Mai 2018 23:30:10 MESZ schrieb Alex O'Ree :
>>>
 Yes it is a tomcat managed data source with postgres. The cpu usage is
 my
 app trying to get a managed data source. Perhaps the jdbc driver is the
 issue. ..

>>> Care to post your configuration? Maybe there are some changes missing
>>> when
>>> you updated to the newer version.
>>>
>>> Regards,
>>>   Felix
>>>
>>> On Wed, May 23, 2018, 11:28 AM Christopher Schultz <
 ch...@christopherschultz.net> wrote:

 -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA256
>
> Alex,
>
> On 5/22/18 7:39 PM, Alex O'Ree wrote:
>
>> I've noticed a behavioral difference from tomcat 7 to 8.5. In v7, I
>> used to be able to put a computer to "sleep" with tomcat running.
>> On resume, everything would be just fine. On tomcat 8.5, i'm
>> noticing that all database connections are basically dropped and do
>> not appear to to restart/resume when the computer resumes. Actually
>> the whole computer runs super slow until i kill the tomcat process.
>> I'm not entirely sure what's going on here. Has anyone else noticed
>> this kind of behavior?
>>
> Are you using a tomcat-configured DataSource in your application? If
> so, what does the configuration look like?
>
> I wouldn't expect any problems with sleep. I'm using Tomcat 8.5.29 on
> MacOS and I haven't noticed any problems when my laptop goes to
>
 sleep.

> I'm using Oracle Java 1.8.0_131 in this particular case.
>
> When it's running slowly, can you tell which process is taking up all
> the CPU (or disk)? Try using the Process Explorer to single-out a
> process. If it's Tomcat (java.exe), take a thread dump to see what
> Tomcat is doing.
>
> - -chris
> -BEGIN PGP SIGNATURE-
> Comment: GPGTools - http://gpgtools.org
> Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/
>
> iQIzBAEBCAAdFiEEMmKgYcQvxMe7tcJcHPApP6U8pFgFAlsFiIkACgkQHPApP6U8
> pFi70g/8D9R8EkjpCeNziAUeQmWwxHwui+jbOd1rGjG7EID21mmmJJgw5IO1O8ok
> F7GUWC8KloqFJ59m+Ib/3NCL5QkiuE/X++AyvDxgwuI1eqlxi86Gu7Jxw6wsfUj2
> K1Ovp+jUeNEhuxPfx7zBiHXQPa1kN+B7ExxOyVEeybRalF27hlums2zF6IlC4VKm
> LP2CFqMeEXMbLBEI6wXJrznxlcINwkQzYlX7EAbXzD4tOookS9wYhBeXi+3Yjugp
> JbMUzIxOVKDzi2W8WYVRPhnhxSjVe5CVsQ32ghlwPEwzbMAgVcoQ7cwZ9r9l1Pg1
> Z8GMiAk4Ui9m+TlKbW5N1r2RgSKLdhk4yUETgr+ykkyaMhc8Wt46vM1bdGjIgX6W
> CCj/BHcM5IdLb56m1L0wiG82dftYlBNfu3hAlnoJls1GiVtRg5Ph5Dit+t2xH3Kh
> GpS9r9HhzqbA3tjv4NSR6oRj5UXc/mu1qj93CFoGPf6ZwC5QiHWOMbeegLJxOXVK
> yuIK1gl3ehTQhgcB+B2wK+0Id3gtcwOmzdzM3by2aSH+glfpwH3vRlYPLVUpAUf9
> 7oNuMVwhGHFRKL+PF5o0hVldI/jFF2TqLdiQilTe4pfsRGKslgRJce0TIZT5ZSm5
> jsQ2nCm1En7b+HW2hOeh2JjRkwwLqa5XIu7pjB2TVY1vhIJkdXs=
> =aQz0
> -END PGP SIGNATURE-
>
> -
> To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
> For additional commands, e-mail: users-h...@tomcat.apache.org
>
>
> -
>>> To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
>>> For additional commands, e-mail: users-h...@tomcat.apache.org
>>>
>>>
>>>
>
> -
> To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
> For additional commands, e-mail: users-h...@tomcat.apache.org
>
>


Re: tomcat with laptop + windows sleep

2018-06-03 Thread Felix Schumacher




Am 02.06.2018 um 20:51 schrieb Alex O'Ree:

I think I've narrowed it down to an issue specific with terracotta quartz
based jobs. I've wired it into using tomcat's jdbc connection pooling. I'm
also using a super
old version of it so that could be part of the problem. Interestingly this
didn't happen with tomcat7 but it's more than probably some other change on
my
end caused this rather strange situation.  Anyhow, it's probably not tomcat.


You copied the jdbc pool jars from tomcat 7 into tomcat 8.5? Why?



Context.xml is something like this





You could enable validation queries, so that the pool will check the 
connections validity before handing it out to your application.


Regards,
 Felix


The encrypted connection factory extends the default one and supports a
basic ciphered password




On Sat, Jun 2, 2018, 1:34 PM Felix Schumacher  wrote:



Am 24. Mai 2018 23:30:10 MESZ schrieb Alex O'Ree :

Yes it is a tomcat managed data source with postgres. The cpu usage is
my
app trying to get a managed data source. Perhaps the jdbc driver is the
issue. ..

Care to post your configuration? Maybe there are some changes missing when
you updated to the newer version.

Regards,
  Felix


On Wed, May 23, 2018, 11:28 AM Christopher Schultz <
ch...@christopherschultz.net> wrote:


-BEGIN PGP SIGNED MESSAGE-
Hash: SHA256

Alex,

On 5/22/18 7:39 PM, Alex O'Ree wrote:

I've noticed a behavioral difference from tomcat 7 to 8.5. In v7, I
used to be able to put a computer to "sleep" with tomcat running.
On resume, everything would be just fine. On tomcat 8.5, i'm
noticing that all database connections are basically dropped and do
not appear to to restart/resume when the computer resumes. Actually
the whole computer runs super slow until i kill the tomcat process.
I'm not entirely sure what's going on here. Has anyone else noticed
this kind of behavior?

Are you using a tomcat-configured DataSource in your application? If
so, what does the configuration look like?

I wouldn't expect any problems with sleep. I'm using Tomcat 8.5.29 on
MacOS and I haven't noticed any problems when my laptop goes to

sleep.

I'm using Oracle Java 1.8.0_131 in this particular case.

When it's running slowly, can you tell which process is taking up all
the CPU (or disk)? Try using the Process Explorer to single-out a
process. If it's Tomcat (java.exe), take a thread dump to see what
Tomcat is doing.

- -chris
-BEGIN PGP SIGNATURE-
Comment: GPGTools - http://gpgtools.org
Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/

iQIzBAEBCAAdFiEEMmKgYcQvxMe7tcJcHPApP6U8pFgFAlsFiIkACgkQHPApP6U8
pFi70g/8D9R8EkjpCeNziAUeQmWwxHwui+jbOd1rGjG7EID21mmmJJgw5IO1O8ok
F7GUWC8KloqFJ59m+Ib/3NCL5QkiuE/X++AyvDxgwuI1eqlxi86Gu7Jxw6wsfUj2
K1Ovp+jUeNEhuxPfx7zBiHXQPa1kN+B7ExxOyVEeybRalF27hlums2zF6IlC4VKm
LP2CFqMeEXMbLBEI6wXJrznxlcINwkQzYlX7EAbXzD4tOookS9wYhBeXi+3Yjugp
JbMUzIxOVKDzi2W8WYVRPhnhxSjVe5CVsQ32ghlwPEwzbMAgVcoQ7cwZ9r9l1Pg1
Z8GMiAk4Ui9m+TlKbW5N1r2RgSKLdhk4yUETgr+ykkyaMhc8Wt46vM1bdGjIgX6W
CCj/BHcM5IdLb56m1L0wiG82dftYlBNfu3hAlnoJls1GiVtRg5Ph5Dit+t2xH3Kh
GpS9r9HhzqbA3tjv4NSR6oRj5UXc/mu1qj93CFoGPf6ZwC5QiHWOMbeegLJxOXVK
yuIK1gl3ehTQhgcB+B2wK+0Id3gtcwOmzdzM3by2aSH+glfpwH3vRlYPLVUpAUf9
7oNuMVwhGHFRKL+PF5o0hVldI/jFF2TqLdiQilTe4pfsRGKslgRJce0TIZT5ZSm5
jsQ2nCm1En7b+HW2hOeh2JjRkwwLqa5XIu7pjB2TVY1vhIJkdXs=
=aQz0
-END PGP SIGNATURE-

-
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org



-
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org





-
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org