spring - Spring 应用程序未在 Postgres 数据库上创建表
问题描述
Spring 不会在我的Postgres 数据库@Entity中创建我的类中指定的表。
我已经尝试了StackOverflow中给出的很多解决方案，比如一些更改application.properties、更改方言、设置架构等。我检查了我的数据库权限以及用户/密码信息，一切都很好。
spring.jpa.properties.hibernate.jdbc.lob.non_contextual_creation=true
spring.datasource.url= jdbc:postgresql://localhost:5432/produtosapirest
spring.datasource.username=postgres
spring.datasource.password=postgres
spring.jpa.generate-ddl=true
spring.jpa.hibernate.ddl-auto=update
<?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 http://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.1.4.RELEASE</version>
<relativePath/> <!-- lookup parent from repository -->
</parent>
<groupId>com.produtos</groupId>
<artifactId>apirest</artifactId>
<version>0.0.1-SNAPSHOT</version>
<name>apirest</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>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-devtools</artifactId>
<scope>runtime</scope>
</dependency>
<dependency>
<groupId>org.postgresql</groupId>
<artifactId>postgresql</artifactId>
<scope>runtime</scope>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
</dependencies>
<build>
<plugins>
<plugin>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-maven-plugin</artifactId>
</plugin>
</plugins>
</build>
package produtos.api.models;
import java.io.Serializable;
import java.math.BigDecimal;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
@Entity
@Table(name="TB_PRODUTO")
public class Produto implements Serializable{
private static final long serialVersionUID = 1L;
@Id
@GeneratedValue(strategy=GenerationType.AUTO)
private long id;
private String nome;
private BigDecimal quantidade;
private BigDecimal valor;
public long getId() {
return id;
}
public void setId(long id) {
this.id = id;
}
public String getNome() {
return nome;
}
public void setNome(String nome) {
this.nome = nome;
}
public BigDecimal getQuantidade() {
return quantidade;
}
public void setQuantidade(BigDecimal quantidade) {
this.quantidade = quantidade;
}
public BigDecimal getValor() {
return valor;
}
public void setValor(BigDecimal valor) {
this.valor = valor;
}
}
终端： :: Spring Boot :: (v2.1.4.RELEASE)
2019-04-11 10:21:00.011 INFO 16132 --- [ restartedMain] com.produtos.apirest.ApirestApplication : Starting ApirestApplication on venancio-MS-7817 with PID 16132 (/home/brenorios/eclipse-workspace/apirest/target/classes started by brenorios in /home/brenorios/eclipse-workspace/apirest)
2019-04-11 10:21:00.014 INFO 16132 --- [ restartedMain] com.produtos.apirest.ApirestApplication : No active profile set, falling back to default profiles: default
2019-04-11 10:21:00.077 INFO 16132 --- [ restartedMain] .e.DevToolsPropertyDefaultsPostProcessor : Devtools property defaults active! Set 'spring.devtools.add-properties' to 'false' to disable
2019-04-11 10:21:00.077 INFO 16132 --- [ restartedMain] .e.DevToolsPropertyDefaultsPostProcessor : For additional web related logging consider setting the 'logging.level.web' property to 'DEBUG'
2019-04-11 10:21:00.880 INFO 16132 --- [ restartedMain] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data repositories in DEFAULT mode.
2019-04-11 10:21:00.901 INFO 16132 --- [ restartedMain] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 14ms. Found 0 repository interfaces.
2019-04-11 10:21:01.283 INFO 16132 --- [ restartedMain] trationDelegate$BeanPostProcessorChecker : Bean 'org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration' of type [org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration$$EnhancerBySpringCGLIB$$84f3c51d] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2019-04-11 10:21:01.672 INFO 16132 --- [ restartedMain] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat initialized with port(s): 8080 (http)
2019-04-11 10:21:01.698 INFO 16132 --- [ restartedMain] o.apache.catalina.core.StandardService : Starting service [Tomcat]
2019-04-11 10:21:01.698 INFO 16132 --- [ restartedMain] org.apache.catalina.core.StandardEngine : Starting Servlet engine: [Apache Tomcat/9.0.17]
2019-04-11 10:21:01.778 INFO 16132 --- [ restartedMain] o.a.c.c.C.[Tomcat].[localhost].[/] : Initializing Spring embedded WebApplicationContext
2019-04-11 10:21:01.778 INFO 16132 --- [ restartedMain] o.s.web.context.ContextLoader : Root WebApplicationContext: initialization completed in 1701 ms
2019-04-11 10:21:01.988 INFO 16132 --- [ restartedMain] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Starting...
2019-04-11 10:21:02.137 INFO 16132 --- [ restartedMain] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Start completed.
2019-04-11 10:21:02.178 INFO 16132 --- [ restartedMain] o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [
name: default
...]
2019-04-11 10:21:02.226 INFO 16132 --- [ restartedMain] org.hibernate.Version : HHH000412: Hibernate Core {5.3.9.Final}
2019-04-11 10:21:02.227 INFO 16132 --- [ restartedMain] org.hibernate.cfg.Environment : HHH000206: hibernate.properties not found
2019-04-11 10:21:02.343 INFO 16132 --- [ restartedMain] o.hibernate.annotations.common.Version : HCANN000001: Hibernate Commons Annotations {5.0.4.Final}
2019-04-11 10:21:02.455 INFO 16132 --- [ restartedMain] org.hibernate.dialect.Dialect : HHH000400: Using dialect: org.hibernate.dialect.PostgreSQL95Dialect
2019-04-11 10:21:02.659 INFO 16132 --- [ restartedMain] o.h.e.j.e.i.LobCreatorBuilderImpl : HHH000421: Disabling contextual LOB creation as hibernate.jdbc.lob.non_contextual_creation is true
2019-04-11 10:21:02.663 INFO 16132 --- [ restartedMain] org.hibernate.type.BasicTypeRegistry : HHH000270: Type registration [java.util.UUID] overrides previous : org.hibernate.type.UUIDBinaryType@3046a8a9
2019-04-11 10:21:02.834 INFO 16132 --- [ restartedMain] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'
2019-04-11 10:21:02.852 INFO 16132 --- [ restartedMain] o.s.b.d.a.OptionalLiveReloadServer : LiveReload server is running on port 35729
2019-04-11 10:21:03.042 INFO 16132 --- [ restartedMain] o.s.s.concurrent.ThreadPoolTaskExecutor : Initializing ExecutorService 'applicationTaskExecutor'
2019-04-11 10:21:03.087 WARN 16132 --- [ restartedMain] aWebConfiguration$JpaWebMvcConfiguration : 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
2019-04-11 10:21:03.347 INFO 16132 --- [ restartedMain] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat started on port(s): 8080 (http) with context path ''
2019-04-11 10:21:03.349 INFO 16132 --- [ restartedMain] com.produtos.apirest.ApirestApplication : Started ApirestApplication in 3.783 seconds (JVM running for 4.149)
package com.produtos.apirest;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.EnableAutoConfiguration;
import org.springframework.boot.autoconfigure.SpringBootApplication;
@SpringBootApplication
public class ApirestApplication {
public static void main(String[] args) {
SpringApplication.run(ApirestApplication.class, args);
}
}
根据我正在遵循的教程，此设置应该会导致在 postgres 数据库中创建表，但它不会发生。
解决方案
你的问题可能就在这里，
spring.jpa.hibernate.ddl-auto=update
如果您在此处阅读有关此内容的更多信息，则可以确定，
例如，该
update操作将尝试添加新列、约束等，但绝不会删除以前可能存在但不再作为先前运行的对象模型的一部分的列或约束。
因此，我会根据您的要求建议您使用create或create-drop.
笔记：
createcreate-drop每次运行应用程序时都会创建数据库。因此，如果您不希望发生这种情况，请在创建数据库后将设置更改为update.- 不要在生产环境中使用此配置。
推荐阅读
- asp.net - .NET Core - 如何将文件从视图传递到控制器作为其参数？
- pandas - 使用数据帧中的标准差制作一个 vbar 以获取均值和标准差
- javascript - 如何替换 div 元素的内容？
- laravel - 用户验证没有发送电子邮件 laravel
- mysql - 在 SQL 中显示每个用户的最后一个值（快速）
- gps - 将 gps 模块与树莓派连接时终端冻结
- sql - 在最后一次出现字符之前提取字符串
- javascript - 使用 Puppeteer 查找网站中最大的图像
- terminal - 在 SRFF 终端的测试台中显示错误“; 应该是标识符而不是标识符
- azure-active-directory - 上传自定义策略的 Azure AD B2C 内部错误