Run time error at FTP polling


Sometimes when the SFTP polling is going on we are getting the below error. When we re-run the process its executes normally.


java.sql.SQLException: Already closed.


Cause:The connection to the backend database has automatically been closed


The SQL already closed issue can be resolved by enabling the "testOnBorrow" and "validationQuery" property for connection pooling.These will ensure that the connection is active and is not closed.


Administer > Setup > Application Settings > Update System Properties > Performance Optimization > Backend Database > Backend Connection Pooling


In ‘validationQuery’ field you can provide a simple query to check that the connection that is used to backend is active. Below query can be used:

select * from dual
Have more questions? Submit a request


Article is closed for comments.