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