[KARAF-447] Add JDBC lock implementation for PostgreSQL

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.1.3
• Fix Version/s: 2.2.9, 2.3.0, 3.0.0
• Component/s: karaf
• Assignee: Jamie Mark Goodyear
• Reporter: Gert Vanthienen
• Created: 07/Feb/11 12:36
• Updated: 14/Sep/18 08:37
• Resolved: 02/Aug/12 22:25

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.

Issue Links

• is depended upon by: KARAF-1700 update manual to reflect JDBC Lock updates