gpt4 book ai didi

java - 组织.postgresql.util.PSQLException : FATAL: database "pma-springbootdb"

转载 作者:行者123 更新时间:2023-12-01 14:32:07 26 4
gpt4 key购买 nike

我正在开发我的第一个 sprinboot 应用程序,我正在尝试在我的 sprinboot 应用程序中配置 postgreSQL 数据库的属性。当我运行此应用程序时,出现以下错误。

**org.postgresql.util.PSQLException: FATAL: database "pma-springbootdb" does not exist**
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2533) ~[postgresql-42.2.12.jar:42.2.12]
at org.postgresql.core.v3.QueryExecutorImpl.readStartupMessages(QueryExecutorImpl.java:2645) ~[postgresql-42.2.12.jar:42.2.12]
at org.postgresql.core.v3.QueryExecutorImpl.<init>(QueryExecutorImpl.java:138) ~[postgresql-42.2.12.jar:42.2.12]
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:255) ~[postgresql-42.2.12.jar:42.2.12]
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49) ~[postgresql-42.2.12.jar:42.2.12]
at org.postgresql.jd
......
2020-06-03 09:33:13.052 WARN 1225 --- [ task-1] o.h.e.j.e.i.JdbcEnvironmentInitiator : HHH000342: Could not obtain connection to query metadata : FATAL: database "pma-springbootdb" does not exist
2020-06-03 09:33:13.078 WARN 1225 --- [ restartedMain] ConfigServletWebServerApplicationContext : **Exception encountered during context initialization - cancelling refresh attempt: nested exception is org.springframework.beans.factory.BeanCreationException:** Error creating bean with name 'mvcConversionService' defined in class path resource [org/springframework/boot/autoconfigure/web/servlet/WebMvcAutoConfiguration$EnableWebMvcConfiguration.class]: Bean instantiation via factory method failed; nested exception is **org.springframework.beans.BeanInstantiationException: Failed to instantiate**
**Related cause: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'requestMappingHandlerAdapter'** defined in class path resource [org/springframework/boot/autoconfigure/web/servlet/WebMvcAutoConfiguration$EnableWebMvcConfiguration.class]: Unsatisfied dependency expressed : Invocation of destroy method failed on bean with name 'entityManagerFactory': org.hibernate.service.spi.ServiceException: Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]
2020-06-03 09:33:13.079 INFO 1225 --- [ restartedMain] o.s.s.concurrent.ThreadPoolTaskExecutor : Shutting down ExecutorService 'applicationTaskExecutor'
2020-06-03 09:33:13.084 INFO 1225 --- [ restartedMain] o.apache.catalina.core.StandardService : Stopping service [Tomcat]
2020-06-03 09:33:13.112 INFO 1225 --- [ restartedMain] ConditionEvaluationReportLoggingListener
**Caused by: org.springframework.beans.factory.BeanCreationException:** Error creating bean with name 'mvcConversionService' defined in class path resource [org/springframework/boot/autoconfigure/web/servlet/WebMvcAutoConfiguration$EnableWebMvcConfiguration.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.springframework.format.support.FormattingConversionService]: Factory method 'mvcConversionService' threw exception; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'employeeRepository' defined in com.jrp.pma.dao.EmployeeRepository defined in @EnableJpaRepositories declared on JpaRepositoriesRegistrar.EnableJpaRepositoriesConfiguration: Cannot resolve reference to bean 'jpaMappingContext'
  • PostgreSQL 特性

    spring.datasource.url=jdbc:postgresql://localhost:5432/pma-springbootdb

    spring.datasource.username=***

    spring.datasource.password=***

    spring.datasource.initialization-mode=never

    spring.jpa.hibernate.ddl-auto=none

    spring.jpa.properties.hibernate.jdbc.lob.non_contextual_creation=true

    spring.jpa.show-sql=true
    spring.thymeleaf.cache=false
    version=3.0.0
  • SQL 查询

    如果 employee_seq 不存在则创建序列;

    CREATE TABLE IF NOT EXISTS employee (

    employee_id BIGINT NOT NULL DEFAULT nextval('employee_seq') PRIMARY KEY,
    email VARCHAR(100) NOT NULL,
    first_name VARCHAR(100) NOT NULL,
    last_name VARCHAR(100) NOT NULL

    );

    CREATE SEQUENCE IF NOT EXISTS project_seq;

    CREATE TABLE IF NOT EXISTS project (

    project_id BIGINT NOT NULL DEFAULT nextval('project_seq') PRIMARY KEY,
    name VARCHAR(100) NOT NULL,
    stage VARCHAR(100) NOT NULL,
    description VARCHAR(500) NOT NULL

    );


    CREATE TABLE IF NOT EXISTS project_employee (

    project_id BIGINT REFERENCES project,
    employee_id BIGINT REFERENCES employee

    );
  • Project.java

     @Entity
    public class Project {

    @Id
    @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "project_seq")

    private Long projectId;
    ....
    ....
    }

    *

    • Employee.java

    *

    @Entity
    public class Employee {
    @Id
    @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "employee_seq")
    private long employeeId;
    ...
    ..
    }

PostgreSQL Database Strucutre

port

最佳答案

消息 database "pma-springbootdb"does not exist 是不言自明的。

localhost 上运行的 PostgreSQL 实例中不存在此数据库,端口为 5432。要么是错误的数据库名称,要么是错误的实例。

请仔细检查:pma-springbootdb 与 pma-springbootbd

关于java - 组织.postgresql.util.PSQLException : FATAL: database "pma-springbootdb",我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/62165197/

26 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com