[ https://issues.apache.org/jira/browse/SOLR-4788?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
chakming wong updated SOLR-4788: -------------------------------- Environment: solr-spec 4.2.1.2013.03.26.08.26.55 solr-impl 4.2.1 1461071 - mark - 2013-03-26 08:26:55 lucene-spec 4.2.1 lucene-impl 4.2.1 1461071 - mark - 2013-03-26 08:23:34 > Multiple Entities DIH delta import: dataimporter.[entityName].last_index_time > is empty > -------------------------------------------------------------------------------------- > > Key: SOLR-4788 > URL: https://issues.apache.org/jira/browse/SOLR-4788 > Project: Solr > Issue Type: Bug > Affects Versions: 4.2 > Environment: solr-spec > 4.2.1.2013.03.26.08.26.55 > solr-impl > 4.2.1 1461071 - mark - 2013-03-26 08:26:55 > lucene-spec > 4.2.1 > lucene-impl > 4.2.1 1461071 - mark - 2013-03-26 08:23:34 > Reporter: chakming wong > > {code:title=conf/dataimport.properties|borderStyle=solid}entity1.last_index_time=2013-05-06 > 03\:02\:06 > last_index_time=2013-05-06 03\:05\:22 > entity2.last_index_time=2013-05-06 03\:03\:14 > entity3.last_index_time=2013-05-06 03\:05\:22 > {code} > {code:title=conf/solrconfig.xml|borderStyle=solid}<?xml version="1.0" > encoding="UTF-8" ?> > ... > <requestHandler name="/dataimport" > class="org.apache.solr.handler.dataimport.DataImportHandler"> > <lst name="defaults"> > <str name="config">dihconfig.xml</str> > </lst> > </requestHandler> > ... > {code} > {code:title=conf/dihconfig.xml|borderStyle=solid}<?xml version="1.0" > encoding="UTF-8" ?> > <dataConfig> > <dataSource name="source1" > type="JdbcDataSource" driver="com.mysql.jdbc.Driver" > url="jdbc:mysql://*:*/*" > user="*" password="*"/> > <document name="strings"> > <entity name="entity1" pk="id" dataSource="source1" > query="SELECT * FROM table_a" > deltaQuery="SELECT table_a_id FROM table_b WHERE > last_modified > '${dataimporter.entity1.last_index_time}'" > deltaImportQuery="SELECT * FROM table_a WHERE id = > '${dataimporter.entity1.id}'" > transformer="TemplateTransformer"> > <field> ... > ... > ... </field> > </entity> > <entity name="entity2"> > ... > ... > </entity> > <entity name="entity3"> > ... > ... > </entity> > </document> > </dataConfig> > {code} > In above setup, *dataimporter.entity1.last_index_time* is *empty string* and > cause the sql query having error -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org For additional commands, e-mail: dev-h...@lucene.apache.org