On your <dataSource /> tag, specify "batchSize" with a value that your db/driver allows. The hardcoded default is 500. If you set it to -1 it converts it to Integer.MIN_VALUE. See http://wiki.apache.org/solr/DataImportHandler#Configuring_JdbcDataSource , which recommends using this -1 value in the case of errors.
When executing queries, JdbcDataSource calls Statement.setFetchSize(batchSize) . Based on the java.sql.Statement api documentation, you can set this to 0 to retain your db/driver's default. See http://docs.oracle.com/javase/6/docs/api/java/sql/Statement.html#setFetchSize%28int%29 James Dyer E-Commerce Systems Ingram Content Group (615) 213-4311 -----Original Message----- From: pla [mailto:patrick.archib...@gmail.com] Sent: Thursday, May 24, 2012 9:10 AM To: solr-user@lucene.apache.org Subject: Re: problem on running fullimport Thanks Alexey Serba. I encountered the *java.sql.SQLException: Illegal value for setFetchSize()* error after upgrading one of my servers to MySQL version 5.5.22. PLA -- View this message in context: http://lucene.472066.n3.nabble.com/problem-on-running-fullimport-tp1707206p3985924.html Sent from the Solr - User mailing list archive at Nabble.com.
