[ https://issues.apache.org/jira/browse/JAMES-2386?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Tellier Benoit resolved JAMES-2386. ----------------------------------- Resolution: Fixed https://github.com/apache/james-project/pull/113 solved the issue. Many thanks to Simon Levesque for the changes! > 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 > Priority: Minor > 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