Jan 5th, 2009, 05:43 AM
I tried to insert records as barch thru JdbcTemplate.batchUpdate() this method and getting exception like:
[Teradata JDBC Driver] : HY000 802 : Timeout StatementState.TIMEOUT before receive; nested exception is com.ncr.teradata.jdbc_4.util.JDBCBatchUpdateExcept ion: Timeout StatementState.TIMEOUT before receiveorg.springframework.jdbc.support.SQLStateSQ LExceptionTranslator.translate(SQLStateSQLExceptio nTranslator.java:120):org.springframework.jdbc.sup port.SQLErrorCodeSQLExceptionTranslator.translate( SQLErrorCodeSQLExceptionTranslator.java:
If anyone have idea to handle exception while batch update please send the explaination to resolve this.
Jan 7th, 2009, 03:03 AM
This is really a question for the Data Access forum. You might get more traction there, since it is not specific to Spring Batch. Looks like a platform issue to me (can you configure the timeout in the database?).
Jan 7th, 2009, 03:09 AM
In this case i tried to insert around 32,000 records. Then i got this exception but i changed business logic to insert 1000 records everytime then its working fine. But actually to pass those many records how to set timeout value i don't know.
Thanks for your reply