Hi, I'm back again with the problem :)
Firstly, I add the validationQuery and it works and I can see it in postgres logs. But still not able to login after a while of inactivity.... Now, after 15 min of waiting, I'm getting a socket connexion timeout, but seems logic after such a long period of trying to connect. Thank you again for your ideas and haven't found a solution. Regards, Luc. ________________________________________ De : Konstantin Kolinko <knst.koli...@gmail.com> Envoyé : mardi 3 février 2015 12:33 À : Tomcat Users List Objet : Re: JDBC authentication problem 2015-02-03 14:29 GMT+03:00 Luc DALLEMANE <ldallem...@alaloop.com>: > Hi, > > Thanks for the reply, I tried to add the options you told me about > (testWhileIdle, timeBetweenEvictionRunsMillis, and maxConnLifetimeMillis), > but I'm still unable to log after un hour ... Do you have validationQuery configured? testOnBorrow, testWhileIdle do not work without it. Best regards, Konstantin Kolinko --------------------------------------------------------------------- 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