Hi,
I am running a setup on MonetDB where in concurrent transactions take place. Everything works very fine but for a few transactions getting aborted due to SQLExceptions.
I have set *auto commit to false* for all these transactions. I am getting frequent SQLExceptions with the message as *java.sql.SQLException: COMMIT: failed*
But if I retry the same transaction, this works fine. Any idea on what would be the reason for frequent commit fails?
When I set *auto commit to true* for the transactions, I get similarly frequent Exceptions but the message becomes *java.sql.SQLException: COMMIT: transaction is aborted because of concurrency conflicts*
Is it like both the exception thrown be for the same cause?
Any help much appreciated.
Thanks in Advance.
Vijayakrishna.P. Mobile : (+91) 9500402305.