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:[email protected]> [email protected]
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
[email protected]
http://maillist.caucho.com/mailman/listinfo/resin-interest
