• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

executeBatch() failing for 100 and above

 
Anand Bhatt
Ranch Hand
Posts: 189
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am tyring to execute 100 records using executeBatch() method of Statement interface.
Upto 99 it is working it fine.

So any idea is there upper limit on number of records to executeBatch method??
 
Paul Clapham
Sheriff
Pie
Posts: 20980
31
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
If I had that problem, I would start by investigating the reasons for the failure. That could include standard debugging techniques like looking at stack traces, for example.
 
Anand Bhatt
Ranch Hand
Posts: 189
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks Paul I am well aware about that, but unfortunately I am not getting any kind of exception/error in log file or console.
As I am reading one .xls file (having 100 plus records) row by row and trying to execute all rows data in single hit by first addBatch and than finally calling executeBatch(String sql),
 
Ram Narayan.M
Ranch Hand
Posts: 247
Chrome Eclipse IDE Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
There would be a possibility of invalid data in 100th record so that its not entered and would be filtrated in validation phase if you have done this...
 
Anand Bhatt
Ranch Hand
Posts: 189
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Ram
There were total of 145 records in that sheet .When I tried to upload in different set(50-50 records per transaction) it is working porperly,It means all records are porper.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic