With MS SqlServer, try adding "selectMethod=cursor" to your conenction string and set your batch size to a reasonable amount (possibly just omit it and DIH has a default value it will use.)
James Dyer Ingram Content Group (615) 213-4311 -----Original Message----- From: kobe.free.wo...@gmail.com [mailto:kobe.free.wo...@gmail.com] Sent: Monday, March 25, 2013 3:25 AM To: solr-user@lucene.apache.org Subject: SOLR - "Unable to execute query" error - DIH Hello All, I am trying to index data from SQL Server view to the SOLR using the DIH with full-import command. The view has 750K rows and 427 columns. During the first execution i indexed only the first 50 rows of the view, the data got indexed in 10 min. But, when i executed the same scenario to index the complete set of 750K rows, the execution continued for 2 days and roll-backed, giving me the following error: "Unable to execute the query: select * from....." Following is my DIH configuration file, <dataConfig> <dataSource type="JdbcDataSource" driver="com.microsoft.sqlserver.jdbc.SQLServerDriver" url="jdbc:sqlserver://server1\sql2012;databaseName=DBName" user="x" password="x" /> <document name="Search" batchsize="1"> <entity name="Search" query="select top 500 * from view"> <field column="ID" name="Id" /> As suggested in some of the posts, i did try with batchsize="-1", but dint work out. Please suggest is this the correct approach or any parameter needs to be modified for tuning. Thanks! -- View this message in context: http://lucene.472066.n3.nabble.com/SOLR-Unable-to-execute-query-error-DIH-tp4051028.html Sent from the Solr - User mailing list archive at Nabble.com.
