Karaf
  1. Karaf
  2. KARAF-447

Add JDBC lock implementation for PostgreSQL

    Details

    • Type: Improvement Improvement
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 2.1.3
    • Fix Version/s: 2.2.9, 2.3.0, 3.0.0
    • Component/s: karaf-core
    • Labels:
      None

      Description

      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.

      1. karaf-2.3_447.diff
        11 kB
        Heath Kesler
      2. updated-karaf-3.0_447.diff
        3 kB
        Heath Kesler
      3. karaf_447.diff
        12 kB
        Heath Kesler

        Issue Links

          Activity

          No work has yet been logged on this issue.

            People

            • Assignee:
              Jamie goodyear
              Reporter:
              Gert Vanthienen
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development