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 >> >> >> <Resource name="jdbc/myDataSourceName" auth="Container" >> type="javax.sql.DataSource" >> maxActive="50" maxIdle="30" maxWait="10000" >> 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 <felix.schumacher@ >> internetallee.de> wrote: >> >> >>> Am 24. Mai 2018 23:30:10 MESZ schrieb Alex O'Ree <alexo...@apache.org>: >>> >>>> 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 > >