You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@lucene.apache.org by "Edward Rudd (JIRA)" <ji...@apache.org> on 2010/10/05 03:39:32 UTC
[jira] Created: (SOLR-2141) NullPointerException when using
escapeSql function
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
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.
-
You can reply to this email to add a comment to the issue online.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@lucene.apache.org
For additional commands, e-mail: dev-help@lucene.apache.org
[jira] Updated: (SOLR-2141) NullPointerException when using
escapeSql function
Posted by "Koji Sekiguchi (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/SOLR-2141?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Koji Sekiguchi updated SOLR-2141:
---------------------------------
Attachment: SOLR-2141-sample.patch
Edward,
Maybe I'm missing something, but I couldn't reproduce the problem you mentioned using attached short sample.
Please modify the attached file and reproduce it to share your problem.
> 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
> Attachments: 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.
-
You can reply to this email to add a comment to the issue online.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@lucene.apache.org
For additional commands, e-mail: dev-help@lucene.apache.org