But, about the docs: *"The only way to return a connection to the DataSource (or close the connection) is to call commitTransaction endTransaction()."*
You could return a connection to the pool just with commitTransaction. I don't know if this would work same way on an EXTERNAL transactional enviroment. So. I guess that endTransaction() is a safe method to close connections. One question. About docs, *"...If you do not explicitly demarcate transactions using the startTransaction(), commitTransaction() and endTransaction() methods, they will all be called automatically for you whenever you execute a statement outside of a transactional block ..."* What does mean that ? Implicitly calling methods just works if startTransaction() wasn't called ? If you call startTransaction() but not endTransaction() explicitly, the last one is never called automatically? and when the thread finishes, Connection object isn't closed in any way ? Thanks 2009/1/24 Jonathan Moores <[email protected]> > Hi, > > I was wondering why there is a need to explicitly call > SqlMapClient.endTransaction() in order to return a connection to the pool > even after a commitTransaction()? > > > > I am using Tomcat 6.018 with Ibatis 2.34.726 and I see that the connections > used in a transaction are never returned without the endTransaction() call > which I actually equated to a rollback. > > > > Thanks > > Jon >
