Archives of the TeradataForum

Message Posted: Tue, 09 Sep 2008 @ 12:41:25 GMT

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

David,

I could narrow the problem source to autoCommit() only after running a simple JDBC program which goes like this,

1. Register the driver using "com.ncr.teradata.TeraDriver" Driver class.

2. Create Connection object using DriverManager.getconnection(dbUrl, username, pwd)

3. Set autoCommit to false (conn.setAutoCommit(false));

3. Create Statement object.

4. Execute SELECT query using Statement object.

5. Perform commit (conn.commit())

6. Close statetement and close Connection.

I ran the program with different combinations. And finally I noticed that if setAutoCommit(false) line along with conn.commit() is commented, which means resorting to default behavior of commit happening after every db operation, the error msg stopped coming.

Regarding enviroment, I am using 12.0 Teradata JDBC driver and have TMODE set to TERA in dbUrl.

Thanks,

Nitin.

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