Hibernate version:3.0
Database:Oracle 9i
App Server: JBoss 3.2.5

Hello,

I'm using the Hibernate Statistics and noticed that the TransactionCount does not match the SuccessfulTransactionCount on a normal, no-exception database query. The TransactionCount seems to say at about double that of SuccessfulTransactionCount.

I am using the JTA Transaction Manager.

The only post that I've seen that is somewhat similar was "Transaction Problems..." posted on 11/23/04. It only mentioned problems with transactions, a jboss bug handling txns, and that it was working ok in 3.2.6. I haven't upgraded to 3.2.6 to test yet, but I would think it should work fine in 3.2.5.

Do JTA transactions count as 2 in the TransactionCount? Has anyone seen this problem before?

Log output to validate that transaction is only openned and commited once:

INFO: about to proceed
16:19:02,143 INFO [STDOUT] Dec 19, 2005 4:19:02 PM HibernateTransactionAspect topLevelTransactedOperations()
INFO: session obtained, beginning txn
16:19:02,237 INFO [STDOUT] Hibernate: select [...]
16:19:02,425 INFO [STDOUT] Dec 19, 2005 4:19:02 PM HibernateTransactionAspect topLevelTransactedOperations()
INFO: proceeded. committing...
16:19:02,456 INFO [STDOUT] Hibernate: update [...]
16:19:02,487 INFO [STDOUT] Dec 19, 2005 4:19:02 PM HibernateTransactionAspect topLevelTransactedOperations()
INFO: closing session
16:19:02,487 INFO [STDOUT] Dec 19, 2005 4:19:02 PM HibernateTransactionAspect topLevelTransactedOperations()
INFO: session closed

Relevant section of Hibernate Config:

<!-- Property files -->
<property name="dialect">org.hibernate.dialect.Oracle9Dialect</property>
<property name="hibernate.connection.provider_class">org.hibernate.connection.DatasourceConnectionProvider</property>
<property name="hibernate.show_sql">true</property>
<property name="use_outer_join">false</property>
<property name="generate_statistics">true</property>
<property name="cglib.use_reflection_optimizer">false</property>
<property name="hibernate.transaction.manager_lookup_class">org.hibernate.transaction.JBossTransactionManagerLookup</property>
<property name="hibernate.transaction.factory_class">org.hibernate.transaction.JTATransactionFactory</property>
<property name="hibernate.transaction.flush_before_completion">true</property>
<property name="hibernate.transaction.auto_close_session">true</property>
<property name="hibernate.statement_cache.size">0</property>
<property name="hibernate.cache.provider_class">org.hibernate.cache.EhCacheProvider</property>
<property name="cache.use_query_cache">true</property>

Any comments are appreciated!

More info:

Again this is on the JMX published statistics.

The Close Session and Open Session counts match, along with the Successful Transaction Count. Yet the Transaction Count still remains twice that of the Successful Count.

So looks like everything is open, closed, commited correctly, but still wondering what the Transaction Count is keeping a record of.

Hi,
I am experiencing the same problem.
Does anybody know why the transaction count is doubled?
Have you found an answer?

Thanks,
Bora.