Larry: Thanks for the reply. One more question, and I am pretty sure thats how iBatis works, but won't hurt asking:
In the same thread, when using JDBC TX Manager, does iBatis only create one connection and re-use it for all JDBC calls to the database? Thanks, - Adnan -----Original Message----- From: Larry Meadors [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 24, 2005 11:01 AM To: user-java@ibatis.apache.org Subject: Re: Multi-threading and Connections On 8/24/05, Rafiq, Adnan <[EMAIL PROTECTED]> wrote: > 1. the process will spawn multiple threads and each thread needs its > own connection. how is this handled in ibatis? does each thread > automatically get its own connection or do I need to write more code? That is the default behavior, yes. > 2. the process commits/rollbacks at the very end by default however, > some batch processes may do commits in the middle of processing > (e.g. in a for-loop) I believe I can just issue commits using the iBatis > API. is this correct? Not sure what you mean here..you can commit using the sqlmap api. > 3. I plan to use a Simple JDBC datasource as TX manager. Is this the > best approach or are there better alternatives out there? Should work ok. > > > -----Original Message----- > From: Graeme J Sweeney [mailto:[EMAIL PROTECTED] > Sent: Wednesday, August 24, 2005 10:23 AM PLEASE do not hijack other threads like this.. Larry
