The error I am getting is "Unable to read dataimport.properties" - I have put
the full text below.
Jun 24, 2009 8:22:18 AM org.apache.solr.core.SolrCore execute
INFO: [] webapp=/solr path=/dataimport params={} status=0 QTime=1
Jun 24, 2009 8:22:43 AM org.apache.solr.handler.dataimport.DataImportHandler
processConfiguration
INFO: Processing configuration from solrconfig.xml:
{config=/usr/local/tomcat6.0.20/webapps/solr/data-config.xml}
Jun 24, 2009 8:22:43 AM org.apache.solr.handler.dataimport.DataImporter
loadDataConfig
INFO: Data Configuration loaded successfully
Jun 24, 2009 8:22:43 AM org.apache.solr.handler.dataimport.SolrWriter
readIndexerProperties
WARNING: Unable to read: dataimport.properties
Jun 24, 2009 8:22:43 AM org.apache.solr.handler.dataimport.DataImporter
doFullImport
INFO: Starting Full Import
Jun 24, 2009 8:22:43 AM org.apache.solr.handler.dataimport.SolrWriter
readIndexerProperties
WARNING: Unable to read: dataimport.properties
Jun 24, 2009 8:22:43 AM org.apache.solr.handler.dataimport.DataImporter
doFullImport
SEVERE: Full Import failed
org.apache.solr.handler.dataimport.DataImportHandlerException: Failed to
initialize DataSource: null Processing Document # 1
at
org.apache.solr.handler.dataimport.DataImporter.getDataSourceInstance(DataImporter.java:290)
at
org.apache.solr.handler.dataimport.ContextImpl.getDataSource(ContextImpl.java:93)
at
org.apache.solr.handler.dataimport.SqlEntityProcessor.init(SqlEntityProcessor.java:52)
at
org.apache.solr.handler.dataimport.EntityProcessorWrapper.init(EntityProcessorWrapper.java:66)
at
org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:297)
at
org.apache.solr.handler.dataimport.DocBuilder.doFullDump(DocBuilder.java:224)
at
org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:167)
at
org.apache.solr.handler.dataimport.DataImporter.doFullImport(DataImporter.java:316)
at
org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:376)
at
org.apache.solr.handler.dataimport.DataImportHandler.handleRequestBody(DataImportHandler.java:187)
at
org.apache.solr.handler.RequestHandlerBase.handleRequest(RequestHandlerBase.java:131)
at org.apache.solr.core.SolrCore.execute(SolrCore.java:1290)
at
org.apache.solr.servlet.SolrDispatchFilter.execute(SolrDispatchFilter.java:341)
at
org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilter.java:244)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
at java.lang.Thread.run(Thread.java:619)
Caused by: org.apache.solr.common.SolrException: Could not load driver:
com.mysql.jdbc.Driver
at
org.apache.solr.handler.dataimport.JdbcDataSource.createConnectionFactory(JdbcDataSource.java:111)
at
org.apache.solr.handler.dataimport.JdbcDataSource.init(JdbcDataSource.java:61)
at
org.apache.solr.handler.dataimport.DataImporter.getDataSourceInstance(DataImporter.java:288)
... 25 more
Caused by: java.lang.ClassNotFoundException: Unable to load
com.mysql.jdbc.Driver or
org.apache.solr.handler.dataimport.com.mysql.jdbc.Driver
at
org.apache.solr.handler.dataimport.DocBuilder.loadClass(DocBuilder.java:715)
at
org.apache.solr.handler.dataimport.JdbcDataSource.createConnectionFactory(JdbcDataSource.java:109)
... 27 more
Caused by: org.apache.solr.common.SolrException: Error loading class
'com.mysql.jdbc.Driver'
at
org.apache.solr.core.SolrResourceLoader.findClass(SolrResourceLoader.java:310)
at
org.apache.solr.handler.dataimport.DocBuilder.loadClass(DocBuilder.java:705)
... 28 more
Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
at java.net.FactoryURLClassLoader.loadClass(URLClassLoader.java:592)
at java.lang.ClassLoader.loadClass(ClassLoader.java:251)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:247)
at
org.apache.solr.core.SolrResourceLoader.findClass(SolrResourceLoader.java:294)
... 29 more
Jun 24, 2009 8:22:43 AM org.apache.solr.update.DirectUpdateHandler2 rollback
INFO: start rollback
Jun 24, 2009 8:22:43 AM org.apache.solr.update.DirectUpdateHandler2 rollback
INFO: end_rollback
Jun 24, 2009 8:22:43 AM org.apache.solr.core.SolrCore execute
INFO: [] webapp=/solr path=/dataimport
params={verbose=true&command=full-import&debug=on} status=0 QTime=21
Jun 24, 2009 8:22:43 AM org.apache.solr.core.SolrCore execute
INFO: [] webapp=/solr path=/dataimport params={command=show-config} status=0
QTime=1
-----Original Message-----
From: Shalin Shekhar Mangar [mailto:shalinman...@gmail.com]
Sent: Tuesday, June 23, 2009 11:48 AM
To: solr-user@lucene.apache.org
Subject: Re: Data Import Handler
On Tue, Jun 23, 2009 at 7:12 PM, Mukerjee, Neiloy (Neil) <
neil.muker...@alcatel-lucent.com> wrote:
> With the data-config file filled out, I am receiving errors telling me that
> the indexing of my database has failed. I think I have filled out everything
> I need to in the data-config file and that I have everything in the right
> directory. My details are described below, including locations of files,
> contents of the data-config file, and the errors I am seeing. Has anyone
> else seen problems like this?
>
What error are you seeing? Can you please post the stack trace?
> As of right now, I have data-config.xml in
> /usr/local/tomcat6.0.20/webapps/solr/, and I have the database bell_labs.sql
> in the solr/home directory /usr/local/tomcat6.0.20/solr/.
What is bell_labs.sql? DataImportHandler imports from databases not from sql
dumps. Is your database jdbc:mysql://localhost/bell_labs running?
> Data-config.xml has the following contents:
> <dataConfig>
> <dataSource type="JdbcDataSource" driver="com.mysql.jdbc.Driver"
> url="jdbc:mysql://localhost/bell_labs" user="root" password="********"/>
> <document name="bell_labs">
> <entity name="employees" query="select InternalEID, Pref, Name,
> FirstName, CSL, Email, cilLogin from employees">
> <field column="InternalEID" name="InternalEID" />
> <field column="Pref" name="Pref" />
> <field column="Name" name="Name" />
> <field column="FirstName" name="FirstName" />
> <field column="CSL" name="CSL" />
> <field column="Email" name="Email" />
> <field column="cilLogin" name="cilLogin" />
> </entity>
> </document>
> </dataConfig>
>
Note that if the column name in your database and the name of the field in
Solr is same, then you do not need to write the 'name' attribute in the
field tags.
>
> When I go to http://localhost:8080/solr/dataimport, I see the following
> displayed to my browser:
> This XML file does not appear to have any style information associated with
> it. The document tree is shown below.
>
> <str name="">Indexing failed. Rolled back all changes.</str>
> <str name="Rolledback">2009-06-23 09:24:15</str>
> </lst>
>
It says that indexing failed. You should be able to see some exceptions in
the solr log. If you can post them here, we might be able to help you more.
--
Regards,
Shalin Shekhar Mangar.
