[jira] [Commented] (KARAF-2523) Karaf JDBC lock doesn't work with M$ SQLServer

["Torsten Mielke (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/KARAF-2523?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14313878#comment-14313878 ] 

Torsten Mielke commented on KARAF-2523:
---------------------------------------

To benefit from this fix one needs to change 

{code}
karaf.lock.class=org.apache.karaf.main.DefaultJDBCLock
{code}

to 
{code}
karaf.lock.class=org.apache.karaf.main.SQLServerJDBCLock
{code}

> Karaf JDBC lock doesn't work with M$ SQLServer
> ----------------------------------------------
>
>                 Key: KARAF-2523
>                 URL: https://issues.apache.org/jira/browse/KARAF-2523
>             Project: Karaf
>          Issue Type: Bug
>          Components: karaf-core
>    Affects Versions: 2.3.0
>            Reporter: Jean-Baptiste Onofré
>            Assignee: Jean-Baptiste Onofré
>             Fix For: 2.4.0, 3.0.0, 2.3.4
>
>
> Using the M$ SQLServer (with jtds) as lock backend (and the Karaf default JDBC lock implementation) with this configuration:
> #setup in system.properties
>  
> karaf.lock=true
> karaf.lock.class=org.apache.karaf.main.DefaultJDBCLock
> karaf.lock.level=50
> karaf.lock.delay=10
> karaf.lock.jdbc.url=jdbc:jtds:sqlserver://xxx;databaseName=evillarr
> karaf.lock.jdbc.driver=net.sourceforge.jtds.jdbc.Driver
> karaf.lock.jdbc.user=xxx
> karaf.lock.jdbc.password=xxx
> karaf.lock.jdbc.table=KARAF_LOCK
> karaf.lock.jdbc.clustername=karaf
> karaf.lock.jdbc.timeout=30
>  
> Karaf doesn't start because it can't acquire the lock:
>  
> 2013-10-21 09:47:42 | WARN | Thread-28 | - - | Failed to acquire database lock: java.sql.SQLException: Line 1: FOR UPDATE clause allowed only for DECLARE CURSOR.
> As SQLServer doesn't support the "select ... for update" statement, we have to provide a MSSQLServerLock implementation using a different SQL query.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)