Hi,
i've set up and solr4 application and wanted to do an dataimport via DB. So
I'm using the DIH for the solr4 beta. If I go to the datahandler in the
admin/ panel, and click on import, I get the following messages in the log:
SEVERE: Full Import failed:java.lang.RuntimeException:
java.lang.RuntimeException:
org.apache.solr.handler.dataimport.DataImportHandlerException: Could not
load driver: com.mysql.jdbc.Driver Processing Document # 1
at
org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:273)
at
org.apache.solr.handler.dataimport.DataImporter.doFullImport(DataImporter.ja
va:382)
at
org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:448
)
at
org.apache.solr.handler.dataimport.DataImporter$1.run(DataImporter.java:429)
Caused by: java.lang.RuntimeException:
org.apache.solr.handler.dataimport.DataImportHandlerException: Could not
load driver: com.mysql.jdbc.Driver Processing Document # 1
at
org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:
413)
at
org.apache.solr.handler.dataimport.DocBuilder.doFullDump(DocBuilder.java:326
)
at
org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:234)
... 3 more
Caused by: org.apache.solr.handler.dataimport.DataImportHandlerException:
Could not load driver: com.mysql.jdbc.Driver Processing Document # 1
at
org.apache.solr.handler.dataimport.DataImportHandlerException.wrapAndThrow(D
ataImportHandlerException.java:71)
at
org.apache.solr.handler.dataimport.JdbcDataSource.createConnectionFactory(Jd
bcDataSource.java:114)
at
org.apache.solr.handler.dataimport.JdbcDataSource.init(JdbcDataSource.java:6
2)
at
org.apache.solr.handler.dataimport.DataImporter.getDataSourceInstance(DataIm
porter.java:354)
at
org.apache.solr.handler.dataimport.ContextImpl.getDataSource(ContextImpl.jav
a:99)
at
org.apache.solr.handler.dataimport.SqlEntityProcessor.init(SqlEntityProcesso
r.java:53)
at
org.apache.solr.handler.dataimport.EntityProcessorWrapper.init(EntityProcess
orWrapper.java:74)
at
org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:
430)
at
org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:
411)
... 5 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:899)
at
org.apache.solr.handler.dataimport.JdbcDataSource.createConnectionFactory(Jd
bcDataSource.java:112)
... 12 more
Caused by: org.apache.solr.common.SolrException: Error loading class
'com.mysql.jdbc.Driver'
at
org.apache.solr.core.SolrResourceLoader.findClass(SolrResourceLoader.java:43
8)
at
org.apache.solr.handler.dataimport.DocBuilder.loadClass(DocBuilder.java:889)
... 13 more
Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
at java.net.URLClassLoader$1.run(URLClassLoader.java:217)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:205)
at java.lang.ClassLoader.loadClass(ClassLoader.java:321)
at java.net.FactoryURLClassLoader.loadClass(URLClassLoader.java:615)
at java.lang.ClassLoader.loadClass(ClassLoader.java:266)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:334)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:264)
at
org.apache.solr.core.SolrResourceLoader.findClass(SolrResourceLoader.java:42
2)
... 14 more
Sep 19, 2012 8:58:59 PM org.apache.solr.update.DirectUpdateHandler2 rollback
INFO: start rollback{flags=0,_version_=0}
Sep 19, 2012 8:58:59 PM org.apache.solr.handler.dataimport.SolrWriter
rollback
SEVERE: Exception while solr rollback.
java.lang.NullPointerException
at
org.apache.solr.update.DefaultSolrCoreState.rollbackIndexWriter(DefaultSolrC
oreState.java:173)
at
org.apache.solr.update.DirectUpdateHandler2.rollbackWriter(DirectUpdateHandl
er2.java:150)
at
org.apache.solr.update.DirectUpdateHandler2.rollback(DirectUpdateHandler2.ja
va:625)
at
org.apache.solr.update.processor.RunUpdateProcessor.processRollback(RunUpdat
eProcessorFactory.java:98)
at
org.apache.solr.update.processor.UpdateRequestProcessor.processRollback(Upda
teRequestProcessor.java:72)
at
org.apache.solr.update.processor.LogUpdateProcessor.processRollback(LogUpdat
eProcessorFactory.java:170)
at
org.apache.solr.handler.dataimport.SolrWriter.rollback(SolrWriter.java:117)
at
org.apache.solr.handler.dataimport.DocBuilder.rollback(DocBuilder.java:319)
at
org.apache.solr.handler.dataimport.DataImporter.doFullImport(DataImporter.ja
va:387)
at
org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:448
)
at
org.apache.solr.handler.dataimport.DataImporter$1.run(DataImporter.java:429)
Sep 19, 2012 8:58:59 PM org.apache.solr.core.SolrCore execute
INFO: [collection1] webapp=/solr4 path=/dataimport params={command=status}
status=0 QTime=0
In the data-config_products.xml I've set up something like:
<dataConfig>
<dataSource type="JdbcDataSource"
driver="com.mysql.jdbc.Driver"
url="jdbc:mysql://db0/myb"
user="xx"
password="xx"/>
<document>
<entity name="id"
query="select p.title as title, p.id as id, p.category_id as
category_id, p.pic_thumb as pic_thumb, c.name as category, c.id as
category_id, c.top_id as top_id from product p, category WHERE
p.category_id = c.id AND '${dataimporter.request.clean}' != 'false' OR
updated_at > '${dataimporter.last_index_time}' ">
</entity>
</document>
</dataConfig>
I have in parallel a solr 3.5 version installed, here it works fine.
Any ideas?
Thanks,
Ramo
