Unable to load mysql Driver with Apache Solr-4.0.0

[Shameer Thaha Koya]

Hi Team,
I am trying to integrate apache Sonr(apache-solr-4.0.0) with Tomcat and getting 
below error.

15:12:40

SEVERE

DataImporter

Delta Import Failed

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)


... 11 more

Caused by: org.apache.solr.common.SolrException: Error loading class ' 
com.mysql.jdbc.Driver'

        at 
org.apache.solr.core.SolrResourceLoader.findClass(SolrResourceLoader.java:436)

        at 
org.apache.solr.handler.dataimport.DocBuilder.loadClass(DocBuilder.java:889)

        ... 12 more

Caused by: java.lang.ClassNotFoundException:  com.mysql.jdbc.Driver

        at java.net.URLClassLoader$1.run(Unknown Source)





I tried below option's of adding mysql-connector-java-5.1.22-bin.jar, but none 
worked



1.     added as part of war (solr.war/WEB-INF/lib )

2.     added as part of web server (Tomcat/lib)

3.     Created a new directory lib under example/solr and placed the mysql 
connector jar (mysql-connector-java-5.1.22-bin.jar) and refered the lib path  
from solr.xml.

              <solr persistent="true" sharedLib="./lib">



Could you guide me how to get the mysql driver loaded for Sonar. Any help 
highly appreciable. Thanks




Shameer Thaha
Senior Developer
Emirates Group IT  |Dubai,
M : 971-552775725