Simon Levesque created JAMES-2386:
-------------------------------------
Summary: Data Source Pool is not validating connections
Key: JAMES-2386
URL: https://issues.apache.org/jira/browse/JAMES-2386
Project: James Server
Issue Type: Improvement
Components: JDBC, jpa
Affects Versions: master
Reporter: Simon Levesque
Fix For: master
I was seeing a couple exceptions in different calls: * Getting the list of
emails via imap
* Reading the emails via imap
* Sending emails
* Resolving the rewrite table
* even in my personal mailet
The only thing in common was the "cause" of the exception:
{noformat}
Caused by: java.sql.SQLNonTransientConnectionException: (conn=17) unexpected
end of stream, read 0 bytes from 4 (socket was closed by server){noformat}
I found that there must be an issue with the configuration of the
BasicDataSource and I saw these properties are not set and cannot be set:
{code:java}
basicDataSource.setTestOnBorrow(true);
basicDataSource.setValidationQuery("select 1"); // Is different by database.
See list here:
https://stackoverflow.com/questions/10684244/dbcp-validationquery-for-different-databases
basicDataSource.setValidationQueryTimeout(2);{code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: server-dev-unsubscr...@james.apache.org
For additional commands, e-mail: server-dev-h...@james.apache.org
