[
https://issues.apache.org/jira/browse/SOLR-2141?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13502319#comment-13502319
]
James Dyer commented on SOLR-2141:
----------------------------------
Could you try importing again with the latest revision from Trunk/5.x or
branch_4x ? Based on my limited understanding of this problem, I think it
might have been solved with SOLR-4086.
In either case, we probably should write a good unit test for this so that it
doesn't break again.
> 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.b341f5b.patch,
> SOLR-2141.patch, SOLR-2141.patch, SOLR-2141-sample.patch, SOLR-2141-test.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
