You might also want to show us your "dataimport" handler configuration from solrconfig.xml and also the url you're using to start the data import. When its complete, browsing to "http://192.168.1.6:8995/solr/db/dataimport"; (or whatever the DIH handler name is in your config) should say "indexing complete" and also the number of documents it imported. Also, if you have "commit=false" in your config, it won't issue a commit so you won't see the documents.
If it fails, your servlet container's logs should have a stack trace or something indicating what the failure was. James Dyer E-Commerce Systems Ingram Content Group (615) 213-4311 -----Original Message----- From: Hasan Diwan [mailto:hasan.di...@gmail.com] Sent: Tuesday, April 24, 2012 8:51 AM To: solr-user@lucene.apache.org Subject: JDBC import yields no data I'm trying to migrate from RDBMS to the Lucene ecosystem. To do this, I'm trying to use the JDBC importer[1]. My configuration is given below: <dataConfig> <dataSource driver="net.sf.log4jdbc.DriverSpy" user="sa" url="jdbc:log4jdbc:h2:tcp://192.168.1.6/finance"/> <!-- <dataSource driver="org.h2.Driver" url="jdbc:h2:tcp:// 192.168.1.6/finance" user="sa" /> --> <document> <entity name="receipt" query="SELECT 'transaction' as type, currency, name, amount, done_on from receipts join app_users on user_id = app_users.id" deltaQuery="SELECT 'transaction' as type, name, currency, amount, done_on from receipts join app_users on user_id = app_users.id where done_on > '${dataimporter.last_index_time}'"> <field column="NAME" name="name" /> <field column="NAME" name="nameSort" /> <field column="NAME" name="alphaNameSort" /> <field column="AMOUNT" name="amount" /> <!-- currencyField not available till 3.6 --> <field column="transaction_time" name="done_on" /> <!-- resolve epoch time --> <field column="location" name="location"/> <!-- geospatial?? --> </entity> </document> </dataConfig> And the resulting query of "*:*": % curl "http://192.168.1.6:8995/solr/db/select/?q=*%3A*"; [~] <?xml version="1.0" encoding="UTF-8"?> <response> <lst name="responseHeader"><int name="status">0</int><int name="QTime">1</int><lst name="params"><str name="q">*:*</str></lst></lst><result name="response" numFound="0" start="0"/> </response> The SQL query does work properly, the relevant jars are in the lib subdirectory. Help? -- H -- Sent from my mobile device Envoyait de mon portable 1. http://wiki.apache.org/solr/DataImportHandler#Configuring_JdbcDataSource
