GateIn connection with oracle gets dropped off

[poornima.abhi]

Hi All,

I have a web application deployed in GateIn 3.2 which is connected to Oracle 10g hosted in another machine. It is working fine.The issue happens when the oracle machine is down and even after machine is up, GateIn is unable to get connected to Oracle.When I login to the application, i get the message like 'username or password does not exist'. I will have to restart Gatein to fit everything into place.Is there any solution to fix this?Without restarting GateIn, is it possible to fix this??

Thanks in advance,

Poornima

[rdenarie]

Hello,

I dont know if you use Jboss or tomcat, but you should search about validationQuery parameter :

http://stackoverflow.com/questions/128527/is-there-any-way-to-have-the-jboss-connection-pool-reconnect-to-oracle-when-conn