You are viewing a plain text version of this content. The canonical link for it is here.
Posted to general@lucene.apache.org by Romi <ro...@gmail.com> on 2011/05/12 09:30:37 UTC
how to integrate Solr for search into my Ecommerce application
Hi, i want to integrate Solr for search into my Ecommerce application.i want
to know how can i do it.
-----
Romi
--
View this message in context: http://lucene.472066.n3.nabble.com/how-to-integrate-Solr-for-search-into-my-Ecommerce-application-tp2930815p2930815.html
Sent from the Lucene - General mailing list archive at Nabble.com.
Re: how to integrate Solr for search into my Ecommerce application
Posted by Romi <ro...@gmail.com>.
Thanks Mirko Kämpf, Its not an individual project, that is why i can not
share it with you. it will b grateful to u if u help me out this way only.
-----
Romi
--
View this message in context: http://lucene.472066.n3.nabble.com/how-to-integrate-Solr-for-search-into-my-Ecommerce-application-tp2930815p2947041.html
Sent from the Lucene - General mailing list archive at Nabble.com.
Re: how to integrate Solr for search into my Ecommerce application
Posted by Mirko Kämpf <mi...@googlemail.com>.
Hello Romi,
if you are interested, we could support you in your project. But, I would
like to have a
short look at your existing webshop. What is its address?
We are running an "online project office server" so we have the ability to
share documents and manage all tasks around the project webbased without
costs. If you want, we can install your SOLR server for free on your own
machine. For some testing (3 months) we can also run it on our server for
free. Additional customization will be done by our experts as you need it.
Please send me a mail to: mirko.kaempf@it-saxonia.de, if you are interested
in a joined project.
Best wishes from Germany,
Mirko
2011/5/16 Romi <ro...@gmail.com>
> Mine is a Commercial application, it is a E commerce application(on line
> Jewelery shop ), i need to implement search of any type of jewelery...and
> the requirement is to implement it using solr. we are using MySQL as our
> database.
>
> -----
> Romi
> --
> View this message in context:
> http://lucene.472066.n3.nabble.com/how-to-integrate-Solr-for-search-into-my-Ecommerce-application-tp2930815p2946724.html
> Sent from the Lucene - General mailing list archive at Nabble.com.
>
Re: how to integrate Solr for search into my Ecommerce application
Posted by Grant Ingersoll <gs...@apache.org>.
Typically, you can use the Data Import Handler (or a custom tool) to get content from MySQL into Solr. Then, you just need to have your application hit Solr when it needs to do a search.
On May 16, 2011, at 3:02 AM, Romi wrote:
> Mine is a Commercial application, it is a E commerce application(on line
> Jewelery shop ), i need to implement search of any type of jewelery...and
> the requirement is to implement it using solr. we are using MySQL as our
> database.
>
> -----
> Romi
> --
> View this message in context: http://lucene.472066.n3.nabble.com/how-to-integrate-Solr-for-search-into-my-Ecommerce-application-tp2930815p2946724.html
> Sent from the Lucene - General mailing list archive at Nabble.com.
--------------------------------------------
Grant Ingersoll
Join the LUCENE REVOLUTION
Lucene & Solr User Conference
May 25-26, San Francisco
www.lucenerevolution.org
Re: how to integrate Solr for search into my Ecommerce application
Posted by Romi <ro...@gmail.com>.
Mine is a Commercial application, it is a E commerce application(on line
Jewelery shop ), i need to implement search of any type of jewelery...and
the requirement is to implement it using solr. we are using MySQL as our
database.
-----
Romi
--
View this message in context: http://lucene.472066.n3.nabble.com/how-to-integrate-Solr-for-search-into-my-Ecommerce-application-tp2930815p2946724.html
Sent from the Lucene - General mailing list archive at Nabble.com.
Re: how to integrate Solr for search into my Ecommerce application
Posted by Grant Ingersoll <gs...@apache.org>.
Can you tell us a bit more on what your eCom app is? Data in a DB? What feature requirements do you have?
You might find some of the stuff at http://www.lucidimagination.com/search/?q=ecommerce helpful.
On May 12, 2011, at 3:30 AM, Romi wrote:
> Hi, i want to integrate Solr for search into my Ecommerce application.i want
> to know how can i do it.
>
> -----
> Romi
> --
> View this message in context: http://lucene.472066.n3.nabble.com/how-to-integrate-Solr-for-search-into-my-Ecommerce-application-tp2930815p2930815.html
> Sent from the Lucene - General mailing list archive at Nabble.com.
--------------------------------------------
Grant Ingersoll
Join the LUCENE REVOLUTION
Lucene & Solr User Conference
May 25-26, San Francisco
www.lucenerevolution.org
Re: how to integrate Solr for search into my Ecommerce application
Posted by Romi <ro...@gmail.com>.
I tried to subscribe via mail, but its not getting connected. please solve my
problam here.
my db-data-config.xml is :
<dataConfig>
<dataSource type="JdbcDataSource" driver="org.gjt.mm.mysql.Driver"
url="jdbc:mysql://192.168.1.9:3306/angara" user="root" password="ampliflex"
/>
<document>
<entity name="tdiamonds" query="select UID_PK from
tdiamonds"
<field column="UID_PK" name="name" />
</entity>
</document>
</dataConfig>
Romi wrote:
>
> Thanks Doron Cohen-2, now i am posting my problem there. please support me
> there
>
and i did necessary changes in schema.xml and solrconfig.xml, but still i
am getting some exception. and its not clear to me what it is all about,
please give me some suggestion.
-----
Romi
--
View this message in context: http://lucene.472066.n3.nabble.com/how-to-integrate-Solr-for-search-into-my-Ecommerce-application-tp2930815p2956257.html
Sent from the Lucene - General mailing list archive at Nabble.com.
Re: how to integrate Solr for search into my Ecommerce application
Posted by Romi <ro...@gmail.com>.
Thanks Doron Cohen-2, now i am posting my problem there. please support me
there
-----
Romi
--
View this message in context: http://lucene.472066.n3.nabble.com/how-to-integrate-Solr-for-search-into-my-Ecommerce-application-tp2930815p2956009.html
Sent from the Lucene - General mailing list archive at Nabble.com.
Re: how to integrate Solr for search into my Ecommerce application
Posted by Doron Cohen <cd...@gmail.com>.
Hi Romi,
Grant Ingersoll-2: i could not get what are you saying to do me.
> Romi
Grant was suggesting that you ask this question in a more suitable mailing
list - solr-user@lucene.apache.org,
because this mailing list - general@lucene.apache.org - is for discussing
more general aspects of Lucene and Solr.
For instructions on subscribing to solr-user mailing list see:
http://lucene.apache.org/solr/mailing_lists.html
Regards,
Doron
Re: how to integrate Solr for search into my Ecommerce application
Posted by Romi <ro...@gmail.com>.
Grant Ingersoll-2: i could not get what are you saying to do me.
-----
Romi
--
View this message in context: http://lucene.472066.n3.nabble.com/how-to-integrate-Solr-for-search-into-my-Ecommerce-application-tp2930815p2955797.html
Sent from the Lucene - General mailing list archive at Nabble.com.
Re: how to integrate Solr for search into my Ecommerce application
Posted by Grant Ingersoll <gs...@apache.org>.
At this point, I would suggest asking on solr-user@lucene.apache.org. It has a lot more subscribers. From the looks of it, you have a malformed XML doc.
On May 17, 2011, at 9:25 AM, Romi wrote:
> Thanks for replying. I have read
> http://wiki.apache.org/solr/DataImportHandler, and have done the nessary
> changes for configuring database.
>
> I am getting the following exception, i want to know what i am missing
> here:
> Severe errors in solr configuration.
>
> Check your log files for more detailed information on what may be wrong.
>
> If you want solr to continue after configuration errors, change:
>
> <abortOnConfigurationError>false</abortOnConfigurationError>
>
> in solr.xml
>
> -------------------------------------------------------------
> org.apache.solr.handler.dataimport.DataImportHandlerException: Exception
> occurred while initializing context
> at
> org.apache.solr.handler.dataimport.DataImporter.loadDataConfig(DataImporter.java:190)
> at
> org.apache.solr.handler.dataimport.DataImporter.<init>(DataImporter.java:101)
> at
> org.apache.solr.handler.dataimport.DataImportHandler.inform(DataImportHandler.java:113)
> at
> org.apache.solr.core.SolrResourceLoader.inform(SolrResourceLoader.java:486)
> at org.apache.solr.core.SolrCore.<init>(SolrCore.java:588)
> at org.apache.solr.core.CoreContainer.create(CoreContainer.java:428)
> at org.apache.solr.core.CoreContainer.load(CoreContainer.java:278)
> at
> org.apache.solr.core.CoreContainer$Initializer.initialize(CoreContainer.java:117)
> at
> org.apache.solr.servlet.SolrDispatchFilter.init(SolrDispatchFilter.java:83)
> at org.mortbay.jetty.servlet.FilterHolder.doStart(FilterHolder.java:99)
> at org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:40)
> at
> org.mortbay.jetty.servlet.ServletHandler.initialize(ServletHandler.java:594)
> at org.mortbay.jetty.servlet.Context.startContext(Context.java:139)
> at
> org.mortbay.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1218)
> at
> org.mortbay.jetty.handler.ContextHandler.doStart(ContextHandler.java:500)
> at org.mortbay.jetty.webapp.WebAppContext.doStart(WebAppContext.java:448)
> at org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:40)
> at
> org.mortbay.jetty.handler.HandlerCollection.doStart(HandlerCollection.java:147)
> at
> org.mortbay.jetty.handler.ContextHandlerCollection.doStart(ContextHandlerCollection.java:161)
> at org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:40)
> at
> org.mortbay.jetty.handler.HandlerCollection.doStart(HandlerCollection.java:147)
> at org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:40)
> at
> org.mortbay.jetty.handler.HandlerWrapper.doStart(HandlerWrapper.java:117)
> at org.mortbay.jetty.Server.doStart(Server.java:210)
> at org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:40)
> at org.mortbay.xml.XmlConfiguration.main(XmlConfiguration.java:929)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
> at java.lang.reflect.Method.invoke(Unknown Source)
> at org.mortbay.start.Main.invokeMain(Main.java:183)
> at org.mortbay.start.Main.start(Main.java:497)
> at org.mortbay.start.Main.main(Main.java:115)
> Caused by: org.xml.sax.SAXParseException: Element type "entity" must be
> followed by either attribute specifications, ">" or "/>".
> at com.sun.org.apache.xerces.internal.parsers.DOMParser.parse(Unknown
> Source)
> at
> com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderImpl.parse(Unknown
> Source)
> at
> org.apache.solr.handler.dataimport.DataImporter.loadDataConfig(DataImporter.java:178)
>
> Grant Ingersoll-2 wrote:
>>
>> On May 17, 2011, at 9:04 AM, Romi wrote:
>>
>>> I configured Import Handler, i did the necessary changes
>>> db-data-config.xml
>>> as i changed <dataSource driver="" url=""> tag.
>>> I wanted to know:
>>> in C:\apache-solr-1.4.0\example\example-DIH\solr\db\lib there is
>>> hsqldb-1.8.0.10.jar, but my database is MySql do i need to put its jar in
>>> to
>>> dis path, what other changes i need to do.
>>
>> Yes, you need your DB driver to be in the lib. I would suggest reading
>> http://wiki.apache.org/solr/DataImportHandler
>> as well as following the broader Solr tutorial. I would also recommend
>> you pick up Smiley and Pugh's Solr 1.4 book.
>>
>>>
>>> Romi wrote:
>>>>
>>>> Hi, i want to integrate Solr for search into my Ecommerce application.i
>>>> want to know how can i do it.
>>>>
>>>
>>>
>>> -----
>>> Romi
>>> --
>>> View this message in context:
>>> http://lucene.472066.n3.nabble.com/how-to-integrate-Solr-for-search-into-my-Ecommerce-application-tp2930815p2952405.html
>>> Sent from the Lucene - General mailing list archive at Nabble.com.
>>
>> --------------------------
>> Grant Ingersoll
>> Lucene Revolution -- Lucene and Solr User Conference
>> May 25-26 in San Francisco
>> www.lucenerevolution.org
>>
>
>
> -----
> Romi
> --
> View this message in context: http://lucene.472066.n3.nabble.com/how-to-integrate-Solr-for-search-into-my-Ecommerce-application-tp2930815p2952496.html
> Sent from the Lucene - General mailing list archive at Nabble.com.
--------------------------
Grant Ingersoll
Lucene Revolution -- Lucene and Solr User Conference
May 25-26 in San Francisco
www.lucenerevolution.org
Re: how to integrate Solr for search into my Ecommerce application
Posted by Romi <ro...@gmail.com>.
Thanks for replying. I have read
http://wiki.apache.org/solr/DataImportHandler, and have done the nessary
changes for configuring database.
I am getting the following exception, i want to know what i am missing
here:
Severe errors in solr configuration.
Check your log files for more detailed information on what may be wrong.
If you want solr to continue after configuration errors, change:
<abortOnConfigurationError>false</abortOnConfigurationError>
in solr.xml
-------------------------------------------------------------
org.apache.solr.handler.dataimport.DataImportHandlerException: Exception
occurred while initializing context
at
org.apache.solr.handler.dataimport.DataImporter.loadDataConfig(DataImporter.java:190)
at
org.apache.solr.handler.dataimport.DataImporter.<init>(DataImporter.java:101)
at
org.apache.solr.handler.dataimport.DataImportHandler.inform(DataImportHandler.java:113)
at
org.apache.solr.core.SolrResourceLoader.inform(SolrResourceLoader.java:486)
at org.apache.solr.core.SolrCore.<init>(SolrCore.java:588)
at org.apache.solr.core.CoreContainer.create(CoreContainer.java:428)
at org.apache.solr.core.CoreContainer.load(CoreContainer.java:278)
at
org.apache.solr.core.CoreContainer$Initializer.initialize(CoreContainer.java:117)
at
org.apache.solr.servlet.SolrDispatchFilter.init(SolrDispatchFilter.java:83)
at org.mortbay.jetty.servlet.FilterHolder.doStart(FilterHolder.java:99)
at org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:40)
at
org.mortbay.jetty.servlet.ServletHandler.initialize(ServletHandler.java:594)
at org.mortbay.jetty.servlet.Context.startContext(Context.java:139)
at
org.mortbay.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1218)
at
org.mortbay.jetty.handler.ContextHandler.doStart(ContextHandler.java:500)
at org.mortbay.jetty.webapp.WebAppContext.doStart(WebAppContext.java:448)
at org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:40)
at
org.mortbay.jetty.handler.HandlerCollection.doStart(HandlerCollection.java:147)
at
org.mortbay.jetty.handler.ContextHandlerCollection.doStart(ContextHandlerCollection.java:161)
at org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:40)
at
org.mortbay.jetty.handler.HandlerCollection.doStart(HandlerCollection.java:147)
at org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:40)
at
org.mortbay.jetty.handler.HandlerWrapper.doStart(HandlerWrapper.java:117)
at org.mortbay.jetty.Server.doStart(Server.java:210)
at org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:40)
at org.mortbay.xml.XmlConfiguration.main(XmlConfiguration.java:929)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.mortbay.start.Main.invokeMain(Main.java:183)
at org.mortbay.start.Main.start(Main.java:497)
at org.mortbay.start.Main.main(Main.java:115)
Caused by: org.xml.sax.SAXParseException: Element type "entity" must be
followed by either attribute specifications, ">" or "/>".
at com.sun.org.apache.xerces.internal.parsers.DOMParser.parse(Unknown
Source)
at
com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderImpl.parse(Unknown
Source)
at
org.apache.solr.handler.dataimport.DataImporter.loadDataConfig(DataImporter.java:178)
Grant Ingersoll-2 wrote:
>
> On May 17, 2011, at 9:04 AM, Romi wrote:
>
>> I configured Import Handler, i did the necessary changes
>> db-data-config.xml
>> as i changed <dataSource driver="" url=""> tag.
>> I wanted to know:
>> in C:\apache-solr-1.4.0\example\example-DIH\solr\db\lib there is
>> hsqldb-1.8.0.10.jar, but my database is MySql do i need to put its jar in
>> to
>> dis path, what other changes i need to do.
>
> Yes, you need your DB driver to be in the lib. I would suggest reading
> http://wiki.apache.org/solr/DataImportHandler
> as well as following the broader Solr tutorial. I would also recommend
> you pick up Smiley and Pugh's Solr 1.4 book.
>
>>
>> Romi wrote:
>>>
>>> Hi, i want to integrate Solr for search into my Ecommerce application.i
>>> want to know how can i do it.
>>>
>>
>>
>> -----
>> Romi
>> --
>> View this message in context:
>> http://lucene.472066.n3.nabble.com/how-to-integrate-Solr-for-search-into-my-Ecommerce-application-tp2930815p2952405.html
>> Sent from the Lucene - General mailing list archive at Nabble.com.
>
> --------------------------
> Grant Ingersoll
> Lucene Revolution -- Lucene and Solr User Conference
> May 25-26 in San Francisco
> www.lucenerevolution.org
>
-----
Romi
--
View this message in context: http://lucene.472066.n3.nabble.com/how-to-integrate-Solr-for-search-into-my-Ecommerce-application-tp2930815p2952496.html
Sent from the Lucene - General mailing list archive at Nabble.com.
Re: how to integrate Solr for search into my Ecommerce application
Posted by Grant Ingersoll <gs...@apache.org>.
On May 17, 2011, at 9:04 AM, Romi wrote:
> I configured Import Handler, i did the necessary changes db-data-config.xml
> as i changed <dataSource driver="" url=""> tag.
> I wanted to know:
> in C:\apache-solr-1.4.0\example\example-DIH\solr\db\lib there is
> hsqldb-1.8.0.10.jar, but my database is MySql do i need to put its jar in to
> dis path, what other changes i need to do.
Yes, you need your DB driver to be in the lib. I would suggest reading http://wiki.apache.org/solr/DataImportHandler
as well as following the broader Solr tutorial. I would also recommend you pick up Smiley and Pugh's Solr 1.4 book.
>
> Romi wrote:
>>
>> Hi, i want to integrate Solr for search into my Ecommerce application.i
>> want to know how can i do it.
>>
>
>
> -----
> Romi
> --
> View this message in context: http://lucene.472066.n3.nabble.com/how-to-integrate-Solr-for-search-into-my-Ecommerce-application-tp2930815p2952405.html
> Sent from the Lucene - General mailing list archive at Nabble.com.
--------------------------
Grant Ingersoll
Lucene Revolution -- Lucene and Solr User Conference
May 25-26 in San Francisco
www.lucenerevolution.org
Re: how to integrate Solr for search into my Ecommerce application
Posted by Romi <ro...@gmail.com>.
I configured Import Handler, i did the necessary changes db-data-config.xml
as i changed <dataSource driver="" url=""> tag.
I wanted to know:
in C:\apache-solr-1.4.0\example\example-DIH\solr\db\lib there is
hsqldb-1.8.0.10.jar, but my database is MySql do i need to put its jar in to
dis path, what other changes i need to do.
Romi wrote:
>
> Hi, i want to integrate Solr for search into my Ecommerce application.i
> want to know how can i do it.
>
-----
Romi
--
View this message in context: http://lucene.472066.n3.nabble.com/how-to-integrate-Solr-for-search-into-my-Ecommerce-application-tp2930815p2952405.html
Sent from the Lucene - General mailing list archive at Nabble.com.
Re: how to integrate Solr for search into my Ecommerce application
Posted by Mirko Kämpf <mi...@googlemail.com>.
Hi Romi,
there are several ways to do this. It depends on the datasources (database
or xml or documents and on the types of query you want).
We have done such a project, based on the webshop Gambio (or xt:commerce)
What systems do you have?
Is it commercial or a educational project?
Best wishes Halle
Mirko
2011/5/12 Romi <ro...@gmail.com>
> Hi, i want to integrate Solr for search into my Ecommerce application.i
> want
> to know how can i do it.
>
> -----
> Romi
> --
> View this message in context:
> http://lucene.472066.n3.nabble.com/how-to-integrate-Solr-for-search-into-my-Ecommerce-application-tp2930815p2930815.html
> Sent from the Lucene - General mailing list archive at Nabble.com.
>