title: spring 2.5 hibernate mysql - two databases transaction
body: <p>My application is a spring 2.5 Hibernate application connected to a mysql database (database name=mydb). The application is hosted on Tomcat 6 - running on java 6. I have a use case where an admin can edit user's profile. I am planning to store the history of these edits in a separate database (on the same mysql server - database namne= archivedb). In this case the edit user functionality spans over two databases in the same mysql database. Do I need to use JTA transaction. IF JTA, which implementation is the best one . I prefer open source one.</p>
  
  <p>Santhosh</p>