**I originally posted this to the Jencks group but perhaps this is a Tranql issue instead, so I am cross posting just in case.**
I have configured a sample application with Jencks for using a JTA TransactionManager, Outbound JMS, and Outbound JDBC. I am using Jencks 2.0, Tranql 1.4-SNAPSHOT, Tranql Connector 1.3-SNAPSHOT, ActiveMQ-4.1.0, ActiveMQ-RA-4.1.0-incubator, Spring 2.0.2, and Hibernate 3.2.1.ga. I'm currently using an Oracle 10g database for testing.
I have written three test cases, all of which involve a test method which performs one JDBC update and one JMS message send, and the method is wired via Spring AOP to participate in a transaction managed by the JTA TransactionManager configured through Jencks.
The first test case has no errors and the data should be persisted in the database and the message should go to the JMS Queue.
The second test case has a hard-coded JDBC error and so both the JDBC update and the JMS message send should be rolled back, with no data added to the database and no message in the Queue.
The third test case has a hard coded JMS error and so again both the JDBC update and the JMS message send should be rolled back, with no data added to the database and no message in the Queue.
The second and third test cases work as expected, in that the message never shows up in the ActiveMQ Queue, and the data never appears in the database. However the first test case is failing because although there are no exceptions and the message makes it to the Queue with no problem the data never shows up in the database as it should.
I have created a test of my example DAO using the same Tranql DataSource, JTA TransactionManager, and ConnectionManager, and I can run the test without error but I never see the data inserted into the database table. So I'm assuming that there is something amiss with the Tranql DataSource/ManagedConnectionFactory configuration.
If I use a normal DataSource (i.e. org.apache.commons.dbcp.BasicDataSource without the JDBC ConnectionManager) then the data gets inserted into the database without a problem, but in the third test case above the data insert is not rolled back since the JDBC isn't participating in the XA transaction.
Below is my persistence configuration, maybe someone can see what I'm doing wrong?
<beans>
<!-- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ -->
<!-- JDBC Managed Connection Factory -->
<!-- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ -->
<bean id="jdbcManagedConnectionFactory" class="org.jencks.tranql.DataSourceMCF">
<property name="driverName" value="${jdbc.driver}"/>
<property name="url" value="${jdbc.url}"/>
<property name="user" value="${jdbc.username}"/>
<property name="password" value="${jdbc.password}"/>
</bean>
<!-- ~~~~~~~~~~~~~~~~~~~~~~~ -->
<!-- JTA Transaction Manager -->
<!-- ~~~~~~~~~~~~~~~~~~~~~~~ -->
<bean id="transactionManager" class="org.jencks.factory.TransactionManagerFactoryBean"/>
<!-- ~~~~~~~~~~~~~~~~~~ -->
<!-- Connection Manager -->
<!-- ~~~~~~~~~~~~~~~~~~ -->
<bean id="jdbcConnectionManager" class="org.jencks.factory.ConnectionManagerFactoryBean">
<property name="transactionManager" ref="transactionManager"/>
</bean>
<!-- ~~~~~~~~~~~~~~~ -->
<!-- JDBC DataSource -->
<!-- ~~~~~~~~~~~~~~~ -->
<bean id="dataSource" class="org.jencks.factory.ConnectionFactoryFactoryBean">
<property name="managedConnectionFactory" ref="jdbcManagedConnectionFactory"/>
<property name="connectionManager" ref="jdbcConnectionManager"/>
</bean>
<!-- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ -->
<!-- Factory bean for Hibernate Sessions -->
<!-- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ -->
<bean id="hibernateSessionFactory"
class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">
<property name="dataSource" ref="dataSource"/>
<property name="annotatedClasses">
<list>
<value>com.mycom.jta.model.Example</value>
</list>
</property>
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">${hibernate.dialect}</prop>
<prop key="hibernate.show_sql">true</prop>
<prop key="hibernate.format_sql">true</prop>
<prop key="hibernate.cache.provider_class">org.hibernate.cache.NoCacheProvider</prop>
<prop key="hibernate.cache.use_second_level_cache">false</prop>
<prop key="jdbc.batch_size">20</prop>
<prop key="hibernate.query.substitutions">true 1, false 0</prop>
<prop key="hibernate.hbm2ddl.auto">update</prop>
</props>
</property>
</bean>
<!-- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ -->
<!-- transactional AOP advice which can be used by AOP pointcuts -->
<!-- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ -->
<tx:advice id="persistenceTxAdvice" transaction-manager="transactionManager">
<tx:attributes>
<!-- all methods starting with 'get' are read-only -->
<tx:method name="get*" read-only="true" />
<!-- other methods use the default transaction settings (see below) -->
<tx:method name="*" />
</tx:attributes>
</tx:advice>
<!-- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ -->
<!-- AOP configuration specifying a pointcut and advisor -->
<!-- for applying the transactional advice declared above -->
<!-- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ -->
<aop:config>
<aop:pointcut id="persistenceOperations"
expression="execution(* com.mycom.jta.persistence.*.*(..))" />
<aop:advisor advice-ref="persistenceTxAdvice" pointcut-ref="persistenceOperations" />
</aop:config>
<!-- ~~~~~~~~~~~~~~~~~~~~~~~~~ -->
<!-- DAO for Example objects -->
<!-- ~~~~~~~~~~~~~~~~~~~~~~~~~ -->
<bean id="exampleDao" class="com.mycom.jta.persistence.ExampleDaoHibernateImpl">
<property name="sessionFactory" ref="hibernateSessionFactory" />
<property name="persistentClass" value="com.mycom.jta.model.Example" />
</bean>
</beans>
Thanks in advance for any suggestions as to where I might search for the problem, what I'm obviously doing wrong, etc.
--James
