svn commit: r1368408 - /karaf/trunk/manual/src/main/webapp/users-guide/failover.conf

[jg...@apache.org]

Author: jgoodyear
Date: Thu Aug  2 10:30:26 2012
New Revision: 1368408

URL: http://svn.apache.org/viewvc?rev=1368408&view=rev
Log:
[KARAF-1700] update manual to reflect JDBC Lock updates

Update to locking manual. Thank you for the patch Heath Kesler.


Modified:
    karaf/trunk/manual/src/main/webapp/users-guide/failover.conf

Modified: karaf/trunk/manual/src/main/webapp/users-guide/failover.conf
URL: http://svn.apache.org/viewvc/karaf/trunk/manual/src/main/webapp/users-guide/failover.conf?rev=1368408&r1=1368407&r2=1368408&view=diff
==============================================================================
--- karaf/trunk/manual/src/main/webapp/users-guide/failover.conf (original)
+++ karaf/trunk/manual/src/main/webapp/users-guide/failover.conf Thu Aug  2 10:30:26 2012
@@ -57,7 +57,7 @@ Otherwise, configure the system.properti
 
 {noformat}
 karaf.lock=true
-karaf.lock.class=org.apache.karaf.main.OracleJDBCLock
+karaf.lock.class=org.apache.karaf.main.lock.OracleJDBCLock
 karaf.lock.jdbc.url=jdbc:oracle:thin:@hostname:1521:XE
 karaf.lock.jdbc.driver=oracle.jdbc.OracleDriver
 karaf.lock.jdbc.user=user
@@ -73,15 +73,61 @@ As with the default JDBC locking setup, 
 
 h3. Derby
 
-{warning}
-TODO
-{warning}
+The same rules apply when using derby.  Make sure you have the driver jar file in the Karaf {{lib}} folder before starting Karaf.
+
+Then make you update the properties in {{$KARAF_HOME/etc/system.properties}} to look something like this example:
+
+{noformat}
+karaf.lock=true
+karaf.lock.class=org.apache.karaf.main.lock.DerbyJDBCLock
+karaf.lock.jdbc.url=jdbc:derby://127.0.0.1:1527/dbname
+karaf.lock.jdbc.driver=org.apache.derby.jdbc.ClientDriver
+karaf.lock.jdbc.user=user
+karaf.lock.jdbc.password=password
+karaf.lock.jdbc.table=KARAF_LOCK
+karaf.lock.jdbc.clustername=karaf
+karaf.lock.jdbc.timeout=30
+{noformat}
 
 h3. MySQL
 
-{warning}
-TODO
-{warning}
+Make sure you have the MySQL driver jar file in the Karaf {{lib}} folder before starting Karaf.
+
+*NOTE*: for 2.2.x, 2.3.x, 3.0.x you need to rename the MySQL Driver jar to prefix with 'karaf-' in order for karaf to pick it up, otherwise you will see karaf just hang on startup and the log will show you that it could not find the driver.
+
+Then make you update the properties in {{$KARAF_HOME/etc/system.properties}} to look something like this example:
+
+{noformat}
+karaf.lock=true
+karaf.lock.class=org.apache.karaf.main.lock.MySQLJDBCLock
+karaf.lock.jdbc.url=jdbc:mysql://127.0.0.1:3306/dbname
+karaf.lock.jdbc.driver=com.mysql.jdbc.Driver
+karaf.lock.jdbc.user=user
+karaf.lock.jdbc.password=password
+karaf.lock.jdbc.table=KARAF_LOCK
+karaf.lock.jdbc.clustername=karaf
+karaf.lock.jdbc.timeout=30
+{noformat}
+
+h3. PostgreSQL
+
+Make sure you have the PostgreSQL driver jar file in the Karaf {{lib}} folder before starting Karaf.
+
+*NOTE*: for 2.2.x, 2.3.x, 3.0.x you need to rename the PostgreSQL Driver jar to prefix with 'karaf-' in order for karaf to pick it up, otherwise you will see karaf just hang on startup and the log will show you that it could not find the driver.
+
+Then make you update the properties in {{$KARAF_HOME/etc/system.properties}} to look something like this example:
+
+{noformat}
+karaf.lock=true
+karaf.lock.class=org.apache.karaf.main.lock.PostgreSQLJDBCLock
+karaf.lock.jdbc.url=jdbc:postgresql://127.0.0.1:1527/dbname
+karaf.lock.jdbc.driver=org.postgresql.Driver
+karaf.lock.jdbc.user=user
+karaf.lock.jdbc.password=password
+karaf.lock.jdbc.table=KARAF_LOCK
+karaf.lock.jdbc.clustername=karaf
+karaf.lock.jdbc.timeout=0
+{noformat}
 
 
 {anchor:locklevel}