Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version: 2.17

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:

I am looking for any good reading on Transactions and how Hibernate manages them. Does Hibernate uses JTA only when the transaction involves more than 1 database? What about bean-managed transactions?

Hibernate delegates Transactions to an external manager. This maybe the JDBC driver, OTM or even JTA layer (which could be a CMT engine). It all depends on the configuration and environment hibernate is operating within.

This is well explained in the reference documentation, there is a whole new chapter which took me several days to write. Read it! And read this:

http://www.hibernate.org/ForumMailingli ... AskForHelp

So Hibernate does not use bean-managed transactions at all?

Suppose its a single database environment. Will Hibernate use JDBC or JTA (by default)? For a multiple database environment what is the default strategy?

Will the configuration we specifies, always overrides Hibernate's even if our configuration is not the best solution?

Read the documentation!

See: http://www.hibernate.org/hib_docs/v3/reference/en/html/transactions.html