spring-SQL SERVER - Tabela Cargos não criada automático

console do Spring:

2021-07-02 14:22:56.510  INFO 17124 --- [           main] o.hibernate.jpa.internal.util.LogHelper  : HHH000204: Processing PersistenceUnitInfo [name: default]
2021-07-02 14:22:57.036  INFO 17124 --- [           main] org.hibernate.Version                    : HHH000412: Hibernate ORM core version 5.4.32.Final
2021-07-02 14:22:57.725  INFO 17124 --- [           main] o.hibernate.annotations.common.Version   : HCANN000001: Hibernate Commons Annotations {5.1.2.Final}
2021-07-02 14:22:58.349  INFO 17124 --- [           main] org.hibernate.dialect.Dialect            : HHH000400: Using dialect: org.hibernate.dialect.SQLServer2012Dialect
2021-07-02 14:23:01.649  INFO 17124 --- [           main] o.h.e.t.j.p.i.JtaPlatformInitiator       : HHH000490: Using JtaPlatform implementation: [org.hibernate.engine.transaction.jta.platform.internal.NoJtaPlatform]
2021-07-02 14:23:01.690  INFO 17124 --- [           main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'
2021-07-02 14:23:01.792  WARN 17124 --- [           main] JpaBaseConfiguration$JpaWebConfiguration : spring.jpa.open-in-view is enabled by default. Therefore, database queries may be performed during view rendering. Explicitly configure spring.jpa.open-in-view to disable this warning
2021-07-02 14:23:02.837  INFO 17124 --- [           main] o.s.b.w.embedded.tomcat.TomcatWebServer  : Tomcat started on port(s): 8080 (http) with context path ''
2021-07-02 14:23:02.854  INFO 17124 --- [           main] b.c.a.spring.data.SpringDataApplication  : Started SpringDataApplication in 17.603 seconds (JVM running for 19.933)

pom:

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>
    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.5.2</version>
        <relativePath/> <!-- lookup parent from repository -->
    </parent>
    <groupId>br.com.alura</groupId>
    <artifactId>spring-data</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <name>spring-data</name>
    <description>Demo project for Spring Boot</description>
    <properties>
        <java.version>1.8</java.version>
    </properties>
    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-data-jpa</artifactId>
        </dependency>
        <dependency>
            <groupId>com.microsoft.sqlserver</groupId>
            <artifactId>mssql-jdbc</artifactId>
              <version>8.4.1.jre14</version> 
        <!-- dá esse warning: Overriding managed version 9.2.1.jre8 for mssql-jdbc na linha acima
             tentei usar essa tag ao lado mas continua o erro:    <version>9.2.1.jre8</version>  -->
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
    </dependencies>
    <build>
        <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
            </plugin>
        </plugins>
    </build>
</project>

application.properties:

spring.datasource.url=jdbc:sqlserver://RICMENTZ:1433;databaseName=alura
spring.datasource.username=sa
spring.datasource.password=xxxxxxx
spring.datasource.testWhileIdle=true
spring.datasource.validationQuery=SELECT 1
spring.datasource.driver-class-name=com.microsoft.sqlserver.jdbc.SQLServerDriver
spring.jpa.show-sql=false
spring.jpa.hibernate.dll-auto=update
spring.jpa.hibernate.naming-strategy=org.hibernate.cfg.ImproveNamingStrategy
spring.jpa.hibernate.dialect=org.hibernate.dialect.SQLServer2012Dialect

qualque ajuda é bem vinda. abraço.

Dá algum erro?

Não dá erro…

Para testar, tente usar create ao invés de update na propriedade spring.jpa.hibernate.dll-auto.

E coloque para imprimir os sql para ver se algo está sendo executado no banco ou não.

fiz as alterações:

spring.jpa.show-sql=true
spring.jpa.hibernate.dll-auto=create

mas não achei onde ele gera as impressões do SQL…

Deve aparecer no console da IDE.

no console da IDE aparece só isso:


  .   ____          _            __ _ _
 /\\ / ___'_ __ _ _(_)_ __  __ _ \ \ \ \
( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
 \\/  ___)| |_)| | | | | || (_| |  ) ) ) )
  '  |____| .__|_| |_|_| |_\__, | / / / /
 =========|_|==============|___/=/_/_/_/
 :: Spring Boot ::                (v2.5.2)

2021-07-05 15:57:28.122  INFO 13156 --- [           main] b.c.a.spring.data.SpringDataApplication  : Starting SpringDataApplication using Java 14.0.2 on ricmentz with PID 13156 (C:\Users\RICARDO\Downloads\ALURA_JAVA\spring-data\target\classes started by RICARDO in C:\Users\RICARDO\Downloads\ALURA_JAVA\spring-data)
2021-07-05 15:57:28.128  INFO 13156 --- [           main] b.c.a.spring.data.SpringDataApplication  : No active profile set, falling back to default profiles: default
2021-07-05 15:57:29.588  INFO 13156 --- [           main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2021-07-05 15:57:29.626  INFO 13156 --- [           main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 13 ms. Found 0 JPA repository interfaces.
2021-07-05 15:57:31.292  INFO 13156 --- [           main] o.s.b.w.embedded.tomcat.TomcatWebServer  : Tomcat initialized with port(s): 8080 (http)
2021-07-05 15:57:31.331  INFO 13156 --- [           main] o.apache.catalina.core.StandardService   : Starting service [Tomcat]
2021-07-05 15:57:31.331  INFO 13156 --- [           main] org.apache.catalina.core.StandardEngine  : Starting Servlet engine: [Apache Tomcat/9.0.48]
2021-07-05 15:57:31.706  INFO 13156 --- [           main] o.a.c.c.C.[Tomcat].[localhost].[/]       : Initializing Spring embedded WebApplicationContext
2021-07-05 15:57:31.707  INFO 13156 --- [           main] w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 3452 ms
2021-07-05 15:57:32.692  INFO 13156 --- [           main] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Starting...
2021-07-05 15:57:33.679  INFO 13156 --- [           main] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Start completed.
2021-07-05 15:57:34.008  INFO 13156 --- [           main] o.hibernate.jpa.internal.util.LogHelper  : HHH000204: Processing PersistenceUnitInfo [name: default]
2021-07-05 15:57:34.220  INFO 13156 --- [           main] org.hibernate.Version                    : HHH000412: Hibernate ORM core version 5.4.32.Final
2021-07-05 15:57:34.621  INFO 13156 --- [           main] o.hibernate.annotations.common.Version   : HCANN000001: Hibernate Commons Annotations {5.1.2.Final}
2021-07-05 15:57:34.935  INFO 13156 --- [           main] org.hibernate.dialect.Dialect            : HHH000400: Using dialect: org.hibernate.dialect.SQLServer2012Dialect
2021-07-05 15:57:36.537  INFO 13156 --- [           main] o.h.e.t.j.p.i.JtaPlatformInitiator       : HHH000490: Using JtaPlatform implementation: [org.hibernate.engine.transaction.jta.platform.internal.NoJtaPlatform]
2021-07-05 15:57:36.560  INFO 13156 --- [           main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'
2021-07-05 15:57:36.707  WARN 13156 --- [           main] JpaBaseConfiguration$JpaWebConfiguration : spring.jpa.open-in-view is enabled by default. Therefore, database queries may be performed during view rendering. Explicitly configure spring.jpa.open-in-view to disable this warning
2021-07-05 15:57:38.563  INFO 13156 --- [           main] o.s.b.w.embedded.tomcat.TomcatWebServer  : Tomcat started on port(s): 8080 (http) with context path ''
2021-07-05 15:57:38.593  INFO 13156 --- [           main] b.c.a.spring.data.SpringDataApplication  : Started SpringDataApplication in 11.32 seconds (JVM running for 12.4)

na aba Problems:

Description Resource Path Location Type Build path specifies execution environment JavaSE-1.8. There are no JREs installed in the workspace that are strictly compatible with this environment.

spring-data Build path JRE System Library Problem


The compiler compliance specified is 1.8 but a JRE 14 is used

spring-data Compiler Compliance JRE Compiler Compliance Problem