aspose file tools*
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
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 Karuppasamy
Ranch Hand

Joined: Jul 19, 2007
Posts: 153
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 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
It is sorta covered in the JavaRanch Style Guide.
subject: how reliable JDBC Transaction?
Similar Threads
Transaction roll back in session bean
Disrtibuted Tx using JDBC
BMT Rollback Issue
Agile Database - Java JDBC concerns
Help - Data visibility in Weblogic and JDBC connection problem