Dear Erick,
I am using Solr 1.4 version. Yes, for each row , we will get one fileNo
which is the primary key for the table "file".
No, I intentionally removed the <field column="fileNo" name="id"> from the
data-config.xml
I tried opening the dataimport.jsp to debug but I don't know, it doesn't
show any result but it updates the log file every time I tried to debug.
Regards,
Serenity
On Tue, May 3, 2011 at 11:42 AM, Erick Erickson <erickerick...@gmail.com>wrote:
> The next thing to check is if your select statement returns the
> fileNo for every field.
>
> Wait.. You took out the <field column="fileNo" name="id"> bit of your
> entity
> definition, is that a cut/paste error?
>
> You might get some joy from the DIH debug page at:
> <solr home>solr/admin/dataimport.jsp
> it's not very well known, but it's a debug console for
> your SQL data import process.
>
>
> BTW, what version of Solr are you using?
>
> Best
> Erick
>
> On Tue, May 3, 2011 at 12:04 PM, serenity keningston
> <serenity.kenings...@gmail.com> wrote:
> > Dear Stefan,
> >
> > Am still getting the following error message even after including the
> > pk-Attribute to the query :
> >
> > WARNING: Error creating document :
> > SolrInputDocument[{lname=lname(1.0)={cindy}, file=file(1.0)={
> > http://localhost:8084/Access/UploadFiles/laura.mp3},
> > fname=fname(1.0)={troutman}}]
> > org.apache.solr.common.SolrException: Document [null] missing required
> > field: id
> > at
> >
> org.apache.solr.update.DocumentBuilder.toDocument(DocumentBuilder.java:305)
> > at
> >
> org.apache.solr.update.processor.RunUpdateProcessor.processAdd(RunUpdateProcessorFactory.java:60)
> > at
> > org.apache.solr.handler.dataimport.SolrWriter.upload(SolrWriter.java:75)
> > at
> >
> org.apache.solr.handler.dataimport.DataImportHandler$1.upload(DataImportHandler.java:292)
> > at
> >
> org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:392)
> > 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)
> >
> >
> > and here is the data-config.xml file :
> >
> > <dataConfig>
> > <dataSource driver="com.mysql.jdbc.Driver"
> > url="jdbc:mysql://localhost:3306/mp3"
> > user="root"
> > password="root" />
> > <document>
> > <entity name="file" pk="fileNo" query="select fname, lname, file,
> fileNo
> > from mp3.file">
> >
> > <field column="fname" name="fname" />
> > <field column="lname" name="lname" />
> > <field column="file" name="file" />
> > </entity>
> > </document>
> > </dataConfig>
> >
> > Regards,
> > Serenity
> >
> > On Tue, May 3, 2011 at 10:43 AM, Stefan Matheis <
> > matheis.ste...@googlemail.com> wrote:
> >
> >> Serenity,
> >>
> >> there is no field fileNo in your SELECT-Query? you've defined it in
> >> the pk-Attribut of the <entity> Tag, but it's also required in the
> >> Query itself. just to note it: you can skip your <field> definition,
> >> if the query returns the field with exactly the same name as the
> >> solr-schema requires it.
> >>
> >> Regards
> >> Stefan
> >>
> >> On Tue, May 3, 2011 at 5:38 PM, serenity keningston
> >> <serenity.kenings...@gmail.com> wrote:
> >> > Hello Friends,
> >> >
> >> >
> >> > I am new to Solr and experiencing issue while trying to use
> >> > DataImportHandler. I added the required fields to schema.xml file and
> >> here
> >> > is my data-config.xml file :
> >> >
> >> > <dataConfig>
> >> > <dataSource driver="com.mysql.jdbc.Driver"
> >> > url="jdbc:mysql://localhost:3306/mp3"
> >> > user="root"
> >> > password="root" />
> >> > <document>
> >> > <entity name="file" pk="fileNo" query="select fname, lname, file
> from
> >> > mp3.file">
> >> > <field column="fileNo" name="id"/>
> >> > <field column="fname" name="fname" />
> >> > <field column="lname" name="lname" />
> >> > <field column="file" name="file" />
> >> > </entity>
> >> > </document>
> >> > </dataConfig>
> >> >
> >> > I am getting the following errors :
> >> >
> >> > org.apache.solr.common.SolrException: Document [null] missing required
> >> > field: id
> >> >
> >> > solr home defaulted to 'solr/' (could not find system property or
> JNDI)
> >> > May 3, 2011 9:59:08 AM org.apache.solr.core.SolrResourceLoader <init>
> >> > INFO: Solr home set to 'solr/'
> >> >
> >> > DataImportHandler can extract the information from the database and it
> is
> >> > displayed in log file, however, it is not indexing the data. Can
> anyone
> >> > please let me know, where I am commiting mistake ?
> >> >
> >> > Regards,
> >> > Serenity
> >> >
> >>
> >
>
