Unable to create requested service [org.hibernate.engine.jdbc.env.spi.jdbcenvironment]

Question

Problem :

I want to configure the hibernate orm mapping tool to my java class and want to use PostgreSQL as my database also I have configured the password as "password". But when I tried to run the application, I am facing following error on my console logs as Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]. I have also tried this on old version of hibernate and it worked. And the hibernate version that I am currently using is version 5.1.0.

The following is my error log:

Dec 03, 2019 3:55:09 PM org.hibernate.Version logVersion

INFO: HHH000412: Hibernate Core {5.1.0.Final}

Dec 03, 2019 3:55:09 PM org.hibernate.cfg.Environment <clinit>

INFO: HHH000206: hibernate.properties not found

Dec 03, 2019 3:55:09 PM org.hibernate.cfg.Environment buildBytecodeProvider

INFO: HHH000021: Bytecode provider name : javassist

Dec 03, 2019 3:55:09 PM org.hibernate.boot.jaxb.internal.stax.LocalXmlResourceResolver resolveEntity

WARN: HHH90000012: Recognized obsolete hibernate namespace http://hibernate.sourceforge.net/hibernate-configuration. Use namespace http://www.hibernate.org/dtd/hibernate-configuration instead.  Support for obsolete DTD/XSD namespaces may be removed at any time.

Dec 03, 2019 3:55:10PM org.hibernate.annotations.common.reflection.java.JavaReflectionManager <clinit>

INFO: HCANN000001: Hibernate Commons Annotations {5.0.1.Final}

Dec 03, 2019 3:55:10PM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure

WARN: HHH10001002: Using Hibernate built-in connection pool (not for production use!)

Dec 03, 2019 3:55:10PM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator

INFO: HHH10001005: using driver [org.postgresql.Driver] at URL [jdbc:postgresql://localhost:5432/hibernatedb]

Dec 03, 2019 3:55:10PM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator

INFO: HHH10001001: Connection properties: {user=sa, password=****}

Dec 03, 2019 3:55:10PM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator

INFO: HHH10001003: Autocommit mode: false

Dec 03, 2019 3:55:10PM org.hibernate.engine.jdbc.connections.internal.PooledConnections <init>

INFO: HHH000115: Hibernate connection pool size: 1 (min=1)

Exception in thread "main" org.hibernate.service.spi.ServiceException: Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]

Answer 1

I had got the same error and changed the following

SessionFactory mySessionFactory =

new Configuration().configure().buildSessionFactory();

to below code

SessionFactory mySessionFactory =

new Configuration().configure("hibernate.cfg.xml").buildSessionFactory();

It worked for me.