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_447.diff
        12 kB
        Heath Kesler
      2. karaf-2.3_447.diff
        11 kB
        Heath Kesler
      3. updated-karaf-3.0_447.diff
        3 kB
        Heath Kesler

        Issue Links

          Activity

          Gert Vanthienen created issue -
          Jamie goodyear made changes -
          Field Original Value New Value
          Fix Version/s 2.2.1 [ 12316164 ]
          Fix Version/s 3.0.0 [ 12316040 ]
          Fix Version/s 2.2.0 [ 12315328 ]
          Jamie goodyear made changes -
          Fix Version/s 2.2.2 [ 12316339 ]
          Fix Version/s 2.2.1 [ 12316164 ]
          Jamie goodyear made changes -
          Fix Version/s 2.2.3 [ 12316685 ]
          Fix Version/s 2.2.2 [ 12316339 ]
          Jean-Baptiste Onofré made changes -
          Fix Version/s 3.1.0 [ 12316946 ]
          Fix Version/s 3.0.0 [ 12316040 ]
          Fix Version/s 2.2.3 [ 12316685 ]
          Heath Kesler made changes -
          Attachment karaf_447.diff [ 12538645 ]
          Jamie goodyear made changes -
          Assignee Jamie goodyear [ jgoodyear ]
          Jamie goodyear made changes -
          Fix Version/s 2.2.9 [ 12321741 ]
          Fix Version/s 2.3.0 [ 12320554 ]
          Fix Version/s 3.0.0 [ 12316040 ]
          Jamie goodyear made changes -
          Fix Version/s 3.1.0 [ 12316946 ]
          Heath Kesler made changes -
          Link This issue blocks KARAF-1700 [ KARAF-1700 ]
          Heath Kesler made changes -
          Attachment updated-karaf-3.0_447.diff [ 12538870 ]
          Heath Kesler made changes -
          Attachment karaf-2.3_447.diff [ 12538945 ]
          Heath Kesler made changes -
          Attachment karaf-2.3_447.diff [ 12538945 ]
          Heath Kesler made changes -
          Attachment karaf-2.3_447.diff [ 12538961 ]
          Jamie goodyear made changes -
          Status Open [ 1 ] Resolved [ 5 ]
          Resolution Fixed [ 1 ]
          Jamie goodyear made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Gavin made changes -
          Link This issue blocks KARAF-1700 [ KARAF-1700 ]
          Gavin made changes -
          Link This issue is depended upon by KARAF-1700 [ KARAF-1700 ]

            People

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

              Dates

              • Created:
                Updated:
                Resolved:

                Development