[ https://issues.apache.org/jira/browse/SOLR-2141?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
James Dyer reopened SOLR-2141: ------------------------------ I re-opened the issue as it sounds like an actual problem. Vadim/Sand, can either of you create a failing unit test? This would make it a lot easier to fix. Perhaps you can start with something like TestFileListWithLineEntityProcessor . Also, can you point to an svn revision number when this functionality worked for you? This would help track down what broke it. > NullPointerException when using escapeSql function > -------------------------------------------------- > > Key: SOLR-2141 > URL: https://issues.apache.org/jira/browse/SOLR-2141 > Project: Solr > Issue Type: Bug > Components: contrib - DataImportHandler > Affects Versions: 1.4.1 > Environment: openjdk 1.6.0 b12 > Reporter: Edward Rudd > Assignee: Koji Sekiguchi > Attachments: dih-config.xml, dih-file.xml, SOLR-2141-sample.patch > > > I have two entities defined, nested in each other.. > <entity name="article" query="select category, subcategory from articles"> > <entity name="other" query="select other from othertable where > category='${dataimporter.functions.escapeSql(article.category)}' > AND > subcategory='${dataimporter.functions.escapeSql(article.subcategory)}'"> > </entity> > </entity> > Now, when I run that it bombs on any article where subcategory = '' (it's a > NOT NULL column so empty string is there) If i do where subcategory!='' in > the article query it works fine (aside from not pulling in all of the > articles). > org.apache.solr.handler.dataimport.DataImportHandlerException: > java.lang.NullPointerException > at > org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:424) > at > org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:383) > at > org.apache.solr.handler.dataimport.DocBuilder.doFullDump(DocBuilder.java:242) > at > org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:180) > at > org.apache.solr.handler.dataimport.DataImporter.doFullImport(DataImporter.java:331) > at > org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:389) > at > org.apache.solr.handler.dataimport.DataImporter$1.run(DataImporter.java:370) > Caused by: java.lang.NullPointerException > at > org.apache.solr.handler.dataimport.EvaluatorBag$1.evaluate(EvaluatorBag.java:75) > at > org.apache.solr.handler.dataimport.EvaluatorBag$5.get(EvaluatorBag.java:216) > at > org.apache.solr.handler.dataimport.EvaluatorBag$5.get(EvaluatorBag.java:204) > at > org.apache.solr.handler.dataimport.VariableResolverImpl.resolve(VariableResolverImpl.java:107) > at > org.apache.solr.handler.dataimport.TemplateString.fillTokens(TemplateString.java:81) > at > org.apache.solr.handler.dataimport.TemplateString.replaceTokens(TemplateString.java:75) > at > org.apache.solr.handler.dataimport.VariableResolverImpl.replaceTokens(VariableResolverImpl.java:87) > at > org.apache.solr.handler.dataimport.SqlEntityProcessor.nextRow(SqlEntityProcessor.java:71) > at > org.apache.solr.handler.dataimport.EntityProcessorWrapper.nextRow(EntityProcessorWrapper.java:237) > at > org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:357) > ... 6 more -- 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