Java 无法创建请求的服务 [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]

Question

提问by tdel

I am trying to configure hibernate orm mapping tool to my java class and using PostgreSQL as my database and configured the password as "password". When I tried to run the application, I have encountered error on my console logs as Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]. I have tried this on old version of hibernate and it worked. The hibernate version that I am using right now is version 5.1.0.

我正在尝试将 hibernate orm 映射工具配置到我的 java 类并使用 PostgreSQL 作为我的数据库并将密码配置为“密码”。当我尝试运行该应用程序时，我在控制台日志中遇到错误，如 Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]。我已经在旧版本的 hibernate 上尝试过这个，并且有效。我现在使用的休眠版本是 5.1.0 版。

The following is the error log:

以下是错误日志：

Mar 31, 2016 3:55:09 PM org.hibernate.Version logVersion
INFO: HHH000412: Hibernate Core {5.1.0.Final}
Mar 31, 2016 3:55:09 PM org.hibernate.cfg.Environment <clinit>
INFO: HHH000206: hibernate.properties not found
Mar 31, 2016 3:55:09 PM org.hibernate.cfg.Environment buildBytecodeProvider
INFO: HHH000021: Bytecode provider name : javassist
Mar 31, 2016 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.
Mar 31, 2016 3:55:10 PM org.hibernate.annotations.common.reflection.java.JavaReflectionManager <clinit>
INFO: HCANN000001: Hibernate Commons Annotations {5.0.1.Final}
Mar 31, 2016 3:55:10 PM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
WARN: HHH10001002: Using Hibernate built-in connection pool (not for production use!)
Mar 31, 2016 3:55:10 PM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator
INFO: HHH10001005: using driver [org.postgresql.Driver] at URL [jdbc:postgresql://localhost:5432/hibernatedb]
Mar 31, 2016 3:55:10 PM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator
INFO: HHH10001001: Connection properties: {user=sa, password=****}
Mar 31, 2016 3:55:10 PM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator
INFO: HHH10001003: Autocommit mode: false
Mar 31, 2016 3:55:10 PM 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]
    at org.hibernate.service.internal.AbstractServiceRegistryImpl.createService(AbstractServiceRegistryImpl.java:244)
    at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:208)
    at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:189)
    at org.hibernate.engine.jdbc.internal.JdbcServicesImpl.configure(JdbcServicesImpl.java:51)
    at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.configureService(StandardServiceRegistryImpl.java:94)
    at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:217)
    at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:189)
    at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.handleTypes(MetadataBuildingProcess.java:352)
    at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.complete(MetadataBuildingProcess.java:111)
    at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.build(MetadataBuildingProcess.java:83)
    at org.hibernate.boot.internal.MetadataBuilderImpl.build(MetadataBuilderImpl.java:418)
    at org.hibernate.boot.internal.MetadataBuilderImpl.build(MetadataBuilderImpl.java:87)
    at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:692)
    at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:724)
    at org.javabrains.hibernate.HibernateTest.main(HibernateTest.java:18)
Caused by: org.hibernate.exception.JDBCConnectionException: Error calling Driver#connect
    at org.hibernate.engine.jdbc.connections.internal.BasicConnectionCreator.convert(BasicConnectionCreator.java:105)
    at org.hibernate.engine.jdbc.connections.internal.BasicConnectionCreator.convertSqlException(BasicConnectionCreator.java:123)
    at org.hibernate.engine.jdbc.connections.internal.DriverConnectionCreator.makeConnection(DriverConnectionCreator.java:41)
    at org.hibernate.engine.jdbc.connections.internal.BasicConnectionCreator.createConnection(BasicConnectionCreator.java:58)
    at org.hibernate.engine.jdbc.connections.internal.PooledConnections.addConnections(PooledConnections.java:106)
    at org.hibernate.engine.jdbc.connections.internal.PooledConnections.<init>(PooledConnections.java:40)
    at org.hibernate.engine.jdbc.connections.internal.PooledConnections.<init>(PooledConnections.java:19)
    at org.hibernate.engine.jdbc.connections.internal.PooledConnections$Builder.build(PooledConnections.java:138)
    at org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl.buildPool(DriverManagerConnectionProviderImpl.java:110)
    at org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl.configure(DriverManagerConnectionProviderImpl.java:74)
    at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.configureService(StandardServiceRegistryImpl.java:94)
    at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:217)
    at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:189)
    at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.buildJdbcConnectionAccess(JdbcEnvironmentInitiator.java:145)
    at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:66)
    at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:35)
    at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.initiateService(StandardServiceRegistryImpl.java:88)
    at org.hibernate.service.internal.AbstractServiceRegistryImpl.createService(AbstractServiceRegistryImpl.java:234)
    ... 14 more
Caused by: org.postgresql.util.PSQLException: FATAL: password authentication failed for user "sa"
    at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:433)
    at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:208)
    at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)
    at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:215)
    at org.postgresql.Driver.makeConnection(Driver.java:406)
    at org.postgresql.Driver.connect(Driver.java:274)
    at org.hibernate.engine.jdbc.connections.internal.DriverConnectionCreator.makeConnection(DriverConnectionCreator.java:38)
    ... 29 more

The following is my hibernate.cfg.xml file

以下是我的 hibernate.cfg.xml 文件

<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
        "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
        "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">


<hibernate-configuration>
  <session-factory>
    <!-- Database connection settings -->
    <property name="connection.driver_class">org.postgresql.Driver</property>
    <property name="connection.url">jdbc:postgresql://localhost:5432/hibernatedb</property>
    <property name="connection.username">sa</property>
    <property name="connection.password">password</property>

    <!-- JDBC connection pool (use the built-in) -->
    <property name="connection.pool_size">1</property>

    <!-- SQL dialect -->
    <property name="dialect">org.hibernate.dialect.PostgreSQLDialect</property>

    <!-- Enable Hibernate's automatic session context management -->
    <property name="current_session_context_class">thread</property>

    <!-- Disable the second-level cache  -->
    <property name="cache.provider_class">org.hibernate.cache.internal.NoCacheProvider</property>

    <!-- Echo all executed SQL to stdout -->
    <property name="show_sql">true</property>

    <!-- Drop and re-create the database schema on startup -->
    <property name="hbm2ddl.auto">create</property>

    <!-- Names the annotated entity class-->
    <mapping class="org.javabrains.dto.UserDetails"/>

  </session-factory>
</hibernate-configuration>

My POJO class

我的 POJO 课

package org.javabrains.dto;

import javax.persistence.Entity;

@Entity
public class UserDetails {

    private int userId;
    private String userName;

    public int getUserId() {
        return userId;
    }
    public void setUserId(int userId) {
        this.userId = userId;
    }
    public String getUserName() {
        return userName;
    }
    public void setUserName(String userName) {
        this.userName = userName;
    }

}

And my application class:

我的应用程序类：

package org.javabrains.hibernate;

import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;
import org.javabrains.dto.UserDetails;

public class HibernateTest {

    public static void main(String[] args) {
        UserDetails user = new UserDetails();

        user.setUserId(1);
        user.setUserName("Tet");

        //Hibernate API to save this objects to DB
        //Session factory is created only ONCE
        SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory();
        Session session = sessionFactory.openSession();

        //create transaction
        session.beginTransaction();
        session.save(user);

        //end the transaction
        session.getTransaction().commit();

        //Closing the session
        session.close();


    }

}

The following is the image of java hibernate structure

下面是java hibernate结构图

enter image description here

在此处输入图片说明

Answer 1

回答by v.ladynev

You don't need hibernate-entitymanager-xxx.jar, because of you use a Hibernate session approach (not JPA). You need to close the SessionFactorytoo and rollback a transaction on errors. But, the problem, of course, is not with those.

您不需要hibernate-entitymanager-xxx.jar，因为您使用的是 Hibernate 会话方法（不是JPA）。您需要关闭SessionFactory太并回滚错误的事务。但是，当然，问题不在于那些。

This is returned by a database

这是由数据库返回的

#
org.postgresql.util.PSQLException: FATAL: password authentication failed for user "sa"
#

Looks like you've provided an incorrect username or (and) password.

看起来您提供的用户名或（和）密码不正确。

Answer 2

回答by orog

I am using Eclipse mars, Hibernate 5.2.1, Jdk7 and Oracle 11g.

我正在使用 Eclipse mars、Hibernate 5.2.1、Jdk7 和 Oracle 11g。

I get the same error when I run Hibernate code generation tool. I guess it is a versions issue due to I have solved it through choosing Hibernate version (5.1 to 5.0) in the type frame in my Hibernate console configuration.

当我运行 Hibernate 代码生成工具时，我遇到了同样的错误。我想这是一个版本问题，因为我已经通过在我的 Hibernate 控制台配置的类型框架中选择 Hibernate 版本（5.1 到 5.0）解决了它。

Answer 3

回答by Luis Jose Marrero

You forget the @ID above the userId

您忘记了 userId 上方的 @ID

Answer 4

回答by Mahesh Naalla

I got the same error and changing the following

我遇到了同样的错误并更改了以下内容

SessionFactory sessionFactory =
    new Configuration().configure().buildSessionFactory();

to this

对此

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

worked for me.

为我工作。

Answer 5

回答by Vaibhav Bhalla

Cause:The error occurred since hibernate is not able to connect to the database.
Solution:
1. Please ensure that you have a database present at the server referred to in the configuration file eg. "hibernatedb" in this case.
2. Please see if the username and password for connecting to the db are correct.
3. Check if relevant jars required for the connection are mapped to the project.

原因：由于休眠无法连接到数据库，因此发生错误。
解决方案：
1. 请确保您在配置文件中提到的服务器上有一个数据库，例如。在这种情况下，“hibernatedb”。
2. 请查看连接数据库的用户名和密码是否正确。
3、检查连接所需的相关jar包是否映射到项目中。

Answer 6

回答by Abolfazl Ghahremani

you must stop another running app involved with especial database table ... like running java API in other module or other project is not terminated .. so terminate running.

您必须停止与特殊数据库表有关的另一个正在运行的应用程序......就像在其他模块或其他项目中运行java API没有终止......所以终止运行。

Answer 7

回答by Gabriel Leite

I had this error with MySQL as my database and the only solution was reinstall all components of MySQL, because before I installed just the server.

我在使用 MySQL 作为我的数据库时遇到了这个错误，唯一的解决方案是重新安装 MySQL 的所有组件，因为在我只安装了服务器之前。

So try to download other versions of PostgreSQL and get all the components

所以尝试下载其他版本的PostgreSQL并获取所有组件

Answer 8

回答by Yergalem

Either you experienced database connection issue or you missed any of the hibernate configurations to connect to database such as database DIALECT.

您遇到了数据库连接问题，或者您错过了任何用于连接数据库的休眠配置，例如数据库 DIALECT。

Happens if your database server was disconnected due to network related issue.

如果您的数据库服务器由于网络相关问题而断开连接，则会发生这种情况。

If you're using spring boot along with hibernate connected to Oracle Db, use

如果您使用 spring boot 和连接到 Oracle Db 的休眠，请使用

hibernate.dialect=org.hibernate.dialect.HSQLDialect
hibernate.show_sql=true
hibernate.hbm2ddl.auto=update
hibernate.generate_statistics=true
entitymanager.packagesToScan: com

Answer 9

回答by UdayKiran Pulipati

Upgrade MySql driver to Connector/Python 8.0.17or greater than 8.0.17, Those who are using greater than MySQL 5.5 version

将MySql驱动升级至Connector/Python 8.0.17或8.0.17以上，使用MySQL 5.5以上版本者

Java 无法创建请求的服务 [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]

提问by tdel

回答by v.ladynev

回答by orog

回答by Luis Jose Marrero

回答by Mahesh Naalla

回答by Vaibhav Bhalla

回答by Abolfazl Ghahremani

回答by Gabriel Leite

回答by Yergalem

回答by UdayKiran Pulipati

相关推荐

最近更新

标签

Java 无法创建请求的服务 [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]

提问by tdel

回答by v.ladynev

回答by orog

回答by Luis Jose Marrero

回答by Mahesh Naalla

回答by Vaibhav Bhalla

回答by Abolfazl Ghahremani

回答by Gabriel Leite

回答by Yergalem

回答by UdayKiran Pulipati

相关推荐

如何在 Java 中打印出字符串中的特定字母

Java 如何组织包（并防止依赖循环）？

在 Android 上运行 Java 字节码 - 在 DalvikVM 之上的 Sun JVM

Java：InvalidAlgorithmParameterException Prime 大小必须是 64 的倍数

相关推荐

最近更新

标签