Question

If you want an embedded database (h2, hsql or derby), please put it on the classpath.



if you have database settings to be loaded from a particular profile you may need to activate it (no profiles are currently active).

Answer 1

Answer:

spring.autoconfigure.exclude=org.springframework.boot.autoconfigure.jdbc.DataSourceAutoConfiguration

Explanation:

Please, add the above line in your properties file

Answer 2

Answer:

It is regularly handy to expand programs via way of means of the usage of an in-reminiscence embedded database. Obviously, in-reminiscence databases do now no longer offer continual storage. You want to populate your database whilst your software begins offevolved and be organized to throw away facts whilst your software ends.

Spring Boot can auto-configure embedded H2, HSQL, and Derby databases. You want now no longer to offer any connection URLs. You want most effective consist of a construct dependency at the embedded database which you need to use.

Let's first acquainted with what's an in-reminiscence database? Typical databases like MySQL or Oracle contain loads of setups like:

Install the Database

Setup a Schema

Setup the tables

Populate the facts

Connect the software to the database via way of means of putting in a facts supply and loads of different code

#SPJ2