On Mon, Jul 13, 2009 at 2:35 PM, Andrew Feller <[email protected]> wrote:
> QUESTIONS: > > > 1. Has anyone used SQLite or H2 with the Service Management portion of > CAS? > > Sorry, I've only tried it with MySql, Posgres and Oracle, though if Hibernate supports it, it should work. > > 1. > 2. Is it recommended to use HSQL over SQLite and H2? > 3. How does the JPA backed Service Management registry work in a > replicated environment? > > You just enable it and then use a Quartz job or timer to enable the reloader (Marvin offered to document this in another thread) > > THOUGHTS: > > > 1. Service registry should be replicated in a replicated CAS > environment incase it is unavailable > > Yes, if you're concerned about that then technically your DB should be replicated. Cheers, Scott > 1. > 2. It seems like HSQLDB/R is an experiment by Jgroups (the same tool > used by JBoss Cache) to add replication to HSQLDB using 1.7.1 alpha and not > formally accepted by HSQLDB > 3. SQLite does not officially handle replication; deployers must design > custom synchronization job via script and rsync > > > REFERENCES: > > - H2 - http://en.wikipedia.org/wiki/H2_%28DBMS%29 > - SQLite - http://en.wikipedia.org/wiki/SQLite > - HSQLDB/R - http://www.jgroups.org/hsqldbr/design.doc > > > Thanks for any thoughts / insights, > A- > -- > Andrew Feller, Analyst > LSU University Information Services > 200 Frey Computing Services Center > Baton Rouge, LA 70803 > Office: 225.578.3737 > Fax: 225.578.6400 > > -- > You are currently subscribed to [email protected] as: > [email protected] > > To unsubscribe, change settings or access archives, see > http://www.ja-sig.org/wiki/display/JSG/cas-user > > -- You are currently subscribed to [email protected] as: [email protected] To unsubscribe, change settings or access archives, see http://www.ja-sig.org/wiki/display/JSG/cas-user
