[
https://issues.apache.org/jira/browse/KARAF-447?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13427674#comment-13427674
]
Jamie goodyear commented on KARAF-447:
--------------------------------------
Check in on 2.3.x branch
$ svn ci
Adding main/src/main/java/org/apache/karaf/main/PostgreSQLJDBCLock.java
Adding
main/src/test/java/org/apache/karaf/main/PostgreSQLJDBCLockIntegrationTest.java
Adding
main/src/test/java/org/apache/karaf/main/PostgreSQLJDBCLockTest.java
Transmitting file data ...
Committed revision 1368742.
> Add JDBC lock implementation for PostgreSQL
> -------------------------------------------
>
> Key: KARAF-447
> URL: https://issues.apache.org/jira/browse/KARAF-447
> Project: Karaf
> Issue Type: Improvement
> Components: karaf-core
> Affects Versions: 2.1.3
> Reporter: Gert Vanthienen
> Assignee: Jamie goodyear
> Fix For: 2.2.9, 2.3.0, 3.0.0
>
> Attachments: karaf-2.3_447.diff, karaf_447.diff,
> updated-karaf-3.0_447.diff
>
>
> 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):
> {noformat}
> Failed to acquire database lock: org.postgresql.util.PSQLException: Method
> org.postgresql.jdbc4.Jdbc4PreparedStatement.setQueryTimeout(int) is not yet
> implemented.
> {noformat}
> 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.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
