Dataimport: Could not load driver: com.mysql.jdbc.Driver

[Ruixiang Zhang]

*I got the following error for dataimport:*

*Full Import failed
org.apache.solr.handler.dataimport.DataImportHandlerException: Could not
load driver: com.mysql.jdbc.Driver*

I have the following files:

\example-DIH\solr\db\conf\   solrconfig.xml, schema.xml, db-data-config.xml,
dataimport.properties
\example-DIH\solr\db\lib\   mysql-connector-java-5.1.13-bin.jar



*I put this code to solrconfig.xml:*

   <requestHandler name="/dataimport"
class="org.apache.solr.handler.dataimport.DataImportHandler">
    <lst name="defaults">
        <str name="config">db-data-config.xml</str>
    </lst>
  </requestHandler>

*And these in db-data-config.xml:*

<?xml version="1.0" encoding="iso-8859-1"?>

<dataConfig>
  <dataSource type="JdbcDataSource"
              driver="com.mysql.jdbc.Driver"
              url="jdbc:mysql://localhost/mydata"
              user="myuser"
              password="********"/>
  <document>
    <entity name="id"
            query="select id,title,url from title_copy">
            <field column="id" name="id" />
            <field column="title" name="title" />
            <field column="url" name="url" />
    </entity>
  </document>
</dataConfig>



Solr server has been restarted after these change.


Any hint or suggestions will be appreciated!!!

Thanks
Richard