spring配置出错jdbc.internal.JdbcServicesImpl.configure(JdbcServicesImpl.java:244

最新推荐文章于 2025-01-01 17:55:43 发布
最新推荐文章于 2025-01-01 17:55:43 发布
阅读量425 收藏
点赞数
CC 4.0 BY-SA版权
分类专栏： hibernate oracle 文章标签： java 数据库
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.youkuaiyun.com/andinker/article/details/84924767
本文记录了在Spring4.0.5与Hibernate4.3.1集成时遇到的sessionFactory配置问题及解决办法。主要问题是由于使用连接池导致Hibernate无法正确获取数据库元数据，通过设置hibernate.temp.use_jdbc_metadata_defaults为false解决了该问题。

摘要生成于 C知道 ，由 DeepSeek-R1 满血版支持， 前往体验 >

spring配置出错at org.hibernate.engine.jdbc.internal.JdbcServicesImpl.configure(JdbcServicesImpl.java:244

 

1.SSM集成:

spring 4.0.5

hibernate 4.3.1;

sessionFactory 注入datasource

 

  1.  
    <bean id="sf" class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
  2.  
    <property name="dataSource" ref="myDataSource" />
  3.  
    <property name="packagesToScan">
  4.  
    <list>
  5.  
    <value>xx.xx.model</value>
  6.  
    </list>
  7.  
    </property>
  8.  
    <property name="hibernateProperties">
  9.  
    <props>
  10.  
    <prop key="hibernate.dialect">
  11.  
    org.hibernate.dialect.Oracle9Dialect
  12.  
    </prop>
  13.  
    <prop key="hibernate.show_sql">true</prop>
  14.  
    </props>
  15.  
    </property>
  16.  
    </bean>



 

 

2.出错:

 

  1.  
    INFO: HCANN000001: Hibernate Commons Annotations {4.0.4.Final}
  2.  
    2016-5-19 22:38:58 org.hibernate.Version logVersion
  3.  
    INFO: HHH000412: Hibernate Core {4.3.1.Final}
  4.  
    2016-5-19 22:38:58 org.hibernate.cfg.Environment <clinit>
  5.  
    INFO: HHH000206: hibernate.properties not found
  6.  
    2016-5-19 22:38:58 org.hibernate.cfg.Environment buildBytecodeProvider
  7.  
    INFO: HHH000021: Bytecode provider name : javassist
  8.  
    2016-5-19 22:38:58 org.hibernate.engine.jdbc.internal.JdbcServicesImpl configure
  9.  
    WARN: HHH000341: Could not obtain connection metadata : 不支持的特性
  10.  
    2016-5-19 22:38:58 org.hibernate.engine.jdbc.internal.LobCreatorBuilder useContextualLobCreation
  11.  
    INFO: HHH000422: Disabling contextual LOB creation as connection was null
  12.  
    2016-5-19 22:38:58 org.springframework.web.context.ContextLoader initWebApplicationContext
  13.  
    严重: Context initialization failed
  14.  
    org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sf' defined in ServletContext resource [/WEB-INF/applicationContext.xml]: Invocation of init method failed; nested exception is java.lang.NullPointerException
  15.  
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1553)
  16.  
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:539)
  17.  
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:475)
  18.  
    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:304)
  19.  
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:228)
  20.  
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:300)
  21.  
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:195)
  22.  
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:684)
  23.  
    at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:760)
  24.  
    at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:482)
  25.  
    at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:403)
  26.  
    at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:306)
  27.  
    at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:106)
  28.  
    at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5003)
  29.  
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5517)
  30.  
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
  31.  
    at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
  32.  
    at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
  33.  
    at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:652)
  34.  
    at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1263)
  35.  
    at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1978)
  36.  
    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:439)
  37.  
    at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
  38.  
    at java.util.concurrent.FutureTask.run(FutureTask.java:138)
  39.  
    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
  40.  
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
  41.  
    at java.lang.Thread.run(Thread.java:662)
  42.  
    Caused by: java.lang.NullPointerException
  43.  
    at org.hibernate.engine.jdbc.internal.JdbcServicesImpl.configure(JdbcServicesImpl.java:244)
  44.  
    at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.configureService(StandardServiceRegistryImpl.java:89)
  45.  
    at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:206)
  46.  
    at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:178)
  47.  
    at org.hibernate.cfg.Configuration.buildTypeRegistrations(Configuration.java:1885)
  48.  
    at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1843)
  49.  
    at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1928)
  50.  
    at org.springframework.orm.hibernate4.LocalSessionFactoryBuilder.buildSessionFactory(LocalSessionFactoryBuilder.java:343)
  51.  
    at org.springframework.orm.hibernate4.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:431)
  52.  
    at org.springframework.orm.hibernate4.LocalSessionFactoryBean.afterPropertiesSet(LocalSessionFactoryBean.java:416)
  53.  
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1612)
  54.  
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1549)
  55.  
    ... 26 more
  56.  
    2016-5-19 22:38:58 org.apache.catalina.core.StandardContext listenerStart
  57.  
    严重: Exception sending context initialized event to listener instance of class org.springframework.web.context.ContextLoaderListener
  58.  
    org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sf' defined in ServletContext resource [/WEB-INF/applicationContext.xml]: Invocation of init method failed; nested exception is java.lang.NullPointerException
  59.  
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1553)
  60.  
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:539)
  61.  
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:475)
  62.  
    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:304)
  63.  
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:228)
  64.  
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:300)
  65.  
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:195)
  66.  
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:684)
  67.  
    at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:760)
  68.  
    at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:482)
  69.  
    at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:403)
  70.  
    at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:306)
  71.  
    at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:106)
  72.  
    at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5003)
  73.  
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5517)
  74.  
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
  75.  
    at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
  76.  
    at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
  77.  
    at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:652)
  78.  
    at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1263)
  79.  
    at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1978)
  80.  
    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:439)
  81.  
    at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
  82.  
    at java.util.concurrent.FutureTask.run(FutureTask.java:138)
  83.  
    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
  84.  
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
  85.  
    at java.lang.Thread.run(Thread.java:662)
  86.  
    Caused by: java.lang.NullPointerException
  87.  
    at org.hibernate.engine.jdbc.internal.JdbcServicesImpl.configure(JdbcServicesImpl.java:244)
  88.  
    at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.configureService(StandardServiceRegistryImpl.java:89)
  89.  
    at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:206)
  90.  
    at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:178)
  91.  
    at org.hibernate.cfg.Configuration.buildTypeRegistrations(Configuration.java:1885)
  92.  
    at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1843)
  93.  
    at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1928)
  94.  
    at org.springframework.orm.hibernate4.LocalSessionFactoryBuilder.buildSessionFactory(LocalSessionFactoryBuilder.java:343)
  95.  
    at org.springframework.orm.hibernate4.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:431)
  96.  
    at org.springframework.orm.hibernate4.LocalSessionFactoryBean.afterPropertiesSet(LocalSessionFactoryBean.java:416)
  97.  
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1612)
  98.  
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1549)
  99.  
    ... 26 more
  100.  
     
  101.  
     

 

 

3.查了半天也没发现问题在哪里,

后来看到了一位博友博文: http://blog.youkuaiyun.com/luxiaoshuai/article/details/40540929

原来是使用连接池注入的数据源 需要添加如下一条属性:

 

<prop key="hibernate.temp.use_jdbc_metadata_defaults">false</prop>

 

 

配置如下:

 

  1.  
    <bean id="sf"
  2.  
    class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
  3.  
    <property name="dataSource" ref="myDataSource" />
  4.  
    <property name="packagesToScan">
  5.  
    <list>
  6.  
    <value>xx.xx.model</value>
  7.  
    </list>
  8.  
    </property>
  9.  
    <property name="hibernateProperties">
  10.  
    <props>
  11.  
    <prop key="hibernate.dialect">
  12.  
    org.hibernate.dialect.Oracle9Dialect
  13.  
    </prop>
  14.  
    <prop key="hibernate.show_sql">true</prop>
  15.  
    <!-- 重要: 使用连接池设置false -->
  16.  
    <prop key="hibernate.temp.use_jdbc_metadata_defaults">false</prop>
  17.  
    </props>
  18.  
    </property>
  19.  
    </bean>



 

添加上以后,问题立马解决! 

以后还是要多看源码啊.

 

maven 项目 jetty:run运行时报 java.lang.ArrayIndexOutOfBoundsException: 18543
lierjun 的专栏
04-23 2766
错误信息：[INFO] Scanning for projects...[INFO] [INFO] ------------------------------&lt; com.hy:a &gt;------------------------------[INFO] Building a Maven Webapp 0.0.1-SNAPSHOT[INFO] --------------------...
配置hibernate时出错原因及解决方案
再烦，也别忘微笑；再急，也要注意语气；再苦，也别忘坚持。
08-15 9097
问题1   hibernate.cfg.xml配置文件         "-//Hibernate/Hibernate Configuration DTD 3.0//EN"         "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
Hibernate4 使用Proxool连接数据库出现 at org.hibernate.engine.jdbc.internal.JdbcServicesImpl.configure(JdbcSer
Share
10-28 5109
其实只要看第一行就可以了 at org.hibernate.engine.jdbc.internal.JdbcServicesImpl.configure(JdbcServicesImpl.java:244) ，就是d
hibernate4 org.hibernate.engine.jdbc.internal.JdbcServicesImpl.configure
dmvc62827的博客
09-15 288
其实只要看第一行就可以了at org.hibernate.engine.jdbc.internal.JdbcServicesImpl.configure(JdbcServicesImpl.java:244) ，就是在配置的时候没取到值。那么为什么没取到值呢，是因为Hibernate默认是使用jdbc方式来取的，如果使用连接池的方式的话，必须告诉Hibernate一声，让它不使用单...
jdbcService层
qq_44025656的博客
02-24 578
jdbc Service 层 转账业务 事务 service 层对应接口 package com.service; import com.entity.T_Account; public interface T_AccountService { //注册 public void registerService(T_Account t_account); //登录 public boolean lo...
spring配置出错at org.hibernate.engine.jdbc.internal.JdbcServicesImpl.configure(JdbcServicesImpl.java:244
过了爱做梦的年纪s 的专栏
05-19 4285
1.SSM集成: spring 4.0.5 hibernate 4.3.1; sessionFactory 注入datasource xx.xx.model org.hibernate.dialect.Oracle9Dialect true 2.出
spring-JDBC配置，使用，一些报错，mybatis原理，优化
weixin_30918633的博客
05-20 632
一. 配置spring的jdbc的pom.xml遇到报错 missing artifactXXXXX。 修改dependency的版本如下 <dependency> <groupId>org.springframework</groupId> <artifactId>spring-jdbc</arti...
启动报错 -> com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown database 'shouyuan'
橙子君的博客
10-31 8204
记录一个小小的错误，启动的时候报了这么一个错误： com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown database 'shouyuan' 完整报错如下： 原因在文尾，请下拉到底~~~ "D:\Program Files\Java\jdk1.8.0_181\bin\java.exe" "-javaagent:D:\Prog...
jdbc.DataSourceProperties$DataSourceBeanCreationException: Failed to determine a suitable driver cla...
weixin_38168838的博客
09-30 2993
java.lang.IllegalStateException: Failed to load ApplicationContext at org.springframework.test.context.cache.DefaultCacheAwareContextLoaderDelegate.loadContext(DefaultCacheAwareContextLo...
【spring boot - JPA--H2报错】H2 error: “Syntax error in SQL statement ... expected identifier“
wondersfan的博客
08-31 5773
出错原因：Hibernate/JPA生成的表与数据库保留字冲突，在我创建的User类如下所示： ‘USER’ 与数据库保留字冲突 解决的方法：修改表名，增加如下一行： 重新运行程序，故障解除
Unable to start web server； nested exception is org.springframework.boot.web.server.WebServerExcepti
最新发布
m0_74823507的博客
01-01 238
【代码】Unable to start web server；
Hibernate4报错java.lang.NullPointException, JdbcServiceImpl.configure(JdbcServiceImpl.java:207)
JasonYao的程序猿路
12-05 1260
报错堆栈如下： Caused by: java.lang.NullPointException at org.hibernate.engine.jdbs.internal.JdbcServiceImpl.configure(JdbcServiceImpl.java:207) at org.hibernate.service.internal.StandardServiceRegistryIm
WARN [org.hibernate.engine.jdbc.internal.JdbcServicesImpl] - <HHH000342: Could not obtain connectio
caidadong的专栏
08-16 2990
WARN [org.hibernate.engine.jdbc.internal.JdbcServicesImpl] - 在做项目的时候出现了这个问题，苦恼了我三天，无数次折腾。主要是数据库连接失败造成的，然而这个问题归根于lcoalhost，擦擦擦，再也不用这个了。。。。。
总结SSH阶段常见的异常系列之二hibernate续
十里の清风
11-07 633
我在学习Hibernate的过程中，踩了一些坑，由于配置文件的某个单词，或者大小写错了，而排查了两三个小时，很有幸能够看到一篇帮助我排查错误的文章。 文章地址： 总结SSH阶段常见的异常系列之二hibernate续   https://blog.csdn.net/zhouxingxing1992/article/details/54411855 原文内容如下： 异常十六 异常描述: 属性入...
Spring boot JDBC配置常见错误
weixin_55024483的博客
05-12 711
Error: 配置信息显示橙色高亮，Cannot reslove configuration 'spring .datasource.hikari.username'. RUN后： Description: Failed to configure a DataSource: 'url' attribute is not specified and no embedded datasource could be configured. Reason: Failed to determine
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值