jQuery in Action, 3rd edition
The moose likes EJB and other Java EE Technologies and the fly likes how reliable JDBC Transaction? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Head First Android this week in the Android forum!
JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Bookmark "how reliable JDBC Transaction?" Watch "how reliable JDBC Transaction?" New topic

how reliable JDBC Transaction?

Kaleeswaran Karuppusamy
Ranch Hand

Joined: Jul 19, 2007
Posts: 154
we use JDBC transaction( not JTA) its work with only single connection.suppose in a connection pooling architecture different connection created according to the client request.in this situation JDBC transaction failed to fulfill the job i am right?.

Judge a man by his questions rather than his answers --Voltaire
SCJP 1.5 97%
Roger Chung-Wee
Ranch Hand

Joined: Sep 29, 2002
Posts: 1683
A JDBC transaction is controlled by the transaction manager of the DBMS. It has built-in support for transactions but is limited to a single data source (in practice, a single database in most cases).

A non-JDBC transaction is controlled by the transaction manager of the J2EE server. When you use connection pooling, the server will typically require the data source to be created (with the associated connection pool) and bound into its JNDI tree. The server has control of the data source and the connections is therefore able to manage transactions.

I won't say that "JDBC transaction failed to fulfill the job", it is just a case of which service is appropriate for what you want to achieve.

SCJP 1.4, SCWCD 1.3, SCBCD 1.3
I agree. Here's the link: http://aspose.com/file-tools
subject: how reliable JDBC Transaction?
It's not a secret anymore!