Spring boot h2 database error getting driver

Question

I'm trying to use h2 database in a springboot project, and i'm HikariDataSource, and i'm getting the following excepetion:

java.lang.RuntimeException: Failed to get driver instance for jdbcUrl=jdbc:h2:~/test
at com.zaxxer.hikari.util.DriverDataSource.<init>(DriverDataSource.java:88) ~[HikariCP-2.4.7.jar:na]
at com.zaxxer.hikari.pool.PoolBase.initializeDataSource(PoolBase.java:298) ~[HikariCP-2.4.7.jar:na]
at com.zaxxer.hikari.pool.PoolBase.<init>(PoolBase.java:91) ~[HikariCP-2.4.7.jar:na]
at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:101) ~[HikariCP-2.4.7.jar:na]
at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:94) ~[HikariCP-2.4.7.jar:na]
at org.hibernate.engine.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProvide...:122) ~[hibernate-core-5.0.11.Final.jar:5.0.11.Final]
at...

I think that my pom.xml and my configuration class are correct

url: jdbc:h2:~/test driverClassName: org.h2.Driver

Any clue on what i'm doing wrong?

Is there some root cause exception in your log? Such as ClassNotFoundException or some security exception? — Ján Halaša
– Ján Halaša, Commented Jan 24, 2018 at 5:10
I'm getting only that exception "No suitable driver found", i'm following this tutorial: websystique.com/spring-boot/… and i also tried to use the source code provided by the author and i got the same error — Tony
– Tony, Commented Jan 24, 2018 at 11:24

Biswajit Debnath · Accepted Answer · 2018-01-24 05:23:41Z

2

Add driver in your pom.xml

<dependency>
 <groupId>com.h2database</groupId>
 <artifactId>h2</artifactId>
</dependency>

https://dzone.com/articles/integrate-h2-database-in-your-spring-boot-applicat

answered Jan 24, 2018 at 5:23

Biswajit Debnath

431 silver badge6 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Tony Over a year ago

I already did that, i'm following this tutorial: websystique.com/spring-boot/… i tried with the source code of author and got same error

Luis Rocha · Accepted Answer · 2022-02-03 23:19:53Z

0

Set the driver class name in the configuration for the pool.

answered Feb 3, 2022 at 23:19

Luis Rocha

584 bronze badges

1 Comment

Procrastinator Over a year ago

This does not provide an answer to the question. Once you have sufficient reputation you will be able to comment on any post; instead, provide answers that don't require clarification from the asker. - From Review

Collectives™ on Stack Overflow

Spring boot h2 database error getting driver

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related