[jira] [Created] (JAMES-2386) Data Source Pool is not validating connections

["Simon Levesque (JIRA)" <se...@james.apache.org>]

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-unsubscribe@james.apache.org
For additional commands, e-mail: server-dev-help@james.apache.org