Is there anyone out there using iBATIS with JNDI within WebSphere without EJBs that is willing to share their settings?
Thanks Mike On Mon, Aug 25, 2008 at 5:17 PM, Jeff Butler <[EMAIL PROTECTED]> wrote: > UserTransaction is a configuration setting required for JTA. See here: > > > http://publib.boulder.ibm.com/infocenter/wasinfo/v6r1/index.jsp?topic=/com.ibm.websphere.base.doc/info/aes/ae/cjta_glotran.html > > You are correct that JTA is only *needed* if there are two or more > resources. However, even with one resource I believe that WebSphere > is creating a JTA compatible transaction. So it will always work to use > JTA. > > I believe that the jdbc connection.close() method in effect transfers > through to the underlying JTA transation. So maybe JTA is a more direct > route to the actual transaction - but this is heavy WebSphere internals and > I don't know the answer for sure. > > As to whether one is better than the other in your specific case, I can't > say. If it's not broke, don't fix it. If it is broke, give JTA a try to > see if it makes a difference. Then you'll know. > > Jeff Butler > > On Mon, Aug 25, 2008 at 3:16 PM, Michael Schall <[EMAIL PROTECTED]>wrote: > >> We are using iBATIS in a large application that does not use EJBs and it >> works great. We are seeing some issues where we are using more connections >> than we think we should be. We are wondering if we have some issues with >> connections/transactions not closing as fast as we would like them to. Our >> current transactionManager looks like the following: >> >> <transactionManager type="JDBC" commitRequired="true"> >> <dataSource type="JNDI"> >> <property name="DataSource" value="java:comp/env/jdbc/..."/> >> </dataSource> >> </transactionManager> >> >> A link ( >> http://opensource.atlassian.com/confluence/oss/display/IBATIS/Environment+Specific+Information) >> in a recent post pointed me to a different config: >> >> <transactionManager type="JTA" commitRequired="true"> >> <property name="UserTransaction" >> value="java:comp/env/UserTransaction"/> >> <dataSource type="JNDI"> >> <property name="DataSource" value="java:comp/env/..."/> >> </dataSource> >> </transactionManager> >> >> From what I have read, JTA is needed if you require 2 phase commits, which >> we don't. Is JTA a better choice anyway? What is the UserTransaction >> property doing here? >> >> Thanks for your time. >> >> Mike >> > >
