lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Hasan Diwan <hasan.di...@gmail.com>
Subject JDBC import yields no data
Date Tue, 24 Apr 2012 13:50:31 GMT
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

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message