Mysql driver instead of hsql driver for Solr 8.5.2

142 Views Asked by At

Can we use dataSource driver="com.mysql.jdbc.Driver" instead of dataSource driver="org.hsqldb.jdbcDriver" as specified in Solr 8.5 document for Data Import Handler?

If yes, can you please share me db-data-config.xml having mysql driver?

1

There are 1 best solutions below

0
nikhil On BEST ANSWER

This solved the problem for me-

  • Change mysql driver name to com.mysql.cj.jdbc.Driver in data-config.xml. Default we have driver="com.mysql.jdbc.Driver"
  • Remove add-schema-fields in update.autoCreateFields property.