JdbcTemplate.batchUpdate() exception

[yvgupta4]

Hi,

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.


Thanks
Gupta

[Dave Syer]

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?).

[yvgupta4]

Hi,

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


Gupta