Did you define all the fields that you used in schema.xml?
Ci-man wrote: > > I am using MS SQL server and want to index a table. > I setup my data-config like this: > > <dataConfig> > <dataSource type="JdbcDataSource" batchSize="25000" > autoCommit="true" > driver="com.microsoft.sqlserver.jdbc.SQLServerDriver" > url="jdbc:sqlserver://localhost:1433;databaseName=MYDB" > user="****" password="****"/> > > <document name="products"> > <entity name="item" query="select TOP 50 * from items"> > <field column="item_id" name="id" /> > <field column="itemname" name="name" /> > <field column="itemavgbucost" name="price" /> > <field column="categoryname" name="cat" /> > <field column="itemdesc" name="features" /> > </entity> > </document> > </dataConfig> > > > I am unable to load data from database. I always receive 0 document > fetched: > <lst name="statusMessages"> > <str name="Time Elapsed">0:0:12.989</str> > <str name="Total Requests made to DataSource">1</str> > <str name="Total Rows Fetched">0</str> > <str name="Total Documents Processed">0</str> > <str name="Total Documents Skipped">0</str> > <str name="Full Dump Started">2009-04-28 14:37:49</str> > </lst> > > The query runs in SQL Server query manager and retrieves records. The > funny thing is, even if I purposefully write a wrong query with > non-existing tables I get the same response. What am I doing wrong? How > can I tell whether a query fails or succeeds or if solr is running the > query in the first place? > > Any help is appreciated. > Best, > -Ci > > > -- View this message in context: http://www.nabble.com/Unable-to-import-data-from-database-tp23283852p23284381.html Sent from the Solr - User mailing list archive at Nabble.com.
