[jira] [Commented] (JCR-3445) PostgreSQL error with setValidationQueryTimeout

["Bart van der Schans (JIRA)" <ji...@apache.org>]

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

Bart van der Schans commented on JCR-3445:
------------------------------------------

Hi Luca,

I suspect you have configured a validation timeout on the datasource itself in the dbcp settings. Can you check that?

Bart
                
> PostgreSQL error with setValidationQueryTimeout
> -----------------------------------------------
>
>                 Key: JCR-3445
>                 URL: https://issues.apache.org/jira/browse/JCR-3445
>             Project: Jackrabbit Content Repository
>          Issue Type: Bug
>          Components: jackrabbit-core
>    Affects Versions: 2.4.3, 2.5.2
>         Environment: Linux Ubuntu 10.04 server with PostgreSQL 9.1 remote DB
>            Reporter: Luca Tagliani
>            Assignee: Bart van der Schans
>            Priority: Critical
>             Fix For: 2.4.4, 2.5.3
>
>         Attachments: catalina.out, JCR-3445.patch
>
>
> In this version inside o.a.j.c.util.db.ConnectionFactory class, it's been added a validationQueryTimeout (line 344).
> The problem is that the use of queryTimeout is not implemented in any PostgreSQL jdbc driver (see http://jdbc.postgresql.org/todo.html Compliance section)

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira