james-server-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF GitHub Bot (JIRA)" <server-...@james.apache.org>
Subject [jira] [Commented] (JAMES-2386) Data Source Pool is not validating connections
Date Tue, 08 May 2018 02:19:00 GMT

    [ https://issues.apache.org/jira/browse/JAMES-2386?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16466751#comment-16466751
] 

ASF GitHub Bot commented on JAMES-2386:
---------------------------------------

Github user chibenwa commented on the issue:

    https://github.com/apache/james-project/pull/113
  
    Hi,
    
    This pull request has just been merged.
    
    Thank you again for your dedication toward the James project. If you need help, want to
[contribute](https://issues.apache.org/jira/issues/?jql=project%20%3D%20JAMES%20AND%20resolution%20%3D%20Unresolved%20AND%20labels%20%3D%20newbie%20ORDER%20BY%20priority%20DESC%2C%20updated%20DESC)
[documentation](https://issues.apache.org/jira/issues/?jql=project%20%3D%20JAMES%20AND%20resolution%20%3D%20Unresolved%20AND%20labels%20%3D%20documentation%20ORDER%20BY%20priority%20DESC%2C%20updated%20DESC),
new [features](https://issues.apache.org/jira/issues/?jql=project%20%3D%20JAMES%20AND%20resolution%20%3D%20Unresolved%20AND%20labels%20%3D%20feature%20ORDER%20BY%20priority%20DESC%2C%20updated%20DESC),
tests or [bugfix](https://issues.apache.org/jira/issues/?jql=project%20%3D%20JAMES%20AND%20resolution%20%3D%20Unresolved%20AND%20labels%20%3D%20easyfix%20ORDER%20BY%20priority%20DESC%2C%20updated%20DESC),
please don't hesitate to reach us.
    
    One very last thing: I don't have write access to this repository, hence I can not close
this issue. Wouldn't you mind doing it for me? It would avoid me annoying the Apache INFRA
team with such simple concerns.
    
    Thanks again,
    
    Cheers,
    
    Benoit


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


Mime
View raw message