You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@jackrabbit.apache.org by "Luca Tagliani (JIRA)" <ji...@apache.org> on 2012/10/16 11:25:02 UTC

[jira] [Created] (JCR-3445) PostgreSQL error with set validationQueryTimeout

Luca Tagliani created JCR-3445:
----------------------------------

             Summary: PostgreSQL error with set validationQueryTimeout
                 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.5.2
         Environment: Linux Ubuntu 10.04 server with PostgreSQL 9.1 remote DB
            Reporter: Luca Tagliani
            Priority: Critical


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

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

Posted by Bart van der Schans <b....@onehippo.com>.
Hi,

As I stated in the comment below I'm a bit hesitant to add db specifics to
the ConnectionFactory, but I don't see another easy way to address the
postgres issue except for removing the "ds.setValidationQueryTimeout(3);"
line completely. For trunk we might take a route to get the settings from a
configuration file instead of hardcoding them, but for the 2.4 branch that
is probably a bit too drastic.

Any thoughts?

Bart



On Mon, Nov 19, 2012 at 12:20 PM, Bart van der Schans (JIRA) <
jira@apache.org> wrote:

>
>     [
> https://issues.apache.org/jira/browse/JCR-3445?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13500154#comment-13500154]
>
> Bart van der Schans commented on JCR-3445:
> ------------------------------------------
>
> Hi Luca,
>
> Thanks for explaining and the patch. I'm a bit hesitant to add db/postgres
> specific logic to the ConnectionFactory class. Does anybody know a way to
> detect support for the method on runtime?
>
> 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-1.patch, JCR-3445.patch,
> repositorySimple.xml
> >
> >
> > 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.htmlCompliance 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
>



-- 
Amsterdam - Oosteinde 11, 1017 WT Amsterdam
Boston - 1 Broadway, Cambridge, MA 02142

US +1 877 414 4776 (toll free)
Europe +31(0)20 522 4466
www.onehippo.com

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

Posted by "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=13502761#comment-13502761 ] 

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

Yes, looks good to me. 

Luca, can you do a quick test if the proposed patch (JCR-3445-2) works for you? 

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-1.patch, JCR-3445-2.patch, JCR-3445.patch, repositorySimple.xml
>
>
> 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

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

Posted by "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=13507241#comment-13507241 ] 

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

Committed in trunk in r1415574 and in the 2.4 branch in r1415576.
                
> 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-1.patch, JCR-3445-2.patch, JCR-3445.patch, repositorySimple.xml
>
>
> 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

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

Posted by "Bart van der Schans (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/JCR-3445?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Bart van der Schans reopened JCR-3445:
--------------------------------------

    
> 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

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

Posted by "Luca Tagliani (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/JCR-3445?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13478977#comment-13478977 ] 

Luca Tagliani edited comment on JCR-3445 at 10/18/12 1:13 PM:
--------------------------------------------------------------

Bart,
  you're welcome... but the patch for this issue is from Claus :-)

BR

Luca
                
      was (Author: luca.tagliani):
    Bart,
  you're welcome... but the patch is from Claus :-)

BR

Luca
                  
> 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: 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

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

Posted by "Claus Köll (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/JCR-3445?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13477709#comment-13477709 ] 

Claus Köll commented on JCR-3445:
---------------------------------

JCR-3386 has introduced this problem and it will be also in 2.4.4. So we must include this patch in it.

                
> 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
>            Priority: Critical
>             Fix For: 2.4.4, 2.5.3
>
>         Attachments: 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

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

Posted by "Luca Tagliani (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/JCR-3445?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13477699#comment-13477699 ] 

Luca Tagliani commented on JCR-3445:
------------------------------------

Hi Claus,
  I don't have the problem in 2.4.3 release.

BR

Luca
                
> 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
>            Priority: Critical
>
> 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

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

Posted by "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=13507239#comment-13507239 ] 

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

Thanks for testing. I'll apply the patch to trunk and the 2.4 branch.

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-1.patch, JCR-3445-2.patch, JCR-3445.patch, repositorySimple.xml
>
>
> 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

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

Posted by "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=13478949#comment-13478949 ] 

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

Merged in 2.4 in revision 1399616.
                
> 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: 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

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

Posted by "Luca Tagliani (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/JCR-3445?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13478977#comment-13478977 ] 

Luca Tagliani commented on JCR-3445:
------------------------------------

Bart,
  you're welcome... but the patch is from Claus :-)

BR

Luca
                
> 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: 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

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

Posted by "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=13478990#comment-13478990 ] 

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

Ah my mistake ;-) Thanks Claus!
                
> 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: 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

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

Posted by "Claus Köll (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/JCR-3445?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Claus Köll updated JCR-3445:
----------------------------

    Attachment: JCR-3445.patch
    
> 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
>            Priority: Critical
>         Attachments: 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

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

Posted by "Claus Köll (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/JCR-3445?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Claus Köll updated JCR-3445:
----------------------------

    Fix Version/s: 2.5.3
                   2.4.4
           Status: Patch Available  (was: Open)
    
> 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.5.2, 2.4.3
>         Environment: Linux Ubuntu 10.04 server with PostgreSQL 9.1 remote DB
>            Reporter: Luca Tagliani
>            Priority: Critical
>             Fix For: 2.4.4, 2.5.3
>
>         Attachments: 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

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

Posted by "Luca Tagliani (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/JCR-3445?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Luca Tagliani updated JCR-3445:
-------------------------------

    Attachment: JCR-3445-1.patch
    
> 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-1.patch, JCR-3445.patch, repositorySimple.xml
>
>
> 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

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

Posted by "Bart van der Schans (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/JCR-3445?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Bart van der Schans updated JCR-3445:
-------------------------------------

    Resolution: Fixed
        Status: Resolved  (was: Patch Available)
    
> 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: 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

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

Posted by "Claus Köll (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/JCR-3445?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13479621#comment-13479621 ] 

Claus Köll commented on JCR-3445:
---------------------------------

No problem .. thanks for committing ..
                
> 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: 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

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

Posted by "Claus Köll (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/JCR-3445?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Claus Köll updated JCR-3445:
----------------------------

    Attachment: JCR-3445-2.patch

Whats about this patch ? As i can see the PostgreSQL Driver will return false on jdbcCompliant().
It's also not the best solution but we have no postgres specific logic inside the ConnectionFactory.
                
> 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-1.patch, JCR-3445-2.patch, JCR-3445.patch, repositorySimple.xml
>
>
> 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

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

Posted by "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=13500154#comment-13500154 ] 

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

Hi Luca,

Thanks for explaining and the patch. I'm a bit hesitant to add db/postgres specific logic to the ConnectionFactory class. Does anybody know a way to detect support for the method on runtime?

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-1.patch, JCR-3445.patch, repositorySimple.xml
>
>
> 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

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

Posted by "Luca Tagliani (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/JCR-3445?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Luca Tagliani updated JCR-3445:
-------------------------------

    Attachment: catalina.out

Hi Bart,
  the problem occours also during cluster initialization...
See the attached log

BR

Luca
                
> 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

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

Posted by "Claus Köll (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/JCR-3445?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Claus Köll updated JCR-3445:
----------------------------

    Affects Version/s: 2.4.3
    
> 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
>            Priority: Critical
>
> 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

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

Posted by "Luca Tagliani (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/JCR-3445?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Luca Tagliani updated JCR-3445:
-------------------------------

    Summary: PostgreSQL error with setValidationQueryTimeout  (was: PostgreSQL error with set validationQueryTimeout)
    
> 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.5.2
>         Environment: Linux Ubuntu 10.04 server with PostgreSQL 9.1 remote DB
>            Reporter: Luca Tagliani
>            Priority: Critical
>
> 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

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

Posted by "Bart van der Schans (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/JCR-3445?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Bart van der Schans resolved JCR-3445.
--------------------------------------

    Resolution: Fixed
    
> 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-1.patch, JCR-3445-2.patch, JCR-3445.patch, repositorySimple.xml
>
>
> 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

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

Posted by "Luca Tagliani (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/JCR-3445?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13507237#comment-13507237 ] 

Luca Tagliani commented on JCR-3445:
------------------------------------

Hi Bart,
  yes, the last patch works fine.

BR

Luca
                
> 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-1.patch, JCR-3445-2.patch, JCR-3445.patch, repositorySimple.xml
>
>
> 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

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

Posted by "Luca Tagliani (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/JCR-3445?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Luca Tagliani updated JCR-3445:
-------------------------------

    Attachment: repositorySimple.xml

Hi Bart,
  I don't have any dbcp configuration file...
I've attached the repository configuration.

BR

Luca
                
> 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, repositorySimple.xml
>
>
> 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

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

Posted by "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=13478947#comment-13478947 ] 

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

Committed in revision 1399612 in trunk. Thanks for the patch Luca!
                
> 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: 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

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

Posted by "Luca Tagliani (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/JCR-3445?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13500139#comment-13500139 ] 

Luca Tagliani edited comment on JCR-3445 at 11/19/12 10:53 AM:
---------------------------------------------------------------

Hi all,
  the problem remains, because the setValidationQuerytimeout didn't raise any exception.
The problem arise when we try to get a connection from the configured datasource i.e. first line of method getExtraNameCharacters in ConnectionHelper.

While there's no implementation in PostgreSQL jdbc driver, I think we have to avoid the setting at all, instead of surrounding with a try...catch statement.

I submit JCR-3445-1.patch for review.

BR

Luca
                
      was (Author: luca.tagliani):
    Hi all,
  the problem remains, because the setValidationQuerytimeout didn't raise any exception.
The problem arise when we try to get a connection from the configured datasource i.e. first line of method getExtraNameCharacters in ConnectionHelper.

While there's no implementation in PostgreSQL jdbc driver, I think we have to avoid the setting at all, instead of surrounding with a try...catch statement.

I submit this patch for review.

BR

Luca
                  
> 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-1.patch, JCR-3445.patch, repositorySimple.xml
>
>
> 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

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

Posted by "Bart van der Schans (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/JCR-3445?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Bart van der Schans reassigned JCR-3445:
----------------------------------------

    Assignee: Bart van der Schans
    
> 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: 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

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

Posted by "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

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

Posted by "Luca Tagliani (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/JCR-3445?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Luca Tagliani updated JCR-3445:
-------------------------------

    Attachment: JCR-3445.patch

Hi all,
  the problem remains, because the setValidationQuerytimeout didn't raise any exception.
The problem arise when we try to get a connection from the configured datasource i.e. first line of method getExtraNameCharacters in ConnectionHelper.

While there's no implementation in PostgreSQL jdbc driver, I think we have to avoid the setting at all, instead of surrounding with a try...catch statement.

I submit this patch for review.

BR

Luca
                
> 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-1.patch, JCR-3445.patch, repositorySimple.xml
>
>
> 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

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

Posted by "Luca Tagliani (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/JCR-3445?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Luca Tagliani updated JCR-3445:
-------------------------------

    Attachment:     (was: JCR-3445.patch)
    
> 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-1.patch, JCR-3445.patch, repositorySimple.xml
>
>
> 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