karaf-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Gert Vanthienen (JIRA)" <j...@apache.org>
Subject [jira] Created: (KARAF-447) Add JDBC lock implementation for PostgreSQL
Date Mon, 07 Feb 2011 12:36:30 GMT
Add JDBC lock implementation for PostgreSQL

                 Key: KARAF-447
                 URL: https://issues.apache.org/jira/browse/KARAF-447
             Project: Karaf
          Issue Type: Improvement
          Components: runtime
    Affects Versions: 2.1.3
            Reporter: Gert Vanthienen
             Fix For: 2.2.0

When using the org.apache.karaf.main.DefaultJDBCLock class together with PostgreSQL, you can
run into this exception (caused by the setQueryTimeout() method not being implemented yet
- http://jdbc.postgresql.org/todo.html):

Failed to acquire database lock: org.postgresql.util.PSQLException: Method org.postgresql.jdbc4.Jdbc4PreparedStatement.setQueryTimeout(int)
is not yet implemented.

We should at the very least document that the timeout should be set to 0 for PostgreSQL, but
perhaps we'd better create a new JDBC lock implementation that hides this bit of knowledge
from the users and provides them with a nice and easy way to use PostgreSQL for JDBC locking.

This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira


View raw message