Archives of the TeradataForum

Message Posted: Mon, 08 Sep 2008 @ 15:14:01 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

<-- Anonymously Posted: Mon, 8 Sep 2008 08:30 -->

I'm assuming you actually invoke setAutoCommit() method with value 'false'.

If you are using or defaulting to TMODE=TERA, note that most errors will cause implicit transaction rollback not individual statement rollback - thus ending the transaction. You may need to use TMODE=ANSI to get the transaction behavior you want, though this does change other semantics (e.g. default to case-sensitive character comparisons).

	<Prev	Next>		<<First	<Prev	Next>	Last>>