spring jpa没有创建表spring mvc

Question

我正在使用spring JPA制作表并连接到数据库的spring mvc应用程序上工作。最初我的JPA正在工作，表也正在创建，但由于一些调试问题，我放弃了所有的表，当我再次运行API时，它不再创建表，并给我这个错误:

ERROR: relation "clients" does not existn  Position: 449
2021-07-27 15:33:50 [@] ERROR GenericControllerAdvice: Exception StackTrace:
org.springframework.orm.jpa.JpaSystemException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
at org.springframework.orm.jpa.EntityManagerFactoryUtils.convertJpaAccessExceptionIfPossible(EntityManagerFactoryUtils.java:424) ~[spring-orm-4.3.22.RELEASE.jar:4.3.22.RELEASE]
at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.translateExceptionIfPossible(AbstractEntityManagerFactoryBean.java:526) ~[spring-orm-4.3.22.RELEASE.jar:4.3.22.RELEASE]

我的JPA配置是:

<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"
>
<property name="driverClassName" value="org.postgresql.Driver" />
<property name="url" value="jdbc:postgresql://localhost:5432/test?createDatabaseIfNotExists=true" />
<property name="username" value="postgres" />
<property name="password" value="" />
</bean>
<bean id="entityManagerFactory"
class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean">
<property name="packagesToScan" value="com.clients" />
<property name="dataSource" ref="dataSource" />
<property name="jpaProperties">
<props>
<prop key="hibernate.dialect">org.hibernate.dialect.PostgreSQLDialect</prop>
<prop key="hibernate.ddl-auto">create</prop>
<prop key="generate-ddl">true</prop>
</props>
</property>

我已经创建了测试数据库，它有默认的1个公共模式。有人能帮忙吗?由于

Answer 1

Hibernate属性错误

必须是:

<props>
<prop key="hibernate.dialect">org.hibernate.dialect.PostgreSQLDialect</prop>
<prop key="hibernate.hbm2ddl.auto">create</prop>
</props>