Mailing-List: contact solr-user-help@lucene.apache.org; run by ezmlm
Precedence: bulk
Reply-To: solr-user@lucene.apache.org
Received-SPF: pass (athena.apache.org: domain of shalinmangar@gmail.com
 designates 74.125.46.29 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :content-type;
        b=HtlaR28TY/X5xFFl7gk7ZRPvgpUEZCvfCVlt76V+gDLGzCLN0gXOsYSspdBKOPq5hB
         rLHx1b2x0NwMwqUSumlLzGGONahjT1Yq6b+rgaD0Ess1If9PHbX7Y3Gg7QRO851umLh7
         gC+66I2rAErxBVZ1H4QcUdC3JSEPFDO8sp+Ho=
MIME-Version: 1.0
In-Reply-To: <SHIVA3sw8AcgQUgQL2000001544@shiva.CEIINDIA.COM>
References: <69de18140903050345v6ec4b9e7rcddbdb503c2edd46@mail.gmail.com>
	 <SHIVA3sw8AcgQUgQL2000001544@shiva.CEIINDIA.COM>
Date: Fri, 6 Mar 2009 00:23:35 +0530
Message-ID: <69de18140903051053n3fdc195cy9cdf6c5b6b2cae0f@mail.gmail.com>
Subject: Re: How to search the database tables using solr.
From: Shalin Shekhar Mangar <shalinmangar@gmail.com>
To: solr-user@lucene.apache.org, cradha@ceiindia.com
Content-Type: multipart/alternative; boundary=000e0cd2449a80efa0046463af85

--000e0cd2449a80efa0046463af85
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

On Thu, Mar 5, 2009 at 10:09 PM, Radha C. <cradha@ceiindia.com> wrote:

> I want to understand fully what is configured and how to configure , So I
> tried to index my local MySql DB directly with one simple table called
> persons in it.
> But I am getting lot of errors. the following are the steps I did,
> 1.   downloaded solr-2009-03-03.zip
> <http://people.apache.org/builds/lucene/solr/nightly/solr-2009-03-03.zip>
> distribution and extracted to d:/solrtemp/
> 2.   copied the example/solr to d:/solr ( this is my solr home ) for my
> application template.
> 3.   set this solr home insidecatalina-home/localconfig/solr.xml
> 4.   create the data-config under $solrhome/config
> here is my dataconfig file
> <dataConfig>
>    <dataSource driver="com.mysql.jdbc.Driver"
> url="jdbc:mysql://localhost:3306/test" user="xxx" password="xxxx" />
>    <document name="employees">
>            <entity name="persons" pk="personid" query="select * from
> persons" deltaQuery="select personID from persons where last_modified >
> '${dataimporter.last_index_time}'">
>    <field column="firstname"/>
>    <field column="lastName"/>
>    <field column="age"/>
>            </entity>
>    </document>
> </dataConfig>
>
>  I am not sure what needs to be done next. I am getting error when I start
> tomcat.


Just like you write DDL for databases, you need to define a schema in Solr
as well. The missing step is to change solr's schema.xml according to the
fields you want to index. Look at http://wiki.apache.org/solr/SchemaXml for
details.

The errors are a way of warning you that there are certain required fields
in schema which are never filled by the configuration in the data-config.


>
>
> Mar 5, 2009 9:10:28 PM org.apache.solr.handler.dataimport.DataImportHandler
> processConfiguration
> INFO: Processing configuration from solrconfig.xml:
> {config=data-config.xml}
> Mar 5, 2009 9:10:28 PM org.apache.solr.handler.dataimport.DataImporter
> loadDataConfig
> INFO: Data Configuration loaded successfully
> Mar 5, 2009 9:10:28 PM org.apache.solr.handler.dataimport.DataImporter
> verifyWithSchema
> INFO: id is a required field in SolrSchema . But not found in DataConfig
> Mar 5, 2009 9:10:28 PM org.apache.solr.handler.dataimport.DataImportHandler
> inform
> SEVERE: Exception while loading DataImporter
> org.apache.solr.handler.dataimport.DataImportHandlerException: There are
> errors in the Schema
> The field :age present in DataConfig does not have a counterpart in Solr
> Schema
> The field :firstname present in DataConfig does not have a counterpart in
> Solr Schema
> The field :personid present in DataConfig does not have a counterpart in
> Solr Schema
> The field :lastName present in DataConfig does not have a counterpart in
> Solr Schema
>        at
>
> org.apache.solr.handler.dataimport.DataImporter.<init>(DataImporter.java:108
> )
>        at
>
> org.apache.solr.handler.dataimport.DataImportHandler.inform(DataImportHandle
> r.java:95)
>        at
> org.apache.solr.core.SolrResourceLoader.inform(SolrResourceLoader.java:388)
>        at
>
> org.apache.solr.core.SolrCore.<init>(SolrCore.java:571).....................
> .
> Mar 5, 2009 9:10:28 PM org.apache.solr.servlet.SolrDispatchFilter init
> SEVERE: Could not start SOLR. Check solr/home property
> org.apache.solr.common.SolrException: FATAL: Could not create importer.
> DataImporter config invalid
>        at
>
> org.apache.solr.handler.dataimport.DataImportHandler.inform(DataImportHandle
> r.java:103)
>        at
> org.apache.solr.core.SolrResourceLoader.inform(SolrResourceLoader.java:388)
>
>        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
> Caused by: org.apache.solr.handler.dataimport.DataImportHandlerException:
> There are errors in the Schema
> The field :age present in DataConfig does not have a counterpart in Solr
> Schema
> The field :firstname present in DataConfig does not have a counterpart in
> Solr Schema
> The field :personid present in DataConfig does not have a counterpart in
> Solr Schema
> The field :lastName present in DataConfig does not have a counterpart in
> Solr Schema
>        at
>
> org.apache.solr.handler.dataimport.DataImporter.<init>(DataImporter.java:108
> )
>        at
>
> org.apache.solr.handler.dataimport.DataImportHandler.inform(DataImportHandle
> r.java:95)
>        ... 31 more
> Mar 5, 2009 9:10:28 PM org.apache.solr.core.QuerySenderListener newSearcher
>
> I want to write a small seperate application without relying on examples,
> can you provide me some useful steps how to do that.
>
> Thanks
>
>  _____
>
> From: Shalin Shekhar Mangar [mailto:shalinmangar@gmail.com]
> Sent: Thursday, March 05, 2009 5:16 PM
> To: solr-user@lucene.apache.org; cradha@ceiindia.com
> Subject: Re: How to search the database tables using solr.
>
>
> On Thu, Mar 5, 2009 at 4:42 PM, Radha C. <cradha@ceiindia.com> wrote:
>
>
>
> Hi,
>
> I am newbie for solr search engin. I don't find any juicy information on
> how
> to configure the ORACLE data base to index the tables using solr search
> engin. There are huge documents spread over wiki pages. I need some core
> information.
> I am using Apache-tomcat 5.5.26, and oracle 9i. Can you please provide me a
> brief details for installing and configuring the database with solr and how
> to indexing the rows. Your help will really save lot of my time.
>
>
>
>
> Have you been able to run the example/example-DIH demo? If yes, using
> Oracle
> database instead of the HSQLDB used in the example is easy. Substitute the
> driver name, username, password with the appropriate values for your
> database. Make sure you add the oracle driver's jar file to $solr_home/lib.
>
> --
> Regards,
> Shalin Shekhar Mangar.
>
>


-- 
Regards,
Shalin Shekhar Mangar.

--000e0cd2449a80efa0046463af85--