Details
-
Bug
-
Resolution: Done
-
Major
-
jboss-fuse-6.0
-
None
-
None
-
%
Description
MSSqlJdbcLock needs to be created to avoid multiple karaf instances attempting to become master using MS SQL Server with JTDS driver.
Karaf config:
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://x.x.x.x:1433;databaseName=evillarr
karaf.lock.jdbc.driver=net.sourceforge.jtds.jdbc.Driver
karaf.lock.jdbc.user=xxx
karaf.lock.jdbc.password=xxxx
karaf.lock.jdbc.table=KARAF_LOCK
karaf.lock.jdbc.clustername=karaf
karaf.lock.jdbc.timeout=30
fuse.log
2013-10-21 10:03:16 | WARN | Thread-28 | - - | Failed to acquire database lock: java.sql.SQLException: Line 1: FOR UPDATE clause allowed only for DECLARE CURSOR.