lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Hasan Diwan <>
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:
  <dataSource driver="net.sf.log4jdbc.DriverSpy" user="sa"
  <!-- <dataSource driver="org.h2.Driver" url="jdbc:h2:tcp://" user="sa" /> -->
        <entity name="receipt" query="SELECT 'transaction' as type,
currency, name, amount, done_on from receipts join app_users on user_id ="
          deltaQuery="SELECT 'transaction' as type, name, currency, amount,
done_on from receipts join app_users on user_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?? -->
And the resulting query of "*:*":
% curl "*%3A*"

<?xml version="1.0" encoding="UTF-8"?>
<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"
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

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