I've configured xPetstore to run using MySQL. Unfortunately, the problem wasn't solved. When one instance of xpetstore is undeployed all tables are removed and the other instances don't function correctly anymore. If you have another clue, please, let me know! Thanks a lot, Raquel
----- Original Message ----- From: "Rod Macpherson" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, December 16, 2003 10:24 AM Subject: RE: [JBoss-user] CMP, multiple workers and shared DB (help me!) Can you not use a database that persists to secondary storage such as MySQL? That would certainly solve your problem. -----Original Message----- From: Raquel V. Lopes [mailto:[EMAIL PROTECTED] Sent: Tue 12/16/2003 5:05 AM To: [EMAIL PROTECTED] Cc: Subject: [JBoss-user] CMP, multiple workers and shared DB (help me!) Hello! I am running xPetStore (that uses CMP) implementation at JBoss 3.0.7. I have multiple workers (JBoss machines) that shares the same database. The database I am using is the Hypersonic that comes with JBoss. I am also using Apache+mod_jk to load balancing requests among the workers. I need to - on the fly - stop some instances of JBoss, and then, start them again. But, when a JBoss instances dies (shutdown on JBoss) all the database is removed and the other instances aren't able to correctly continue to serve client requests. How could I prevent the database to be deleted when one JBoss xpetstore instance is undeployed? Thanks a lot, Raquel ------------------------------------------------------- This SF.net email is sponsored by: IBM Linux Tutorials. Become an expert in LINUX or just sharpen your skills. Sign up for IBM's Free Linux Tutorials. Learn everything from the bash shell to sys admin. Click now! http://ads.osdn.com/?ad_id=1278&alloc_id=3371&op=click _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
