the parameter name is batchSize by default it is set as 500
On Tue, Sep 15, 2009 at 7:27 PM, Luc Caprini <[email protected]> wrote: > Hi, > > I'm trying using SOLR 1.4. and in my first test, I've got an issue with the > DataImportHandler ... > > > Config : SOLR 1.4 on tomcat 5.5.27 with mysql driver 5.1.7 on mysql 5.1 > > My dataconfig is > > <dataConfig> > <dataSource driver="com.mysql.jdbc.Driver" > url="jdbc:mysql://localhost/testa" user="root" password="password"/> > > <document> > <entity name="a" query="select * from a" > > <field column="b" name="named"/> > </entity> > > </document> > </dataConfig> > > And it generates this error > > Unable to execute query: select * from a Processing Document # 1 at > org.apache.solr.handler.dataimport.DataImportHandlerException.wrapAndThrow(DataImportHandlerException.java:72) > at > org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.<init>(JdbcDataSource.java:251) > at > org.apache.solr.handler.dataimport.JdbcDataSource.getData(JdbcDataSource.java:208) > at > org.apache.solr.handler.dataimport.JdbcDataSource.getData(JdbcDataSource.java:39) > at > org.apache.solr.handler.dataimport.DebugLogger$2.getData(DebugLogger.java:184) > at > org.apache.solr.handler.dataimport.SqlEntityProcessor.initQuery(SqlEntityProcessor.java:58) > at > org.apache.solr.handler.dataimport.SqlEntityProcessor.nextRow(SqlEntityProcessor.java:71) > at > org.apache.solr.handler.dataimport.EntityProcessorWrapper.nextRow(EntityProcessorWrapper.java:237) > at > org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:339) > at > org.apache.solr.handler.dataimport.DocBuilder.doFullDump(DocBuilder.java:225) > at > org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:167) > at > org.apache.solr.handler.dataimport.DataImporter.doFullImport(DataImporter.java:333) > at > org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:393) > at > org.apache.solr.handler.dataimport.DataImportHandler.handleRequestBody(DataImportHandler.java:203) > at > org.apache.solr.handler.RequestHandlerBase.handleRequest(RequestHandlerBase.java:131) > at org.apache.solr.core.SolrCore.execute(SolrCore.java:1301) at > org.apache.solr.servlet.SolrDispatchFilter.execute(SolrDispatchFilter.java:338) > at > org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilter.java:241) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) > at > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172) > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) > at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) > at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) > at > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174) > at > org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:875) > at > org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665) > at > org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528) > at > org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81) > at > org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689) > at java.lang.Thread.run(Unknown Source) Caused by: java.sql.SQLException: * > Illegal value for setFetchSize()*. at > com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) at > com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) at > com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926) at > com.mysql.jdbc.StatementImpl.setFetchSize(StatementImpl.java:2404) at > org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.<init>(JdbcDataSource.java:240) > ... 30 more</str> > > I tried to add fetchsize as a parameter : > <dataSource driver="com.mysql.jdbc.Driver" > url="jdbc:mysql://localhost/testa" user="root" password="password" > fetchSize="1"/> > but result is the same. > > Thanks in advance for your assistance > > > > Kind regards > > > Luc > > -- > <http://www.sun.com> * Luc Caprini * > Client Solutions Architect > *Sun Microsystems, Inc.* > 13 Avenue Morane Saulnier > Velizy 78140 France > Phone +33 (0) 1 34 03 00 20 > Mobile +33 (0) 6 12 30 16 22 > Fax +33 (0) 1 34 03 10 11 > Email [email protected] > > > -- ----------------------------------------------------- Noble Paul | Principal Engineer| AOL | http://aol.com
