Bugs item #2983861, was opened at 2010-04-08 15:02 Message generated for change (Tracker Item Submitted) made by mr-meltdown You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2983861&group_id=56967
Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: SQL/JDBC Group: SQL CVS Head Status: Open Resolution: None Priority: 5 Private: No Submitted By: Fabian (mr-meltdown) Assigned to: Niels Nes (nielsnes) Summary: SQL: transaction aborts on prepared statements in autocommit Initial Comment: When batching the airtraffic database (air3 file) using a prepared statement to the server, a transaction rollback happens when the server is in autocommit mode. When not in autocommit mode, the loading process finishes successfully. Also when commits are done inbetween the batches a transaction abort failure is returned. It feels like a commit in the process makes every next exec fail. The attached java file can be compiled using: % javac PrepareBatchCrash.java And then run: % java -cp .:$INSTALL_DIR/share/MonetDB/lib/monetdb-1.14-jdbc.jar PrepareBatchCrash "jdbc:monetdb://localhost/somedb?user=monetdb&password=monetdb" /var/tmp/air3 You can find the air3 file in /var/tmp on volund ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2983861&group_id=56967 ------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
