2
respostas

esta dando erro com banco de dados alguem pode ajudar


APPLICATION FAILED TO START


Description:

Failed to configure a DataSource: 'url' attribute is not specified and no embedded datasource could be configured.

Reason: Failed to determine a suitable driver class

Action:

Consider the following: 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).

2 respostas

Oi Verusca

Aparentemente não encontrou as configurações para a aplicação (está reclamando da URL)

Veja se seu application.properties está conforme abaixo:

spring.datasource.url=jdbc:mariadb://127.0.0.1:3306/alura

spring.datasource.username=root
spring.datasource.password=root

spring.datasource.testWhileIdle=true
spring.datasource.validationQuery=SELECT 1

spring.datasource.driver-class-name=org.mariadb.jdbc.Driver

spring.jpa.show-sql=false
spring.jpa.hibernate.ddl-auto=update
spring.jpa.hibernate.naming-strategy=org.hibernate.cfg.ImproveNamingStrategy
spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.MariaDBDialect

Olá Verusca, tudo bem.

segue as configurações do properties;

===============================

= DATA SOURCE

===============================

Set here configurations for the database connection

spring.datasource.url=jdbc:mariadb://localhost:3306/springboot_mariadb spring.datasource.username=root spring.datasource.password=root spring.datasource.driver-class-name=org.mariadb.jdbc.Driver

Keep the connection alive if idle for a long time (needed in production)

spring.datasource.testWhileIdle=true spring.datasource.validationQuery=SELECT 1

===============================

= JPA / HIBERNATE

===============================

Show or not log for each sql query

spring.jpa.show-sql=true

Hibernate ddl auto (create, create-drop, update): with "create-drop" the database

schema will be automatically created afresh for every start of application

spring.jpa.hibernate.ddl-auto=create-drop

Naming strategy

spring.jpa.hibernate.naming.implicit-strategy=org.hibernate.boot.model.naming.ImplicitNamingStrategyLegacyHbmImpl spring.jpa.hibernate.naming.physical-strategy=org.springframework.boot.orm.jpa.hibernate.SpringPhysicalNamingStrategy

Allows Hibernate to generate SQL optimized for a particular DBMS

spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect

espero ter ajudado.