Concretely if testOnBorrow doesnt work the issue is far more than a cluster problem cause even with a single instance it should be fine.
Did you manage to jstack the JVM when it happens? Romain Manni-Bucau @rmannibucau <https://twitter.com/rmannibucau> | Blog <https://blog-rmannibucau.rhcloud.com> | Old Blog <http://rmannibucau.wordpress.com> | Github <https://github.com/rmannibucau> | LinkedIn <https://www.linkedin.com/in/rmannibucau> | JavaEE Factory <https://javaeefactory-rmannibucau.rhcloud.com> 2016-11-23 15:27 GMT+01:00 Edouard LAMOTTE <[email protected]>: > Hi Romain, > > i did a mistake, you're right i use tomcat-jdbc. > > I thought that remove connection (timeBetweenEvictionRunsMillis>0 and > removeAbandoned=true and removeAbandonedTimeout>0 ) > and validating a new connection (testOnBorrow="true" > validationQuery="select 1 from dual") was enough > but in my case it doesn't work. > > Regards > > > > ----- Mail original ----- > De: "Romain Manni-Bucau" <[email protected]> > À: [email protected] > Envoyé: Mardi 22 Novembre 2016 17:55:39 > Objet: Re: FailOver TomEE/Oracle > > I think you dont use dbcp but tomcat-jdbc. DataSourceCreator=dbcp would use > dbcp. That said if the pool eviction is well set it should run and evict N > connections each T minutes so it should work even without reconnection > features. The testOnBorrow should also ensure you always have a valid > connection. > > > Romain Manni-Bucau > @rmannibucau <https://twitter.com/rmannibucau> | Blog > <https://blog-rmannibucau.rhcloud.com> | Old Blog > <http://rmannibucau.wordpress.com> | Github <https://github.com/ > rmannibucau> | > LinkedIn <https://www.linkedin.com/in/rmannibucau> | JavaEE Factory > <https://javaeefactory-rmannibucau.rhcloud.com> > > 2016-11-22 17:44 GMT+01:00 Edouard LAMOTTE <[email protected]>: > > > Hi Romain, > > > > yes it is the same url for websphere. > > > > I checked my datasource's config with jmx, > > every parameters of my DataSource are set correctly. > > > > > > ----- Mail original ----- > > De: "Romain Manni-Bucau" <[email protected]> > > À: [email protected] > > Envoyé: Mardi 22 Novembre 2016 17:09:24 > > Objet: Re: FailOver TomEE/Oracle > > > > hello > > > > is it the exact same url for websphere? did you check your datasource > > config throught jmx? > > > > > > Romain Manni-Bucau > > @rmannibucau <https://twitter.com/rmannibucau> | Blog > > <https://blog-rmannibucau.rhcloud.com> | Old Blog > > <http://rmannibucau.wordpress.com> | Github <https://github.com/ > > rmannibucau> | > > LinkedIn <https://www.linkedin.com/in/rmannibucau> | JavaEE Factory > > <https://javaeefactory-rmannibucau.rhcloud.com> > > > > 2016-11-22 17:05 GMT+01:00 Edouard LAMOTTE <[email protected]>: > > > > > Hi, > > > > > > > > > i'm facing a problem of reconnection with TomEE on Oracle Exadata. > > > > > > > > > We have an application server TomEE 1.7.2 connected on Oracle Database > > > Exadata (two nodes active/passive). > > > > > > > > > We are trying to test the automatic reconnection between tomEE and the > > > Database when the active node falls. > > > When the first node falls, we start the second, but TomEE's datasource > > > can't establish a new connection without restarting the server. > > > > > > It works on IBM Websphere, we don't need to restart the server, it's > > > transparent for users. So we want to do the same with TomEE, > > > But i don't know if it can work with TomEE and DBCP. > > > > > > > > > I use configuration parameters like testOnBorrow, validationQuery and > > > others as you can see below. > > > > > > Here my tomee.xml : > > > > > > <tomee> > > > ... > > > > > > <Resource id="jdbc/xxxxx" type="javax.sql.DataSource"> > > > > > > JdbcDriver=oracle.jdbc.OracleDriver > > > > > > JdbcUrl=jdbc:oracle:thin:@(DESCRIPTION=(FAILOVER=on)( > > > ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=XXX1)(PORT= > > > 1523))(ADDRESS=(PROTOCOL=TCP)(HOST=XXX2)(PORT=1523)))( > > > CONNECT_DATA=(SERVICE_NAME=APP_XXXX))) > > > > > > UserName=XXX > > > Password=XXX > > > > > > testWhileIdle=true > > > testOnBorrow=true > > > testOnReturn=true > > > validationQuery=SELECT 1 FROM DUAL > > > validationInterval=3 > > > timeBetweenEvictionRunsMillis=3 > > > maxActive=10 > > > minIdle=10 > > > maxWait=10 > > > initialSize=10 > > > removeAbandonedTimeout=5 > > > removeAbandoned=true > > > logAbandoned=true > > > minEvictableIdleTimeMillis=30000 > > > > > > </Resource> > > > > > > > > > </tomee> > > > > > > > > > Any ideas/suggestions? > > > > > > > > > Thanks for your help. > > > > > > > > > Regards. > > > > > > > > > > > > > > >
