This week's giveaway is in the EJB and other Java EE Technologies forum. We're giving away four copies of EJB 3 in Action and have Debu Panda, Reza Rahman, Ryan Cuprak, and Michael Remijan on-line! See this thread for details.
In one session bean, this transaction involves a bunch of SQL calls to database. But all of them are in the same method of this bean. I understand both JTA or regular JDBC level transaction control will work. Which one is prefered though? Thanks in advance ...
<i><br />Sun Certified Programmer for Java 2 Platform (SCJP)<br />Sun Certified Developer for Java 2 Platform (SCJD)<br />Sun Certified Web Component Developer for Java2 Platform, Enterprise Edition (SCWCD)<br />Sun Certified Business Component Developer for Java2 Platform, Enterprise Edition (SCBCD)<br />Sun Certified Enterprise Architect for J2EE (SCEA)<br />IBM Certified Enterprise Developer, WebSphere Studio V5.0<br /></i>
Since you are already using EJB, in this case Session Beans, then it is easiest to just go with CMT which will make use of JTA. However, if you didn't already have this infrastructure in place then I would have went with the simplist solution possible which in this case (without considering any other requirements that I don't know of) would mean plain JDBC.