java - org.postgresql.util.PSQLException: FATAL: database "postgres>" does not exist -
i'm working on first hibernate project jax-rs jersey web service hibernate + postgres backend running on tomcat 8.5. when start tomcat , try access users resource going http://localhost:8080/myapp/webapi/users, following error:
severe: connection error: org.postgresql.util.psqlexception: fatal: database "postgres>" not exist @ org.postgresql.core.v3.queryexecutorimpl.receiveerrorresponse(queryexecutorimpl.java:2477) @ org.postgresql.core.v3.queryexecutorimpl.readstartupmessages(queryexecutorimpl.java:2603) @ org.postgresql.core.v3.queryexecutorimpl.<init>(queryexecutorimpl.java:125) @ org.postgresql.core.v3.connectionfactoryimpl.openconnectionimpl(connectionfactoryimpl.java:227) @ org.postgresql.core.connectionfactory.openconnection(connectionfactory.java:49) @ org.postgresql.jdbc.pgconnection.<init>(pgconnection.java:194) @ org.postgresql.driver.makeconnection(driver.java:450) @ org.postgresql.driver.connect(driver.java:252) @ org.hibernate.engine.jdbc.connections.internal.driverconnectioncreator.makeconnection(driverconnectioncreator.java:38) @ org.hibernate.engine.jdbc.connections.internal.basicconnectioncreator.createconnection(basicconnectioncreator.java:58) @ org.hibernate.engine.jdbc.connections.internal.pooledconnections.addconnections(pooledconnections.java:123) @ org.hibernate.engine.jdbc.connections.internal.pooledconnections.<init>(pooledconnections.java:42) @ org.hibernate.engine.jdbc.connections.internal.pooledconnections.<init>(pooledconnections.java:20) @ org.hibernate.engine.jdbc.connections.internal.pooledconnections$builder.build(pooledconnections.java:161) @ org.hibernate.engine.jdbc.connections.internal.drivermanagerconnectionproviderimpl.buildpool(drivermanagerconnectionproviderimpl.java:109) @ org.hibernate.engine.jdbc.connections.internal.drivermanagerconnectionproviderimpl.configure(drivermanagerconnectionproviderimpl.java:72) @ org.hibernate.boot.registry.internal.standardserviceregistryimpl.configureservice(standardserviceregistryimpl.java:94) @ org.hibernate.service.internal.abstractserviceregistryimpl.initializeservice(abstractserviceregistryimpl.java:242) @ org.hibernate.service.internal.abstractserviceregistryimpl.getservice(abstractserviceregistryimpl.java:210) @ org.hibernate.engine.jdbc.env.internal.jdbcenvironmentinitiator.buildjdbcconnectionaccess(jdbcenvironmentinitiator.java:145) @ org.hibernate.engine.jdbc.env.internal.jdbcenvironmentinitiator.initiateservice(jdbcenvironmentinitiator.java:66) @ org.hibernate.engine.jdbc.env.internal.jdbcenvironmentinitiator.initiateservice(jdbcenvironmentinitiator.java:35) @ org.hibernate.boot.registry.internal.standardserviceregistryimpl.initiateservice(standardserviceregistryimpl.java:88) @ org.hibernate.service.internal.abstractserviceregistryimpl.createservice(abstractserviceregistryimpl.java:259) @ org.hibernate.service.internal.abstractserviceregistryimpl.initializeservice(abstractserviceregistryimpl.java:233) @ org.hibernate.service.internal.abstractserviceregistryimpl.getservice(abstractserviceregistryimpl.java:210) @ org.hibernate.engine.jdbc.internal.jdbcservicesimpl.configure(jdbcservicesimpl.java:51) @ org.hibernate.boot.registry.internal.standardserviceregistryimpl.configureservice(standardserviceregistryimpl.java:94) @ org.hibernate.service.internal.abstractserviceregistryimpl.initializeservice(abstractserviceregistryimpl.java:242) @ org.hibernate.service.internal.abstractserviceregistryimpl.getservice(abstractserviceregistryimpl.java:210) @ org.hibernate.boot.model.process.spi.metadatabuildingprocess.handletypes(metadatabuildingprocess.java:352) @ org.hibernate.boot.model.process.spi.metadatabuildingprocess.complete(metadatabuildingprocess.java:111) @ org.hibernate.boot.model.process.spi.metadatabuildingprocess.build(metadatabuildingprocess.java:83) @ org.hibernate.boot.internal.metadatabuilderimpl.build(metadatabuilderimpl.java:418) @ org.hibernate.boot.internal.metadatabuilderimpl.build(metadatabuilderimpl.java:87) @ org.hibernate.cfg.configuration.buildsessionfactory(configuration.java:691) @ org.hibernate.cfg.configuration.buildsessionfactory(configuration.java:726) @ com.xxxxxxx.myapp.myapp.sevice.userservice.getuser(userservice.java:25) @ com.xxxxxxx.myapp.myapp.resources.userresource.getuser(userresource.java:23) @ sun.reflect.nativemethodaccessorimpl.invoke0(native method) @ sun.reflect.nativemethodaccessorimpl.invoke(nativemethodaccessorimpl.java:62) @ sun.reflect.delegatingmethodaccessorimpl.invoke(delegatingmethodaccessorimpl.java:43) @ java.lang.reflect.method.invoke(method.java:498) @ org.glassfish.jersey.server.model.internal.resourcemethodinvocationhandlerfactory$1.invoke(resourcemethodinvocationhandlerfactory.java:81) @ org.glassfish.jersey.server.model.internal.abstractjavaresourcemethoddispatcher$1.run(abstractjavaresourcemethoddispatcher.java:144) @ org.glassfish.jersey.server.model.internal.abstractjavaresourcemethoddispatcher.invoke(abstractjavaresourcemethoddispatcher.java:161) @ org.glassfish.jersey.server.model.internal.javaresourcemethoddispatcherprovider$typeoutinvoker.dodispatch(javaresourcemethoddispatcherprovider.java:205) @ org.glassfish.jersey.server.model.internal.abstractjavaresourcemethoddispatcher.dispatch(abstractjavaresourcemethoddispatcher.java:99) @ org.glassfish.jersey.server.model.resourcemethodinvoker.invoke(resourcemethodinvoker.java:389) @ org.glassfish.jersey.server.model.resourcemethodinvoker.apply(resourcemethodinvoker.java:347) @ org.glassfish.jersey.server.model.resourcemethodinvoker.apply(resourcemethodinvoker.java:102) @ org.glassfish.jersey.server.serverruntime$2.run(serverruntime.java:326) @ org.glassfish.jersey.internal.errors$1.call(errors.java:271) @ org.glassfish.jersey.internal.errors$1.call(errors.java:267) @ org.glassfish.jersey.internal.errors.process(errors.java:315) @ org.glassfish.jersey.internal.errors.process(errors.java:297) @ org.glassfish.jersey.internal.errors.process(errors.java:267) @ org.glassfish.jersey.process.internal.requestscope.runinscope(requestscope.java:317) @ org.glassfish.jersey.server.serverruntime.process(serverruntime.java:305) @ org.glassfish.jersey.server.applicationhandler.handle(applicationhandler.java:1154) @ org.glassfish.jersey.servlet.webcomponent.serviceimpl(webcomponent.java:473) @ org.glassfish.jersey.servlet.webcomponent.service(webcomponent.java:427) @ org.glassfish.jersey.servlet.servletcontainer.service(servletcontainer.java:388) @ org.glassfish.jersey.servlet.servletcontainer.service(servletcontainer.java:341) @ org.glassfish.jersey.servlet.servletcontainer.service(servletcontainer.java:228) @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:231) @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:166) @ org.apache.tomcat.websocket.server.wsfilter.dofilter(wsfilter.java:52) @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:193) @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:166) @ org.apache.catalina.core.standardwrappervalve.invoke(standardwrappervalve.java:198) @ org.apache.catalina.core.standardcontextvalve.invoke(standardcontextvalve.java:96) @ org.apache.catalina.authenticator.authenticatorbase.invoke(authenticatorbase.java:478) @ org.apache.catalina.core.standardhostvalve.invoke(standardhostvalve.java:140) @ org.apache.catalina.valves.errorreportvalve.invoke(errorreportvalve.java:80) @ org.apache.catalina.valves.abstractaccesslogvalve.invoke(abstractaccesslogvalve.java:624) @ org.apache.catalina.core.standardenginevalve.invoke(standardenginevalve.java:87) @ org.apache.catalina.connector.coyoteadapter.service(coyoteadapter.java:342) @ org.apache.coyote.http11.http11processor.service(http11processor.java:799) @ org.apache.coyote.abstractprocessorlight.process(abstractprocessorlight.java:66) @ org.apache.coyote.abstractprotocol$connectionhandler.process(abstractprotocol.java:861) @ org.apache.tomcat.util.net.nioendpoint$socketprocessor.dorun(nioendpoint.java:1455) @ org.apache.tomcat.util.net.socketprocessorbase.run(socketprocessorbase.java:49) @ java.util.concurrent.threadpoolexecutor.runworker(threadpoolexecutor.java:1142) @ java.util.concurrent.threadpoolexecutor$worker.run(threadpoolexecutor.java:617) @ org.apache.tomcat.util.threads.taskthread$wrappingrunnable.run(taskthread.java:61) @ java.lang.thread.run(thread.java:748)
my postgres server running on localhost , can connect shell can seen below:
however, within eclipse above error. hibernate config file below:
<?xml version="1.0" encoding="utf-8"?> <!doctype hibernate-configuration system "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd"> <hibernate-configuration> <session-factory> <!-- connection settings --> <property name="hibernate.connection.driver_class">org.postgresql.driver</property> <property name="hibernate.connection.url">jdbc:postgresql://localhost:5432/postgres></property> <property name="hibernate.connection.username">postgres</property> <property name="hibernate.connection.password">password</property> <!-- sql dialect --> <property name="hibernate.dialect">org.hibernate.dialect.postgresqldialect</property> </session-factory> </hibernate-configuration>
you have tags ( > )not in pair in line hibernate.connection.url row
disclaimer: answer has nothing possible other errors.
<?xml version="1.0" encoding="utf-8"?> <!doctype hibernate-configuration system "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd"> <hibernate-configuration> <session-factory> <!-- connection settings --> <property name="hibernate.connection.driver_class">org.postgresql.driver</property> <property name="hibernate.connection.url">jdbc:postgresql://localhost:5432/postgres</property> <property name="hibernate.connection.username">postgres</property> <property name="hibernate.connection.password">password</property> <!-- sql dialect --> <property name="hibernate.dialect">org.hibernate.dialect.postgresqldialect</property> </session-factory> </hibernate-configuration>
Comments
Post a Comment