Hi,
In one transaction, i am able to execute around 10 INSERT/UPDATE statements.
If i put more than 10 INSERT/UPDATE in one transcation, it is being strucked up, and no INSERT/UPDATE are being done.
I am using Connection Pooling class for getting Connection.
Please let me the reason why i am not able to run more than around 10 INSERT/UPDATE per transaction.
thanks in advance
Srinivas
Discussions
Performance and scalability: Is there any limitaton on no.of insert statements per transacti
-
Is there any limitaton on no.of insert statements per transacti (2 messages)
- Posted by: srinivas n
- Posted on: February 04 2002 04:09 EST
Threaded Messages (2)
- Is there any limitaton on no.of insert statements per transacti by sridhar G on February 06 2002 06:58 EST
- Is there any limitaton on no.of insert statements per transacti by Tony Brookes on February 07 2002 00:18 EST
-
Is there any limitaton on no.of insert statements per transacti[ Go to top ]
- Posted by: sridhar G
- Posted on: February 06 2002 06:58 EST
- in response to srinivas n
Better check how many connections are created in your connectionpool and how may connection you have used. If it exceeds the no. of connections created then it will not allow . -
Is there any limitaton on no.of insert statements per transacti[ Go to top ]
- Posted by: Tony Brookes
- Posted on: February 07 2002 00:18 EST
- in response to srinivas n
Depends on your database to some extent. It might be that your transaction log size is minute. Most likely the log gets truncated when a checkpoint occurs, but with your transaction still running that won't happen.
Hence, if you fill up the log, the transaction will be aborted.
What database server are you using? How is it configured?
Doesn't strile me as a Java issue. More likely a DB one.
HTH
Chz
Tony