title: org.postgresql.util.PSQLException: FATAL: database "pma-springbootdb"
body: <p>I am working on my first sprinboot application, Where am trying to configure the properties for postgreSQL Database in my sprinboot application. When i run this application i am getting following error. </p>
  
  <pre><code>**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.&lt;init&gt;(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'
  </code></pre>
  
  <ul>
  <li><p><em>PostgreSQL properties</em></p>
  
  <p>spring.datasource.url=jdbc:postgresql://localhost:5432/pma-springbootdb</p>
  
  <pre><code>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
  </code></pre></li>
  <li><p><em>SQL Query</em></p>
  
  <p>CREATE SEQUENCE IF NOT EXISTS employee_seq;</p>
  
  <pre><code>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
  
  );
  </code></pre></li>
  <li><p><em>Project.java</em></p>
  
  <pre><code> @Entity
      public class Project {
  
  @Id
      @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "project_seq")
  
  private Long projectId;
      ....
      ....
       }
  </code></pre>
  
  <p>*</p>
  
  <ul>
  <li><em>Employee.java</em></li>
  </ul>
  
  <p>*</p>
  
  <pre><code>@Entity
  public class Employee {
  @Id
      @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "employee_seq")
      private long employeeId;
  ...
  ..
  }
  </code></pre></li>
  </ul>
  
  <p><a href="https://i.stack.imgur.com/RxOkE.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/RxOkE.png" alt="PostgreSQL Database Strucutre"></a></p>
  
  <p><a href="https://i.stack.imgur.com/sOxuo.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/sOxuo.png" alt="port"></a></p>