You are viewing a plain text version of this content. The canonical link for it is here.
Posted to solr-user@lucene.apache.org by Nauman Ramzan <na...@gmail.com> on 2015/06/29 10:53:59 UTC

SOLR 5.1.0 DB dataimport handler from orientdb

Hi everyone !
I want to import data from orientdb in solr 5.1.0.
here is my configurations

*data-config.xml*

> <dataConfig>
>
>     <dataSource type="JdbcDataSource"
>> driver="com.orientechnologies.orient.jdbc.OrientJdbcDriver"
>> url="jdbc:orient:remote:localhost/emallates_combine" user="root"
>> password="root" batchSize="-1"/>
>
>     <document>
>
>         <entity name="item" query="select * from sellings"
>
>                 deltaQuery="select * from sellings where updatedAt >
>> '${dataimporter.last_index_time}'">
>
>             <field name="id" column="price" />
>
>             <field name="title" column="status" />
>
>         </entity>
>
>     </document>
>
> </dataConfig>
>
>
*JDBC* driver link http://orientdb.com/download/
and I paste this driver in* {solr_install_dir}/dist/orientdb-jdbc-2.0.5.jar*

my configuration is not showing any error nor any output.
here is log of solr after full/delta import call.

INFO  - 2015-06-29 12:37:24.894; [   DB]
> org.apache.solr.handler.dataimport.DataImporter; Loading DIH Configuration:
> db-data-config.xml

INFO  - 2015-06-29 12:37:24.899; [   DB]
> org.apache.solr.handler.dataimport.DataImporter; Data Configuration loaded
> successfully

INFO  - 2015-06-29 12:37:24.900; [   DB] org.apache.solr.core.SolrCore;
> [DB] webapp=/solr path=/dataimport
> params={debug=false&optimize=false&indent=true&commit=true&clean=true&wt=json&command=full-import&verbose=false}
> status=0 QTime=7

INFO  - 2015-06-29 12:37:24.902; [   DB]
> org.apache.solr.handler.dataimport.DataImporter; Starting Full Import

*WARN  - 2015-06-29 12:37:24.912; [   DB]
> org.apache.solr.handler.dataimport.SimplePropertiesWriter; Unable to read:
> dataimport.properties*

INFO  - 2015-06-29 12:37:24.914; [   DB] org.apache.solr.core.SolrCore;
> [DB] webapp=/solr path=/dataimport
> params={indent=true&wt=json&command=status&_=1435567044911} status=0
> QTime=1

INFO  - 2015-06-29 12:37:24.942; [   DB]
> org.apache.solr.handler.dataimport.JdbcDataSource$1; Creating a connection
> for entity item with URL: jdbc:orient:remote:localhost/emallates_combine

INFO  - 2015-06-29 12:37:24.942; [   DB]
> org.apache.solr.update.processor.LogUpdateProcessor; [DB] webapp=/solr
> path=/dataimport
> params={debug=false&optimize=false&indent=true&commit=true&clean=true&wt=json&command=full-import&verbose=false}
> status=0 QTime=7 {deleteByQuery=*:* (-1505301149686693888)} 0 49

INFO  - 2015-06-29 12:37:32.992; [   DB] org.apache.solr.core.SolrCore;
> [DB] webapp=/solr path=/dataimport
> params={wt=json&command=abort&_=1435567052987} status=0 QTime=1

INFO  - 2015-06-29 12:37:33.000; [   DB] org.apache.solr.core.SolrCore;
> [DB] webapp=/solr path=/dataimport
> params={indent=true&wt=json&command=status&_=1435567052997} status=0
> QTime=0


SOLR is not importing any data. What am I doing wrong ?
and second why am I getting above warming ?

Thank you
Regards
Nauman Ramzan