Fadi, thanks for your super quick response! I am using Tomcat 5.0.28. Just a couple of followup questions: -What exactly is the userTransactionName you are setting in the JtaTransactionManager? -How does the transactionManager know that each save method from each session factory needs to be executed before a commit? (is it becuase of the configuration in txProxyTemplate?) -When I actually implement this, will I be placing 3 dao "saves" within one manager method?
Thanks again. -Zak Fadi Samara wrote: > > Zakir, > > You could do something like this > > > <bean id="yourTransactionManager" class=" > org.springframework.transaction.jta.JtaTransactionManager"> > <property name="transactionManagerName" > value="java:/TransactionManager"></property> > <property name="userTransactionName" value="UserTransaction"></property> > </bean> > > and in you SFs you do: > > <property name="jtaTransactionManager"> > <bean factory-bean="coreTransactionManager" > factory-method="getTransactionManager"/> > </property> > What app server are you using ? > > Thanks > Fadi > > > On 12/19/06, Zakir <[EMAIL PROTECTED]> wrote: >> >> >> Hello Experts. Hope all is Well. >> >> I am having a problem with transaction management. Basically, I have >> three >> databases, located on 3 different servers that have to be synchronized >> with >> identical tables at all times. To access these databases through my >> appfuse >> app, I have created 3 dataSource beans, and 3 sessionFactory beans >> respectively. My problem is trying to manage a transaction (such as >> saveRecord, which will save the same record on all three databases.) I >> have >> done some reading, and it looks like I need to use JtaTransactionManager, >> instead of HibernateTransactionManager (to support distributed >> databases). >> How do I configure this JtaTransactionManager, and more specifically, how >> do >> I assign multiple session factories to it? >> >> Thanks in advance, >> -Zak >> -- >> View this message in context: >> http://www.nabble.com/JTA-Transaction-Manager-Distributed-Database-tf2846792s2369.html#a7949746 >> Sent from the AppFuse - User mailing list archive at Nabble.com. >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: [EMAIL PROTECTED] >> For additional commands, e-mail: [EMAIL PROTECTED] >> >> > > -- View this message in context: http://www.nabble.com/JTA-Transaction-Manager-Distributed-Database-tf2846792s2369.html#a7950718 Sent from the AppFuse - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
