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.
