Re: [Virtuoso-users] Virtuoso batch transactions

2014-01-01 Thread Quentin
Hi Hugh, I'm testing in conductor/isql but will be using odbc in implementation. The suggested instruction gives: SQLState: 37000 Message: SQ074: Line 1: syntax error at 'MANUAL' before ';' set AUTOCOMMIT MANUAL I'm certain that's a correct isql instruction so am a little confused about

Re: [Virtuoso-users] Virtuoso batch transactions

2014-01-01 Thread Hugh Williams
Hi Quentin, By isql I mean't the Virtuoso command line tool, which is where the set AUTOCOMMIT MANUAL; command works. Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com/blogs/ LinkedIn --

Re: [Virtuoso-users] Virtuoso batch transactions

2014-01-01 Thread Quentin
I see. Well regardless, even using log_enable to disable row-based commits, the work is being committed halfway through the function and not rolled back after an exception. So is it possible to batch everything in a function into an atomic transaction regardless of where the function is called