RE: DataImportHandlerException: Unable to execute query with OPTIM

2013-01-15 Thread ashimbose
Dear James Dyer , Thank You Very Much. Its really working now. I was struggling past 3 weeks to solve it. You are really awesome. I am really happy now. Thank you to make me happy. Regards, Ashim -- View this message in context: http://lucene.472066.n3.nabble.com/DataImportHandlerException-Un

RE: DataImportHandlerException: Unable to execute query with OPTIM

2013-01-15 Thread Dyer, James
I think your JDBC driver is complaining because it doesn't like what is being set for the "fetch size" on the Statement. "Fetch size" is controlled by the "batchSize" parameter on . Using "batchSize=-1", I believe, is a workaround for MySql but I suspect your driver requires it to be >0 (or