SQLException: ORA-02396: exceeded maximum idle time

Hi Team,
I tried to push bulk data using logstash configuration file.I have given all database connection related parameters and query but after sometime connection closed and getting below exception:

Exception when executing JDBC query {:exception=>#<Sequel::DatabaseError: Java::JavaSql::SQLException: ORA-02396: exceeded maximum idle time, please connect again


How to resolve it.

It looks like the server is closing the idle connection. Isn't Logstash reconnecting as it should, or what's the real problem here?

Try version 4.3.1 of the JDBC input plugin. It was recently (22 days ago) patched to open and close a connection for each query.

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.