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
