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
