Hi Julio, Please download the SOLR-469.patch (not the contrib patch) from the SOLR-469 jira issue and apply it to the latest trunk code. I apologize for not keeping the example in the wiki in sync with the latest code. Please let us know here if you face a problem.
On Wed, May 21, 2008 at 10:46 PM, Julio Castillo <[EMAIL PROTECTED]> wrote: > > You have to excuse me here, but I can't find the contrib sources. I have > nothing the apply the patch to. > > I used the following URL to get the SVN sources (per the website): > http://svn.apache.org/repos/asf/lucene/solr/. > > Sorry, I'm a newbie with Solr, but intend to use it to index my data on the > dB and very much need this patch. > > Thanks > > ** julio > > -----Original Message----- > From: Julio Castillo [mailto:[EMAIL PROTECTED] > Sent: Wednesday, May 21, 2008 10:00 AM > To: solr-user@lucene.apache.org > Subject: RE: Exception on the use of dataimport.jar in Full Import Example > > OK, I just downloaded the source tree and discovered that the sources for > the dataimport handler are not there. > I guess I have to download the SOLR-469-contrib.patch > > I suppose that later the source tree will have a contrib directory formally > and not as a patch? > > Thanks > > ** julio > > -----Original Message----- > From: Julio Castillo [mailto:[EMAIL PROTECTED] > Sent: Wednesday, May 21, 2008 9:37 AM > To: solr-user@lucene.apache.org > Subject: RE: Exception on the use of dataimport.jar in Full Import Example > > Noble Paul, > I took a look at the jar files included in the nightly builds and they do > not include the dataimport.jar content. So, I assume then that my best > approach is to download the corresponding dataimport sources used and build > my own dataimport.jar? > > Thanks > > ** julio > > -----Original Message----- > From: Noble Paul ??????? ?????? [mailto:[EMAIL PROTECTED] > Sent: Wednesday, May 21, 2008 1:47 AM > To: solr-user@lucene.apache.org > Subject: Re: Exception on the use of dataimport.jar in Full Import Example > > On Wed, May 21, 2008 at 6:27 AM, Julio Castillo <[EMAIL PROTECTED]> > wrote: > > I wanted to learn how to index data that I have on my dB. > > I followed the instructions on the wiki page for the Data Import > > Handler (Full Import Example -example-solr-home.jar). I got an > > exception running it as is (see below). > > > > Anyway, I have a couple of questions before addressing the source of > > the exception. > > > > 1) what is the purpose of the dataimport jar file? Is it used to > > populate the dB? > dataimport.jar contains the required classes for running dataimporthandler > (DIH). This sample app was built for people to get started with DIH easily. > This is not up to date. I recommend you use the latest patch and build a new > war file. > > 2) The dataimport.jar file is NOT included in the war file. Why is > > that? It was recommended that it be added if I already have an > > existing installation of my war file. > The war file is built with the patch applied , so the jar is not needed. The > jar was provided to avoid appltuning patch and building the war. > > 3) at what point in time is the hsqldb dB supposed to be populated? > The packaged stuff contains the hsql database prepopulated with with data . > Ensure that the jdbc url points to the actual db location > > > > Executing the URL http://localhost:2455/solr/db/dataimport > > I get a response with so to this degree is correctly configured. The > > exception happens when I attempt to execute the full-import command. > > > please ensure that the jdbc url provided is correct , especially the data > location > > Exception follows: > > > > SEVERE: The query failed 'select * from item' > > org.apache.solr.handler.dataimport.DataImportHandlerException: Unable > > to execute query: select * from item > > at > > org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.<i > > nit>(J > > dbcDataSource.java:166) > > ...... > > Caused by: java.sql.SQLException: Table not found in statement [select > > * from item] > > at org.hsqldb.jdbc.Util.sqlException(Unknown Source) > > > > Julio Castillo > > Edgenuity Inc. > > > > > > > > -- > --Noble Paul > -- Regards, Shalin Shekhar Mangar.
