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
>
>