Team,
My application is running on resin-pro-4.0.41 with below DB configuration in resin-web.xml <database name="jdbc/hibernate"> <jndi-name>jdbc/hibernate</jndi-name> <driver type="oracle.jdbc.pool.OracleConnectionPoolDataSource"> <url>jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = xxxxx.yyyyy.in)(PORT = 1527))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = XXXXXXXX)))</url> <user>xxxx</user> <password>xxxxx</password> </driver> <max-create-connections>400</max-create-connections> <max-connections>1000</max-connections> <max-overflow-connections>50</max-overflow-connections> <ping-table>dual</ping-table> <ping-interval>5</ping-interval> <ping>true</ping> <prepared-statement-cache-size>50</prepared-statement-cache-size> </database> Ping interval is set 5 mins to keep the connection alive with Database and Database side 10 Min is set as Max_Idle_Time but still application is encountering below error: [17-11-15 13:12:18.660] {resin-port-8443-76} ORA-02396: exceeded maximum idle time, please connect again I am suspecting the ping configuration is not working, Any suggestion to check/validate this configuration or any suggestions? Regards, Abhishek | HP: +91-8130370104 | Email: <mailto:abhisheksi...@nmsworks.co.in> abhisheksi...@nmsworks.co.in NMSWorks Software PVT LTD | #C3, IITM Research Park, Taramani, Chennai, India - 600113 | --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus
_______________________________________________ resin-interest mailing list resin-interest@caucho.com http://maillist.caucho.com/mailman/listinfo/resin-interest