Re: Transaction Performance Issue

2008-04-16 Thread Vannel
im using EJB as my external transaction manager -- View this message in context: http://www.nabble.com/Transaction-Performance-Issue-tp16583884p16739622.html Sent from the iBATIS - User - Java mailing list archive at Nabble.com.

Re: Transaction Performance Issue

2008-04-16 Thread Brandon Goodin
If you are using an external transaction manager it is completely up to you to manage the transactions. iBATIS utilizes the connection that is handed to it by your external transaction manager. What is the external transaction manager that is being used? Brandon On Thu, Apr 17, 2008 at 12:41 AM,

Re: Transaction Performance Issue

2008-04-16 Thread Vannel
can anyone tell me what the scope of a transaction is? - try { //execute sql int ret = insert(...); if (ret>0) { //execute some other sql update(...); } } catch { //catch errors } - in the above scenario, are there 2 transactions (1 for insert, 1 for update)..? or

Re: Transaction Performance Issue

2008-04-11 Thread Alistair Young
On 11/04/2008, Vannel <[EMAIL PROTECTED]> wrote: > > Sorry about not being clear. Initially I was trying to give an example and in > the later post I decided to give a more accurate representation of my > program. I dont think I am using any form of caching unless it's on by > default. To be ab

Re: Transaction Performance Issue

2008-04-11 Thread Vannel
Sorry about not being clear. Initially I was trying to give an example and in the later post I decided to give a more accurate representation of my program. I dont think I am using any form of caching unless it's on by default. To be abit clearer, my client receives notification right after the up

Re: Transaction Performance Issue

2008-04-11 Thread Alistair Young
Hi Vannel, As I understand it, iBATIS will issue each of your SQL statements (select, update) to the database in turn. However, the "return" (I assume you mean the result of the update() call) will only happen once both statements have been executed. I'm still a bit confused as to what your appl

RE: Transaction Performance Issue

2008-04-10 Thread Vannel
your 2nd scenario fits my situation alot more. synchronous process. what happens is that i have a client machine listening to changes within the db and updates the client realtime. as an admin, i was sending in sample data into the db via my own terminal. sometimes happens that the client gets, fo

RE: Transaction Performance Issue

2008-04-10 Thread Chris O'Connell
their request. Hopefully I haven't gone too far from what you are really experiencing... -Original Message----- From: Vannel [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 09, 2008 8:18 PM To: user-java@ibatis.apache.org Subject: Re: Transaction Performance Issue the problem lies in the f

Re: Transaction Performance Issue

2008-04-09 Thread Vannel
the problem lies in the fact that my program cannot afford to have a "pending" stage. changes made have to be instantly visible to the user. in fact, the user is not at fault since he could say, update his home address, then click on the update button and then immediately go to the page where he i

Re: Transaction Performance Issue

2008-04-09 Thread Alistair Young
On 09/04/2008, Vannel <[EMAIL PROTECTED]> wrote: > > Hi, > > I have a performance issue i'm not sure how to solve effectively. Here's my > situation.. > I'm trying to run INSERT/UPDATE/DELETE statements and using their return > values as confirmation that the statement has been duly completed