First of all, apologies if you get this twice. I posted it by email an hour ago but it hasn't appeared in any of the archives, so I'm worried it's got junked somewhere.
I'm trying to use a DataImportHandler to merge some data from a database with some other fields from a collection of XML files, rather like the example in the Architecture section here: http://wiki.apache.org/solr/DataImportHandler ... so a given document is built from some fields from the database and some from the XML. My dataconfig.xml looks like this: <dataConfig> <dataSource name="database" driver="org.postgresql.Driver" url="jdbc:postgresql://cathdb.info/cathdb_v3_3_0" user="cathreader" password="cathreader" /> <dataSource name="filesystem" type="FileDataSource" basePath="/cath/people/cathdata/v3_3_0/pdb-XML-noatom/" encoding="UTF-8" connectionTimeout="5000" readTimeout="10000"/> <document name="domain"> <entity name="domain" dataSource="database" query="select domain_id as id, 'PDB code ' || pdb_code || ', chain ' || chain_code || ', domain ' || domain_code as title, 'some keywords go here' as keywords, pdb_code || ' ' || chain_id as related_ids, 'domain' as doc_type, pdb_code from domain"> <entity dataSource="filesystem" name="domain_pdb" url="${domain.pdb_code}-noatom.xml"> <field column="content" xpath="//*[local-name()='structCategory']/*[local-name()='struct']/*[local-name()='title']" /> </entity> </entity> </document> </dataConfig> This works if I comment out the inner entity, but when I uncomment it, I get this error: 30-Jul-2009 14:32:50 org.apache.solr.handler.dataimport.DocBuilder buildDocument SEVERE: Exception while processing: domain document : SolrInputDocument[{id=id(1.0)={1s32D00}, title=title(1.0)={PDB code 1s32, chain D, domain 00}, keywords=keywords(1.0)={some ke ywords go here}, pdb_code=pdb_code(1.0)={1s32}, doc_type=doc_type(1.0)={domain}, related_ids=related_ids(1.0)={1s32 1s32D}}] org.apache.solr.handler.dataimport.DataImportHandlerException: java.lang.NullPointerException at org.apache.solr.handler.dataimport.SqlEntityProcessor.initQuery(SqlEntityProcessor.java:64) 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:344) at org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:372) at org.apache.solr.handler.dataimport.DocBuilder.doFullDump(DocBuilder.java:225) at org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:167) at org.apache.solr.handler.dataimport.DataImporter.doFullImport(DataImporter.java:333) at org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:393) at org.apache.solr.handler.dataimport.DataImporter$1.run(DataImporter.java:372) Caused by: java.lang.NullPointerException at java.io.File.<init>(File.java:222) at org.apache.solr.handler.dataimport.FileDataSource.getData(FileDataSource.java:75) at org.apache.solr.handler.dataimport.FileDataSource.getData(FileDataSource.java:44) at org.apache.solr.handler.dataimport.SqlEntityProcessor.initQuery(SqlEntityProcessor.java:58) ... 9 more I have checked that the file /cath/people/cathdata/v3_3_0/pdb-XML-noatom/1s32-noatom.xml is readable, so maybe the full path to the file isn't being constructed properly or something? I also tried with the full path template for the file in the entity url attribute, instead of using a basePath in the dataSource, but I get exactly the same exception. This is with the 2009-07-30 nightly build. See attached for schema. http://www.nabble.com/file/p24739580/schema.xml schema.xml Any ideas? Thanks in advance! Andrew. -- :: http://biotext.org.uk/ :: -- View this message in context: http://www.nabble.com/NullPointerException-in-DataImportHandler-tp24739580p24739580.html Sent from the Solr - User mailing list archive at Nabble.com.