Hello Zaizi,Thank you very much for your reply. I have extended Alfresco to develop a dossiers management application. I have used a different database to store other information outside Alfresco. Now I have a doubt about the transaction manage. The services of the new application uses services of Alfresco.This new services are configured to connect new database and use a different SessionFactory and TransactionManager than Alfresco services. The problem is when an error occurs in the new database, the rollback is done in the new database but not in Alfresco.This is the new configuration:The TransactionManager bean<bean id="transactionManagerNew" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
<property name="transactionSynchronizationName">
<value>SYNCHRONIZATION_ALWAYS</value>
</property>
<property name="sessionFactory">
<ref bean="sessionFactoryNew" />
</property>
</bean>
The SessionFactory bean<bean id="sessionFactoryNew" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="dataSource"><ref local="myDataSource" /></property>
<!– Must references all OR mapping files. –>
<property name="mappingResources">
<list>
<value>org/new/hibernate/mapping/Dossier.hbm.xml</value>
…
</list>
</property>
<property name="schemaUpdate"><value>false</value></property>
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">org.hibernate.dialect.MySQLInnoDBDialect</prop>
<prop key="hibernate.connection.pool_size">1</prop>
<prop key="hibernate.hbm2ddl.auto">false</prop>
<prop key="hibernate.show_sql">false</prop>
</props>
</property>
</bean>
The new services are configured with:<property name="transactionManager"><ref local="transactionManagerNew"/></property>
How can I configure the transactionManager to use one transaction to connect two databases? Is it posible?How can I configure to do rollback in two databases when an error occurs?Thank you very much in advance,
