svn commit: r1368747 - /karaf/branches/karaf-2.3.x/manual/src/main/webapp/users-guide/failover.conf

[jg...@apache.org]

Author: jgoodyear
Date: Thu Aug  2 22:53:13 2012
New Revision: 1368747

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

Patch care of Heath Kesler.


Modified:
    karaf/branches/karaf-2.3.x/manual/src/main/webapp/users-guide/failover.conf

Modified: karaf/branches/karaf-2.3.x/manual/src/main/webapp/users-guide/failover.conf
URL: http://svn.apache.org/viewvc/karaf/branches/karaf-2.3.x/manual/src/main/webapp/users-guide/failover.conf?rev=1368747&r1=1368746&r2=1368747&view=diff
==============================================================================
--- karaf/branches/karaf-2.3.x/manual/src/main/webapp/users-guide/failover.conf (original)
+++ karaf/branches/karaf-2.3.x/manual/src/main/webapp/users-guide/failover.conf Thu Aug  2 22:53:13 2012
@@ -73,16 +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.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 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.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 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.PostgreSQLJDBCLock
+karaf.lock.jdbc.url=jdbc:postgresql://127.0.0.1:5432/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}