Re: JDBC and transaction serialization

Trying your luck would be to learn about "optimisitic concurrency control" See also, http://www.monetdb.org/Documentation/Manuals/SQLreference/Transactions regards, Martin On 11/8/12 5:16 AM, Tapomay Dey wrote:

Anyone? (Just trying my luck :) ) ------------------------------------------------------------------------ *From:* Tapomay Dey *To:* Communication channel for Monet DB users *Sent:* Tuesday, November 6, 2012 10:37 AM *Subject:* JDBC and transaction serialization

Hi, I have written a multi-threaded app that consumes multiple logs simultaneously and generates DDL/DML statements for monetdb. It uses JDBC and the threads write to a single table.

However I am getting "COMMIT: transaction is aborted because of concurency conflicts, will ROLLBACK instead" very frequently. Also when it retries the insert there is some inconsistency that I have not been able to try and debug yet. Eventually there are more rows than inserts. Weird thing is I also have a unique key constraint on the table.

I am guessing this happen as monetdb doesn't use locking for serialization.

I have tried connection.setAutoCommit(true) by itself and also with connection.setTransactionIsolation(NONE). But in vain.

Please help.

Thanks and Regards, Tapomay Dey.

_______________________________________________ users-list mailing list users-list@monetdb.org mailto:users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list

_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list

_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list