You are viewing a plain text version of this content. The canonical link for it is here.
Posted to solr-user@lucene.apache.org by Julio Castillo <jc...@edgenuity.com> on 2008/05/21 02:57:14 UTC
Exception on the use of dataimport.jar in Full Import Example
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?
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.
3) at what point in time is the hsqldb dB supposed to be populated?
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.
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.<init>(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.
Re: Exception on the use of dataimport.jar in Full Import Example
Posted by Shalin Shekhar Mangar <sh...@gmail.com>.
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
<jc...@edgenuity.com> 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:jcastillo@edgenuity.com]
> 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:jcastillo@edgenuity.com]
> 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:noble.paul@gmail.com]
> 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 <jc...@edgenuity.com>
> 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.
RE: Exception on the use of dataimport.jar in Full Import Example
Posted by Julio Castillo <jc...@edgenuity.com>.
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:jcastillo@edgenuity.com]
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:jcastillo@edgenuity.com]
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:noble.paul@gmail.com]
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 <jc...@edgenuity.com>
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
RE: Exception on the use of dataimport.jar in Full Import Example
Posted by Julio Castillo <jc...@edgenuity.com>.
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:jcastillo@edgenuity.com]
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:noble.paul@gmail.com]
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 <jc...@edgenuity.com>
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
RE: Exception on the use of dataimport.jar in Full Import Example
Posted by Julio Castillo <jc...@edgenuity.com>.
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:noble.paul@gmail.com]
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 <jc...@edgenuity.com>
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
Re: Exception on the use of dataimport.jar in Full Import Example
Posted by Noble Paul നോബിള് नोब्ळ् <no...@gmail.com>.
On Wed, May 21, 2008 at 6:27 AM, Julio Castillo <jc...@edgenuity.com> 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.<init>(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