Emir, for this to work you will have to makes use of a transaction manager/coordinator that supports 2PC (two phase commit), a protocol that guaranteees exectly what you are askig for.
In the context of (commercial) web/ejb containers, most major players thee days ship a fully-fledged transaction monitor with their respective products. In the open source world, you could e.g. use Tyrex with e.g. Catalina/Tomcat. Whilst setup is not that difficult, you should have a genral understanding of the involved protocols, APIs (e.g. Sun's JTA), etc. Regards Werner > Hi, > I have some kind of archiving from production to archive database in my > to-be-developed app. > Since I'm using Castor for data services, I was wondering how can I make > these cross-database transactions. > Basically, I want to load an object from production database and .create() > it in archive and the .remove() it in the production database. > I need some means of keeping databases consistent, i.e. if the remove() > fails (administrator stops the archiving or whatever...) I want the create() > to be rolledback too. > > What's the best way to do this? > Is there any way to do this successfully without employing external > transaction manager? > I would really like to have only castor for my data services... > > > > ----------------------------------------------------------- > If you wish to unsubscribe from this mailing, send mail to > [EMAIL PROTECTED] with a subject of: > unsubscribe castor-user > -- NEU +++ DSL Komplett von GMX +++ http://www.gmx.net/de/go/dsl GMX DSL-Netzanschluss + Tarif zum superg�nstigen Komplett-Preis! ----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to [EMAIL PROTECTED] with a subject of: unsubscribe castor-user
