Search code examples
javajdbchikaricpmicronautsql2o

Not Able to Connect JDBC-Hikari To my Micronaut App

Error I am Getting after running sudo ./gradlew run :

Task :run FAILED 12:03:13.440 [main] ERROR com.zaxxer.hikari.HikariConfig - Failed to load driver class com.mysql.jdbc.Driver from HikariConfig class classloader jdk.internal.loader.ClassLoaders$AppClassLoader@3d4eac69 12:03:13.445 [main] ERROR io.micronaut.runtime.Micronaut - Error starting Micronaut server: Bean definition [javax.sql.DataSource] could not be loaded: Error instantiating bean of type [javax.sql.DataSource]

How my Application.yml looks like :

micronaut:
  application:
    name: freshdb2

#datasources.default: {}

datasources:
  default:
    url: jdbc:mysql://localhost:3306/mydb;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=FALSE
    username: root
    password: ""
    driverClassName: com.mysql.jdbc.Driver
Solution

  • You are missing driver, you should add dependency mysql-connector-java, for gradle add:

    runtime group: 'mysql', name: 'mysql-connector-java', version: '8.0.13'