 |
 |
Archives of the TeradataForum
Message Posted: Sat, 13 Sep 2008 @ 12:44:48 GMT
| Subj: | | Re: JDBC autoCommit(false) question |
| |
| From: | | McCall, Glenn David |
| | I believe setAutoCommit() is supported only in TMODE=ANSI (though I don't see that in the documentation, and it doesn't throw an error in
TMODE=TERA). This is true of ODBC also, BTW. | |
Both modes support setAutoCommit - however it is effectively a no-operation if the session mode is Tera.
| | With TMODE=TERA, you should execute explicit "BT;" statement to start a multi-statement transaction and "ET;" statement to end
it. | |
If you need a "transaction", then that is one way. Another is a multi-statement request and/or a macro.
| |
