无法创建请求的服务[org.hibernate.engine.jdbc.env.spi.JdbcEnvironment] [英] Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]
本文介绍了无法创建请求的服务[org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我正在尝试将hibernate orm映射工具配置为可能的java类，并使用PostgreSQL作为我的数据库并将密码配置为password。当我尝试运行该应用程序时，在控制台日志中遇到了这种错误。无法创建请求的服务[org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]。我已经尝试过这个旧版本的hibernate，它工作。我现在使用的休眠版本是5.1.0版本。
以下是错误日志：
2016年3月31日3:55:09 PM org.hibernate.Version logVersion
INFO：HHH000412：Hibernate Core {5.1.0.Final}
三月31，2016 3:55:09 PM org.hibernate.cfg.Environment < clinit>
产品介绍：HHH000206：不是的hibernate.properties发现
2016年3月31日下午3时55分09秒org.hibernate.cfg.Environment中buildBytecodeProvider
产品介绍：HHH000021：字节码供应商名称：Javassist是
2016年3月31日下午3时55分09秒org.hibernate.boot.jaxb.internal.stax.LocalXmlResourceResolver resolveEntity
警告：HHH90000012：公认过时的休眠命名空间http://hibernate.sourceforge.net/hibernate-组态。改用名称空间http://www.hibernate.org/dtd/hibernate-configuration。随时可以删除对过时的DTD / XSD名称空间的支持。
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
警告：HHH10001002：使用Hibernate内置的连接池（而不是用于生产！）
2016年3月31日下午3点55分10秒org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator
INFO：HHH10001005：在URL [jdbc：postgresql：// localhost：5432 / hibernatedb]使用驱动程序[org.postgresql.Driver]
2016年3月31日下午3:55:10 org.hibernate.engine.jdbc。 connections.internal.DriverManagerConnectionProviderImpl buildCreator
INFO：HHH10001001：连接属性：{user = sa，password = ****}
Mar 31，2016 3:55:10 PM org.hibernate.engine.jdbc .connections.internal.DriverManagerConnectionProviderImpl buildCreator
INFO：HHH10001003：Autocommit模式：false
三月31，2016 3:55:10 PM org.hibernate.engine.jdbc.connections.internal.PooledConnections< init>
INFO：HHH000115：Hibernate连接池大小：1（min = 1）
线程main中的异常org.hibernate.service.spi.ServiceException：无法创建请求的服务[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 ：在org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.configureService（StandardServiceRegistryImpl.java:94 51）
）中在org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService
（AbstractServiceRegistryImpl.java:217 ）在org.hibernate.service.internal.Ab处
stractServiceRegistryImpl.getService（AbstractServiceRegistryImpl.java:189）
位于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:692）
在org.hibernate.cfg.Configuration.buildSessionFactory（Configuration.java:724）
在org.javabrains.hibernate.HibernateTest.main（HibernateTest.java:18）
导致：org.hibernate.exception.JDBCConnectionException：错误的调用Driver＃连接
在org.hibernate.engine.jdbc。 connections.internal.BasicConnectionCreator $ 1 $ 1.Convert的（BasicConnectionCreator.java:105）
。在org.hibernate.engine.jdbc.connections.internal.BasicConnectionCreator.convertSqlException（BasicConnectionCreator.java:123）
。在有机hibernate.engine.jdbc.connections.internal.DriverConnectionCreator.makeConnection（DriverConnectionCreator.java:41）
at org.hibernate.engine.jdbc.connections.internal.BasicConnectionCreator.createConnection（BasicConnectionCreator.java:58）
在org.hibernate.engine.jdbc.connections.internal.PooledConnections。org.hibernate.engine.jdbc.connections.internal.PooledConnections.addConnections（PooledConnections.java:106）
。< init>（PooledConnections。 java：40）
在org.hibernate.engine.jdbc.connections.internal.PooledConnections。< init>（PooledConnections.java:19）
在org.hibernate.engine.jdbc.connections.internal .PooledConnections $ Builder.build（PooledConnections.java:138）
在org.hibernate.engine.jdbc.con nections.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）
处org.hibernate.service org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService（AbstractServiceRegistryImpl.java:217）
。在org.hibernate.engine上为
提供org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.buildJdbcConnectionAccess（JdbcEnvironmentInitiator.java:145）
（AbstractServiceRegistryImpl.java:189）。 jdbc.env.internal.JdbcEnvironmentInitiator.initiateService（JdbcEnvironmentInitiator.java:66）
在org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService（JdbcEnv ironmentInitiator.java:35）
at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.initiateService（StandardServiceRegistryImpl.java:88）
at org.hibernate.service.internal.AbstractServiceRegistryImpl.createService（AbstractServiceRegistryImpl。 java：234）
... 14更多
导致：org.postgresql.util.PSQLException：FATAL：用户sa的密码认证失败$ or $ $ b $ 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）
在org.postgresql.Driver.connect（Driver.java:274）
在org.hibernate.engine.jdbc.connections.internal.DriverConnectionCreator.m akeConnection（DriverConnectionCreator.java:38）
... 29 more
以下是我的hibernate.cfg.xml文件
<？xml version ='1.0'encoding ='utf-8'？>
<！DOCTYPE hibernate-configuration PUBLIC
- // Hibernate / Hibernate配置DTD 3.0 // EN
http://hibernate.sourceforge.net/hibernate-configuration-3.0 .dtd>
< hibernate-configuration>
< session-factory>
<！ - 数据库连接设置 - >
< 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>密码< / property>
<！ - JDBC连接池（使用内置） - >
< property name =connection.pool_size> 1< / property>
<！ - - SQL方言 - >
< property name =dialect> org.hibernate.dialect.PostgreSQLDialect< / property>
<！ - 启用Hibernate的自动会话上下文管理 - >
< property name =current_session_context_class>线程< / property>
<！ - 禁用二级缓存 - >
< property name =cache.provider_class> org.hibernate.cache.internal.NoCacheProvider< / property>
<！ - 将所有执行的SQL回复到stdout - >
< property name =show_sql> true< / property>
<！ - 在启动时删除并重新创建数据库模式 - >
< property name =hbm2ddl.auto>建立< / property>
<！ - 给注释的实体类命名 - >
< mapping class =org.javabrains.dto.UserDetails/>
< / session-factory>
< / hibernate-configuration>
我的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;
}
}
以及我的应用程序类： p>
package org.javabrains.hibernate;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
导入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将这些对象保存到DB
//会话工厂只创建
SessionFactory sessionFactory = new Configuration（）。configure（）。buildSessionFactory（）;
Session session = sessionFactory.openSession（）;
//创建交易
session.beginTransaction（）;
session.save（user）;
//结束交易
session.getTransaction（）。commit（）;
//关闭会话
session.close（）;
$ b 以下是java hibernate结构的图像
在这里输入图像描述
解决方案
您不需要 hibernate-entitymanager-xxx.jar ，因为您使用Hibernate会话方法（而不是 JPA ）。您还需要关闭 SessionFactory ，并回滚出错的事务。但是，这个问题当然不是那些问题。
这是由数据库返回的
＃
org.postgresql.util.PSQLException：FATAL：用户sa的密码验证失败
＃
看起来您提供了不正确的用户或（和）密码。
I am trying to configure hibernate orm mapping tool to may java class and using PostgreSQL as my database and configured the password as "password". When I tried to run the application, I have encountered this kind of error on my console logs. 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.
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$1$1.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
<?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
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 enter image description here
解决方案
You don't need hibernate-entitymanager-xxx.jar, because of you use a Hibernate session approach (not JPA). You need to close the SessionFactory too and rollback a transaction on errors. But, the problem, of course, is not with those.
This is returned by a database
#
org.postgresql.util.PSQLException: FATAL: password authentication failed for user "sa"
#
Looks like you provide an incorrect user or (and) password.
这篇关于无法创建请求的服务[org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
![在这里输入图像描述](\"http://i.stack.imgur.com/Co8WP.jpg\"){kind=link}
