This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
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 Android Security Essentials Live Lessons 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
Author

how reliable JDBC Transaction?

Kaleeswaran Karuppasamy
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
 
wood burning stoves
 
subject: how reliable JDBC Transaction?
 
Similar Threads
BMT Rollback Issue
Disrtibuted Tx using JDBC
Help - Data visibility in Weblogic and JDBC connection problem
Agile Database - Java JDBC concerns
Transaction roll back in session bean