休眠与c3p0：createClob（）尚未实现 [英] hibernate with c3p0: createClob() is not yet implemented

查看：419
本文介绍了休眠与c3p0：createClob（）尚未实现的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

在我的项目中，我开始使用 c3p0 与hibernate重新连接到数据库，因为hibernate获胜在数据库失败时恢复连接。

 <依赖关系> 
< groupId> org.hibernate< / groupId> 
< artifactId> hibernate-c3p0< / artifactId> 
< version> 5.2.9.Final< / version> 
< /依赖关系>

我正在使用hibernate版本：

 <依赖性> 
< groupId> org.hibernate< / groupId> 
< artifactId> hibernate-core< / artifactId> 
< version> 5.2.9.Final< / version> 
< /依赖关系>

postgresql驱动程序是： 

 <依赖性> 
< groupId> org.postgresql< / groupId> 
< artifactId> postgresql< / artifactId> 
< version> 42.1.4< / version> 
< /依赖关系>



c3p0的配置是： 

  properties.put（hibernate.c3p0.preferredTestQuery，SELECT 1）; 
 properties.put（hibernate.c3p0.testConnectionOnCheckout，true）; 
 properties.put（hibernate.c3p0.acquireRetryAttempts，1）; 
 properties.put（hibernate.c3p0.acquireIncrement，1）; 
 properties.put（hibernate.c3p0.idleConnectionTestPeriod，60）;

但我不断收到此错误： 

  18：25：32.910 [localhost-startStop-1] DEBUG cmv2.c3p0.impl.NewPooledConnection  -  com.mchange.v2.c3p0.impl.NewPooledConnection@755e3afe处理一个throwable。 
 java.sql.SQLFeatureNotSupportedException：方法org.postgresql.jdbc.PgConnection.createClob（）尚未实现。 
 at org.postgresql.Driver.notImplemented（Driver.java:669）〜[postgresql-42.1.4.jar：42.1.4] 
 at org.postgresql.jdbc.PgConnection.createClob（PgConnection。 java：1246）〜[postgresql-42.1.4.jar：42.1.4] 
 at com.mchange.v2.c3p0.impl.NewProxyConnection.createClob（NewProxyConnection.java:1408）〜[c3p0-0.9.5.2 .jar：0.9.5.2] 
 at sun.reflect.NativeMethodAccessorImpl.invoke0（Native Method）〜[na：1.8.0_121] 
 at sun.reflect.NativeMethodAccessorImpl.invoke（NativeMethodAccessorImpl.java:62） 〜[na：1.8.0_121] 
 at sun.reflect.DelegatingMethodAccessorImpl.invoke（DelegatingMethodAccessorImpl.java:43）〜[na：1.8.0_121] 
 at java.lang.reflect.Method.invoke（ Method.java:498）〜[na：1.8.0_121] 
 at org.hibernate.engine.jdbc.env.internal.LobCreatorBuilderImpl.useContextualLobCreation（LobCreatorBuilderImpl.java:113）[hibernate-core-5.2.9。 Final.jar：5.2.9.Final] 
在org.hibernate.engine.jdbc.env.internal.LobCreatorBuilderImpl.makeLobCreatorBuilder（LobCreator BuilderImpl.java:54）[hibernate-core-5.2.9.Final.jar：5.2.9.Final] 
 at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentImpl。< init>（JdbcEnvironmentImpl .java：271）[hibernate-core-5.2.9.Final.jar：5.2.9.Final] 
在org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService（JdbcEnvironmentInitiator.java:114 ）[hibernate-core-5.2.9.Final.jar：5.2.9.Final] 
在org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService（JdbcEnvironmentInitiator.java:35）[hibernate- core-5.2.9.Final.jar：5.2.9.Final] 
在org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.initiateService（StandardServiceRegistryImpl.java:88）[hibernate-core-5.2.9。 Final.jar：5.2.9.Final] 
在org.hibernate.service.internal.AbstractServiceRegistryImpl.createService（AbstractServiceRegistryImpl.java:259）[hibernate-core-5.2.9.Final.jar：5.2.9。最终] 
在org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService（ AbstractServiceRegistryImpl.java:233）[hibernate-core-5.2.9.Final.jar：5.2.9.Final] 
 at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService（AbstractServiceRegistryImpl.java:210）[hibernate -core-5.2.9.Final.jar：5.2.9.Final] 
在org.hibernate.engine.jdbc.internal.JdbcServicesImpl.configure（JdbcServicesImpl.java:51）[hibernate-core-5.2.9 .Final.jar：5.2.9.Final] 
 at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.configureService（StandardServiceRegistryImpl.java:94）[hibernate-core-5.2.9.Final.jar：5.2 .9.Final] 
 at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService（AbstractServiceRegistryImpl.java:242）[hibernate-core-5.2.9.Final.jar：5.2.9.Final] 
在org.hibernate.service.internal.AbstractServiceRegistryImpl.getService（AbstractServiceRegistryImpl.java:210）[hibernate-core-5.2.9.Final.jar：5.2.9.Final] 
 at org.hibernate.boot。 model.process.spi.MetadataBuildingProcess.handleTypes（MetadataB uildingProcess.java:352）[hibernate-core-5.2.9.Final.jar：5.2.9.Final] 
 at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.complete（MetadataBuildingProcess.java：在Hibernate-core-5.2.9.Final.jar中： -5.2.9.Final.jar：5.2.9.Final] 
在org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build（EntityManagerFactoryBuilderImpl.java:885）[hibernate-core-5.2.9.Final .jar：5.2.9.Final] 
 at org.springframework.orm.jpa.vendor.SpringHibernateJpaPersistenceProvider.createContainerEntityManagerFactory（SpringHibernateJpaPersistenceProvider.java:60）[spring-orm-4.3.7.RELEASE.jar：4.3.7 .RELEASE] 
在org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory（LocalContainerEntityManagerFactoryBean.java:353）[spring-orm-4.3.7.RELEASE.jar：4.3.7.RELEASE] 
 at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.buildNativeEntityManagerFactory（AbstractEntityManagerFactoryBean.java:370）[spring-orm-4.3.7.RELEASE.jar：4.3.7.RELEASE] 
 at org.springframework.orm.jpa .AbstractEntityManagerFactoryBean.afterPropertiesSet（AbstractEntityManagerFactoryBean.java:359）[spring-orm-4.3.7.RELEASE.jar：4.3.7.RELEASE] 
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods（AbstractAutowireCapableBeanFactory .java：1687）[spring-beans-4.3.7.RELEASE.jar：4.3.7.RELEASE] 
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean（AbstractAutowireCapableBeanFactory.java:1624）[ spring-beans-4.3.7.RELEASE.jar：4.3.7.RELEASE] 
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean（AbstractAutowireCapableBeanFactory.java:555）[spring-beans-4.3。 7.RELEASE.jar：4.3.7.RELEASE] 
在org.springframework.beans.factory .support.AbstractAutowireCapableBeanFactory.createBean（AbstractAutowireCapableBeanFactory.java:483）[spring-beans-4.3.7.RELEASE.jar：4.3.7.RELEASE] 
 at org.springframework.beans.factory.support.AbstractBeanFactory $ 1。 getObject（AbstractBeanFactory.java:306）[spring-beans-4.3.7.RELEASE.jar：4.3.7.RELEASE] 
 at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton（DefaultSingletonBeanRegistry.java： 230）[spring-beans-4.3.7.RELEASE.jar：4.3.7.RELEASE] 
 at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean（AbstractBeanFactory.java:302）[spring-beans -4.3.7.RELEASE.jar：4.3.7.RELEASE] 
 at org.springframework.beans.factory.support.AbstractBeanFactory.getBean（AbstractBeanFactory.java:197）[spring-beans-4.3.7.RELEASE .jar：4.3.7.RELEASE] 
 at org.springframework.context.support.AbstractApplicationContext.getBean（AbstractApplicationContext.java:1081）[spring-context-4.3.7.RELEASE.jar：4.3.7.RELEASE ] 
在org.sp ringframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization（AbstractApplicationContext.java:856）[spring-context-4.3.7.RELEASE.jar：4.3.7.RELEASE] 
在org.springframework.context.support.AbstractApplicationContext。刷新（AbstractApplicationContext.java:542）[spring-context-4.3.7.RELEASE.jar：4.3.7.RELEASE] 
在org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext（ContextLoader.java:443） [spring-web-4.3.7.RELEASE.jar：4.3.7.RELEASE] 
在org.springframework.web.context.ContextLoader.initWebApplicationContext（ContextLoader.java:325）[spring-web-4.3.7 .RELEASE.jar：4.3.7.RELEASE] 
在org.springframework.web.context.ContextLoaderListener.contextInitialized（ContextLoaderListener.java:107）[spring-web-4.3.7.RELEASE.jar：4.3.7 .RELEASE] 
在org.apache.catalina.core.StandardContext.listenerStart（StandardContext.java:4971）[catalina.jar：7.0.53] 
 at org.apache.catalina.core.StandardContext。星tInternal（StandardContext.java:5467）[catalina.jar：7.0.53] 
 at org.apache.catalina.util.LifecycleBase.start（LifecycleBase.java:150）[catalina.jar：7.0.53] 
 at org.apache.catalina.core.ContainerBase.addChildInternal（ContainerBase.java:901）[catalina.jar：7.0.53] 
 at org.apache.catalina.core.ContainerBase.addChild（ContainerBase。 java：877）[catalina.jar：7.0.53] 
 at org.apache.catalina.core.StandardHost.addChild（StandardHost.java:632）[catalina.jar：7.0.53] 
 at org.apache.catalina.startup.HostConfig $ DeployWar.run（HostConfig.java：org.apache.catalina.startup.HostConfig.deployWAR（HostConfig.java:1073）[catalina.jar：7.0.53] 
 at org.apache.catalina.startup.HostConfig $ DeployWar.run $ java.util.concurrent.Executors 
 $ RunnableAdapter.call（Executors.java:511）[na：1.8.0_121] 
 at java.util。并发.FutureTask.run（FutureTask.java:266）[na：1.8.0_121] 
在java.util.concurrent.ThreadPoolExecutor.runWorker（ThreadPoolExecutor.java:1142）[na：1.8.0_121] 
A t java.util.concurrent.ThreadPoolExecutor $ Worker.run（ThreadPoolExecutor.java:617）[na：1.8.0_121] 
 at java.lang.Thread.run（Thread.java:745）[na：1.8。 0_121] 
 18：25：32.911 [localhost-startStop-1] DEBUG com.mchange.v2.sql.SqlUtils  - 试图将SQLException转换为SQLException。离开它独自一人。 [SQLState：0A000; errorCode：0] 
 java.sql.SQLFeatureNotSupportedException：方法org.postgresql.jdbc.PgConnection.createClob（）尚未实现。 
 at org.postgresql.Driver.notImplemented（Driver.java:669）〜[postgresql-42.1.4.jar：42.1.4] 
 at org.postgresql.jdbc.PgConnection.createClob（PgConnection。 java：1246）〜[postgresql-42.1.4.jar：42.1.4] 
 at com.mchange.v2.c3p0.impl.NewProxyConnection.createClob（NewProxyConnection.java:1408）〜[c3p0-0.9.5.2 .jar：0.9.5.2] 
 at sun.reflect.NativeMethodAccessorImpl.invoke0（Native Method）〜[na：1.8.0_121] 
 at sun.reflect.NativeMethodAccessorImpl.invoke（NativeMethodAccessorImpl.java:62） 〜[na：1.8.0_121] 
 at sun.reflect.DelegatingMethodAccessorImpl.invoke（DelegatingMethodAccessorImpl.java:43）〜[na：1.8.0_121] 
 at java.lang.reflect.Method.invoke（ Method.java:498）〜[na：1.8.0_121] 
 at org.hibernate.engine.jdbc.env.internal.LobCreatorBuilderImpl.useContextualLobCreation（LobCreatorBuilderImpl.java:113）[hibernate-core-5.2.9。 Final.jar：5.2.9.Final] 
在org.hibernate.engine.jdbc.env.internal.LobCreatorBuilderImpl.makeLobCreatorBuilder（LobCreator BuilderImpl.java:54）[hibernate-core-5.2.9.Final.jar：5.2.9.Final] 
 at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentImpl。< init>（JdbcEnvironmentImpl .java：271）[hibernate-core-5.2.9.Final.jar：5.2.9.Final] 
在org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService（JdbcEnvironmentInitiator.java:114 ）[hibernate-core-5.2.9.Final.jar：5.2.9.Final] 
在org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService（JdbcEnvironmentInitiator.java:35）[hibernate- core-5.2.9.Final.jar：5.2.9.Final] 
在org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.initiateService（StandardServiceRegistryImpl.java:88）[hibernate-core-5.2.9。 Final.jar：5.2.9.Final] 
在org.hibernate.service.internal.AbstractServiceRegistryImpl.createService（AbstractServiceRegistryImpl.java:259）[hibernate-core-5.2.9.Final.jar：5.2.9。最终] 
在org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService（ AbstractServiceRegistryImpl.java:233）[hibernate-core-5.2.9.Final.jar：5.2.9.Final] 
 at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService（AbstractServiceRegistryImpl.java:210）[hibernate -core-5.2.9.Final.jar：5.2.9.Final] 
在org.hibernate.engine.jdbc.internal.JdbcServicesImpl.configure（JdbcServicesImpl.java:51）[hibernate-core-5.2.9 .Final.jar：5.2.9.Final] 
 at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.configureService（StandardServiceRegistryImpl.java:94）[hibernate-core-5.2.9.Final.jar：5.2 .9.Final] 
 at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService（AbstractServiceRegistryImpl.java:242）[hibernate-core-5.2.9.Final.jar：5.2.9.Final] 
在org.hibernate.service.internal.AbstractServiceRegistryImpl.getService（AbstractServiceRegistryImpl.java:210）[hibernate-core-5.2.9.Final.jar：5.2.9.Final] 
 at org.hibernate.boot。 model.process.spi.MetadataBuildingProcess.handleTypes（MetadataB uildingProcess.java:352）[hibernate-core-5.2.9.Final.jar：5.2.9.Final] 
 at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.complete（MetadataBuildingProcess.java：在Hibernate-core-5.2.9.Final.jar中： -5.2.9.Final.jar：5.2.9.Final] 
在org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build（EntityManagerFactoryBuilderImpl.java:885）[hibernate-core-5.2.9.Final .jar：5.2.9.Final] 
 at org.springframework.orm.jpa.vendor.SpringHibernateJpaPersistenceProvider.createContainerEntityManagerFactory（SpringHibernateJpaPersistenceProvider.java:60）[spring-orm-4.3.7.RELEASE.jar：4.3.7 .RELEASE] 
在org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory（LocalContainerEntityManagerFactoryBean.java:353）[spring-orm-4.3.7.RELEASE.jar：4.3.7.RELEASE] 
 at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.buildNativeEntityManagerFactory（AbstractEntityManagerFactoryBean.java:370）[spring-orm-4.3.7.RELEASE.jar：4.3.7.RELEASE] 
 at org.springframework.orm.jpa .AbstractEntityManagerFactoryBean.afterPropertiesSet（AbstractEntityManagerFactoryBean.java:359）[spring-orm-4.3.7.RELEASE.jar：4.3.7.RELEASE] 
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods（AbstractAutowireCapableBeanFactory .java：1687）[spring-beans-4.3.7.RELEASE.jar：4.3.7.RELEASE] 
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean（AbstractAutowireCapableBeanFactory.java:1624）[ spring-beans-4.3.7.RELEASE.jar：4.3.7.RELEASE] 
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean（AbstractAutowireCapableBeanFactory.java:555）[spring-beans-4.3。 7.RELEASE.jar：4.3.7.RELEASE] 
在org.springframework.beans.factory .support.AbstractAutowireCapableBeanFactory.createBean（AbstractAutowireCapableBeanFactory.java:483）[spring-beans-4.3.7.RELEASE.jar：4.3.7.RELEASE] 
 at org.springframework.beans.factory.support.AbstractBeanFactory $ 1。 getObject（AbstractBeanFactory.java:306）[spring-beans-4.3.7.RELEASE.jar：4.3.7.RELEASE] 
 at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton（DefaultSingletonBeanRegistry.java： 230）[spring-beans-4.3.7.RELEASE.jar：4.3.7.RELEASE] 
 at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean（AbstractBeanFactory.java:302）[spring-beans -4.3.7.RELEASE.jar：4.3.7.RELEASE] 
 at org.springframework.beans.factory.support.AbstractBeanFactory.getBean（AbstractBeanFactory.java:197）[spring-beans-4.3.7.RELEASE .jar：4.3.7.RELEASE] 
 at org.springframework.context.support.AbstractApplicationContext.getBean（AbstractApplicationContext.java:1081）[spring-context-4.3.7.RELEASE.jar：4.3.7.RELEASE ] 
在org.sp ringframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization（AbstractApplicationContext.java:856）[spring-context-4.3.7.RELEASE.jar：4.3.7.RELEASE] 
在org.springframework.context.support.AbstractApplicationContext。刷新（AbstractApplicationContext.java:542）[spring-context-4.3.7.RELEASE.jar：4.3.7.RELEASE] 
在org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext（ContextLoader.java:443） [spring-web-4.3.7.RELEASE.jar：4.3.7.RELEASE] 
在org.springframework.web.context.ContextLoader.initWebApplicationContext（ContextLoader.java:325）[spring-web-4.3.7 .RELEASE.jar：4.3.7.RELEASE] 
在org.springframework.web.context.ContextLoaderListener.contextInitialized（ContextLoaderListener.java:107）[spring-web-4.3.7.RELEASE.jar：4.3.7 .RELEASE] 
在org.apache.catalina.core.StandardContext.listenerStart（StandardContext.java:4971）[catalina.jar：7.0.53] 
 at org.apache.catalina.core.StandardContext。星tInternal（StandardContext.java:5467）[catalina.jar：7.0.53] 
 at org.apache.catalina.util.LifecycleBase.start（LifecycleBase.java:150）[catalina.jar：7.0.53] 
 at org.apache.catalina.core.ContainerBase.addChildInternal（ContainerBase.java:901）[catalina.jar：7.0.53] 
 at org.apache.catalina.core.ContainerBase.addChild（ContainerBase。 java：877）[catalina.jar：7.0.53] 
 at org.apache.catalina.core.StandardHost.addChild（StandardHost.java:632）[catalina.jar：7.0.53] 
 at org.apache.catalina.startup.HostConfig $ DeployWar.run（HostConfig.java：org.apache.catalina.startup.HostConfig.deployWAR（HostConfig.java:1073）[catalina.jar：7.0.53] 
 at org.apache.catalina.startup.HostConfig $ DeployWar.run $ java.util.concurrent.Executors 
 $ RunnableAdapter.call（Executors.java:511）[na：1.8.0_121] 
 at java.util。并发.FutureTask.run（FutureTask.java:266）[na：1.8.0_121] 
在java.util.concurrent.ThreadPoolExecutor.runWorker（ThreadPoolExecutor.java:1142）[na：1.8.0_121] 
A t java.util.concurrent.ThreadPoolExecutor $ Worker.run（ThreadPoolExecutor.java:617）[na：1.8.0_121] 
 at java.lang.Thread.run（Thread.java:745）[na：1.8。 0_121] 
 18：25：32.912 [localhost-startStop-1] DEBUG cmvcimpl.DefaultConnectionTester  - 测试连接以响应例外：
 java.sql.SQLFeatureNotSupportedException：方法org.postgresql.jdbc。 PgConnection.createClob（）尚未实现。 
 at org.postgresql.Driver.notImplemented（Driver.java:669）〜[postgresql-42.1.4.jar：42.1.4] 
 at org.postgresql.jdbc.PgConnection.createClob（PgConnection。 java：1246）〜[postgresql-42.1.4.jar：42.1.4] 
 at com.mchange.v2.c3p0.impl.NewProxyConnection.createClob（NewProxyConnection.java:1408）〜[c3p0-0.9.5.2 .jar：0.9.5.2] 
 at sun.reflect.NativeMethodAccessorImpl.invoke0（Native Method）〜[na：1.8.0_121] 
 at sun.reflect.NativeMethodAccessorImpl.invoke（NativeMethodAccessorImpl.java:62） 〜[na：1.8.0_121] 
 at sun.reflect.DelegatingMethodAccessorImpl.invoke（DelegatingMethodAccessorImpl.java:43）〜[na：1.8.0_121] 
 at java.lang.reflect.Method.invoke（ Method.java:498）〜[na：1.8.0_121] 
 at org.hibernate.engine.jdbc.env.internal.LobCreatorBuilderImpl.useContextualLobCreation（LobCreatorBuilderImpl.java:113）[hibernate-core-5.2.9。 Final.jar：5.2.9.Final] 
在org.hibernate.engine.jdbc.env.internal.LobCreatorBuilderImpl.makeLobCreatorBuilder（LobCreator BuilderImpl.java:54）[hibernate-core-5.2.9.Final.jar：5.2.9.Final] 
 at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentImpl。< init>（JdbcEnvironmentImpl .java：271）[hibernate-core-5.2.9.Final.jar：5.2.9.Final] 
在org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService（JdbcEnvironmentInitiator.java:114 ）[hibernate-core-5.2.9.Final.jar：5.2.9.Final] 
在org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService（JdbcEnvironmentInitiator.java:35）[hibernate- core-5.2.9.Final.jar：5.2.9.Final] 
在org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.initiateService（StandardServiceRegistryImpl.java:88）[hibernate-core-5.2.9。 Final.jar：5.2.9.Final] 
在org.hibernate.service.internal.AbstractServiceRegistryImpl.createService（AbstractServiceRegistryImpl.java:259）[hibernate-core-5.2.9.Final.jar：5.2.9。最终] 
在org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService（ AbstractServiceRegistryImpl.java:233）[hibernate-core-5.2.9.Final.jar：5.2.9.Final] 
 at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService（AbstractServiceRegistryImpl.java:210）[hibernate -core-5.2.9.Final.jar：5.2.9.Final] 
在org.hibernate.engine.jdbc.internal.JdbcServicesImpl.configure（JdbcServicesImpl.java:51）[hibernate-core-5.2.9 .Final.jar：5.2.9.Final] 
 at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.configureService（StandardServiceRegistryImpl.java:94）[hibernate-core-5.2.9.Final.jar：5.2 .9.Final] 
 at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService（AbstractServiceRegistryImpl.java:242）[hibernate-core-5.2.9.Final.jar：5.2.9.Final] 
在org.hibernate.service.internal.AbstractServiceRegistryImpl.getService（AbstractServiceRegistryImpl.java:210）[hibernate-core-5.2.9.Final.jar：5.2.9.Final] 
 at org.hibernate.boot。 model.process.spi.MetadataBuildingProcess.handleTypes（MetadataB uildingProcess.java:352）[hibernate-core-5.2.9.Final.jar：5.2.9.Final] 
 at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.complete（MetadataBuildingProcess.java：在Hibernate-core-5.2.9.Final.jar中： -5.2.9.Final.jar：5.2.9.Final] 
在org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build（EntityManagerFactoryBuilderImpl.java:885）[hibernate-core-5.2.9.Final .jar：5.2.9.Final] 
 at org.springframework.orm.jpa.vendor.SpringHibernateJpaPersistenceProvider.createContainerEntityManagerFactory（SpringHibernateJpaPersistenceProvider.java:60）[spring-orm-4.3.7.RELEASE.jar：4.3.7 .RELEASE] 
在org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory（LocalContainerEntityManagerFactoryBean.java:353）[spring-orm-4.3.7.RELEASE.jar：4.3.7.RELEASE] 
 at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.buildNativeEntityManagerFactory（AbstractEntityManagerFactoryBean.java:370）[spring-orm-4.3.7.RELEASE.jar：4.3.7.RELEASE] 
 at org.springframework.orm.jpa .AbstractEntityManagerFactoryBean.afterPropertiesSet（AbstractEntityManagerFactoryBean.java:359）[spring-orm-4.3.7.RELEASE.jar：4.3.7.RELEASE] 
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods（AbstractAutowireCapableBeanFactory .java：1687）[spring-beans-4.3.7.RELEASE.jar：4.3.7.RELEASE] 
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean（AbstractAutowireCapableBeanFactory.java:1624）[ spring-beans-4.3.7.RELEASE.jar：4.3.7.RELEASE] 
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean（AbstractAutowireCapableBeanFactory.java:555）[spring-beans-4.3。 7.RELEASE.jar：4.3.7.RELEASE] 
在org.springframework.beans.factory .support.AbstractAutowireCapableBeanFactory.createBean（AbstractAutowireCapableBeanFactory.java:483）[spring-beans-4.3.7.RELEASE.jar：4.3.7.RELEASE] 
 at org.springframework.beans.factory.support.AbstractBeanFactory $ 1。 getObject（AbstractBeanFactory.java:306）[spring-beans-4.3.7.RELEASE.jar：4.3.7.RELEASE] 
 at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton（DefaultSingletonBeanRegistry.java： 230）[spring-beans-4.3.7.RELEASE.jar：4.3.7.RELEASE] 
 at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean（AbstractBeanFactory.java:302）[spring-beans -4.3.7.RELEASE.jar：4.3.7.RELEASE] 
 at org.springframework.beans.factory.support.AbstractBeanFactory.getBean（AbstractBeanFactory.java:197）[spring-beans-4.3.7.RELEASE .jar：4.3.7.RELEASE] 
 at org.springframework.context.support.AbstractApplicationContext.getBean（AbstractApplicationContext.java:1081）[spring-context-4.3.7.RELEASE.jar：4.3.7.RELEASE ] 
在org.sp ringframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization（AbstractApplicationContext.java:856）[spring-context-4.3.7.RELEASE.jar：4.3.7.RELEASE] 
在org.springframework.context.support.AbstractApplicationContext。刷新（AbstractApplicationContext.java:542）[spring-context-4.3.7.RELEASE.jar：4.3.7.RELEASE] 
在org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext（ContextLoader.java:443） [spring-web-4.3.7.RELEASE.jar：4.3.7.RELEASE] 
在org.springframework.web.context.ContextLoader.initWebApplicationContext（ContextLoader.java:325）[spring-web-4.3.7 .RELEASE.jar：4.3.7.RELEASE] 
在org.springframework.web.context.ContextLoaderListener.contextInitialized（ContextLoaderListener.java:107）[spring-web-4.3.7.RELEASE.jar：4.3.7 .RELEASE] 
在org.apache.catalina.core.StandardContext.listenerStart（StandardContext.java:4971）[catalina.jar：7.0.53] 
 at org.apache.catalina.core.StandardContext。星tInternal（StandardContext.java:5467）[catalina.jar：7.0.53] 
 at org.apache.catalina.util.LifecycleBase.start（LifecycleBase.java:150）[catalina.jar：7.0.53] 
 at org.apache.catalina.core.ContainerBase.addChildInternal（ContainerBase.java:901）[catalina.jar：7.0.53] 
 at org.apache.catalina.core.ContainerBase.addChild（ContainerBase。 java：877）[catalina.jar：7.0.53] 
 at org.apache.catalina.core.StandardHost.addChild（StandardHost.java:632）[catalina.jar：7.0.53] 
 at org.apache.catalina.startup.HostConfig $ DeployWar.run（HostConfig.java：org.apache.catalina.startup.HostConfig.deployWAR（HostConfig.java:1073）[catalina.jar：7.0.53] 
 at org.apache.catalina.startup.HostConfig $ DeployWar.run $ java.util.concurrent.Executors 
 $ RunnableAdapter.call（Executors.java:511）[na：1.8.0_121] 
 at java.util。并发.FutureTask.run（FutureTask.java:266）[na：1.8.0_121] 
在java.util.concurrent.ThreadPoolExecutor.runWorker（ThreadPoolExecutor.java:1142）[na：1.8.0_121] 
A t java.util.concurrent.ThreadPoolExecutor $ Worker.run（ThreadPoolExecutor.java:617）[na：1.8.0_121] 
 at java.lang.Thread.run（Thread.java:745）[na：1.8。 0_121]

我必须注意到我没有调用 createClob（） 我自己！

那么，为了在Tomcat 7启动期间摆脱这个错误，我需要更改哪些内容？我也从tomcat的lib目录中删除了postgresql驱动程序。

解决方案

设置 hibernate.jdbc.lob.non_contextual_creation = true 在 persistence.xml中


In my project I started to use c3p0 with hibernate for reconnecting to database as hibernate won't restore connection on db failure.

<dependency>
            <groupId>org.hibernate</groupId>
            <artifactId>hibernate-c3p0</artifactId>
            <version>5.2.9.Final</version>
</dependency>

I am using hibernate version:

<dependency>
            <groupId>org.hibernate</groupId>
            <artifactId>hibernate-core</artifactId>
            <version>5.2.9.Final</version>
</dependency>

the postgresql driver is:

<dependency>
            <groupId>org.postgresql</groupId>
            <artifactId>postgresql</artifactId>
            <version>42.1.4</version>
</dependency>

c3p0 configuration is:

 properties.put("hibernate.c3p0.preferredTestQuery","SELECT 1");
    properties.put("hibernate.c3p0.testConnectionOnCheckout","true");
    properties.put("hibernate.c3p0.acquireRetryAttempts","1");
    properties.put("hibernate.c3p0.acquireIncrement","1");
    properties.put("hibernate.c3p0.idleConnectionTestPeriod","60");

but I keep getting this error:

18:25:32.910 [localhost-startStop-1] DEBUG c.m.v2.c3p0.impl.NewPooledConnection - com.mchange.v2.c3p0.impl.NewPooledConnection@755e3afe handling a throwable.
java.sql.SQLFeatureNotSupportedException: Method org.postgresql.jdbc.PgConnection.createClob() is not yet implemented.
    at org.postgresql.Driver.notImplemented(Driver.java:669) ~[postgresql-42.1.4.jar:42.1.4]
    at org.postgresql.jdbc.PgConnection.createClob(PgConnection.java:1246) ~[postgresql-42.1.4.jar:42.1.4]
    at com.mchange.v2.c3p0.impl.NewProxyConnection.createClob(NewProxyConnection.java:1408) ~[c3p0-0.9.5.2.jar:0.9.5.2]
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_121]
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_121]
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_121]
    at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_121]
    at org.hibernate.engine.jdbc.env.internal.LobCreatorBuilderImpl.useContextualLobCreation(LobCreatorBuilderImpl.java:113) [hibernate-core-5.2.9.Final.jar:5.2.9.Final]
    at org.hibernate.engine.jdbc.env.internal.LobCreatorBuilderImpl.makeLobCreatorBuilder(LobCreatorBuilderImpl.java:54) [hibernate-core-5.2.9.Final.jar:5.2.9.Final]
    at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentImpl.<init>(JdbcEnvironmentImpl.java:271) [hibernate-core-5.2.9.Final.jar:5.2.9.Final]
    at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:114) [hibernate-core-5.2.9.Final.jar:5.2.9.Final]
    at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:35) [hibernate-core-5.2.9.Final.jar:5.2.9.Final]
    at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.initiateService(StandardServiceRegistryImpl.java:88) [hibernate-core-5.2.9.Final.jar:5.2.9.Final]
    at org.hibernate.service.internal.AbstractServiceRegistryImpl.createService(AbstractServiceRegistryImpl.java:259) [hibernate-core-5.2.9.Final.jar:5.2.9.Final]
    at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:233) [hibernate-core-5.2.9.Final.jar:5.2.9.Final]
    at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:210) [hibernate-core-5.2.9.Final.jar:5.2.9.Final]
    at org.hibernate.engine.jdbc.internal.JdbcServicesImpl.configure(JdbcServicesImpl.java:51) [hibernate-core-5.2.9.Final.jar:5.2.9.Final]
    at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.configureService(StandardServiceRegistryImpl.java:94) [hibernate-core-5.2.9.Final.jar:5.2.9.Final]
    at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:242) [hibernate-core-5.2.9.Final.jar:5.2.9.Final]
    at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:210) [hibernate-core-5.2.9.Final.jar:5.2.9.Final]
    at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.handleTypes(MetadataBuildingProcess.java:352) [hibernate-core-5.2.9.Final.jar:5.2.9.Final]
    at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.complete(MetadataBuildingProcess.java:111) [hibernate-core-5.2.9.Final.jar:5.2.9.Final]
    at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.metadata(EntityManagerFactoryBuilderImpl.java:858) [hibernate-core-5.2.9.Final.jar:5.2.9.Final]
    at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:885) [hibernate-core-5.2.9.Final.jar:5.2.9.Final]
    at org.springframework.orm.jpa.vendor.SpringHibernateJpaPersistenceProvider.createContainerEntityManagerFactory(SpringHibernateJpaPersistenceProvider.java:60) [spring-orm-4.3.7.RELEASE.jar:4.3.7.RELEASE]
    at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:353) [spring-orm-4.3.7.RELEASE.jar:4.3.7.RELEASE]
    at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.buildNativeEntityManagerFactory(AbstractEntityManagerFactoryBean.java:370) [spring-orm-4.3.7.RELEASE.jar:4.3.7.RELEASE]
    at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.afterPropertiesSet(AbstractEntityManagerFactoryBean.java:359) [spring-orm-4.3.7.RELEASE.jar:4.3.7.RELEASE]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1687) [spring-beans-4.3.7.RELEASE.jar:4.3.7.RELEASE]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1624) [spring-beans-4.3.7.RELEASE.jar:4.3.7.RELEASE]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:555) [spring-beans-4.3.7.RELEASE.jar:4.3.7.RELEASE]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:483) [spring-beans-4.3.7.RELEASE.jar:4.3.7.RELEASE]
    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306) [spring-beans-4.3.7.RELEASE.jar:4.3.7.RELEASE]
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) [spring-beans-4.3.7.RELEASE.jar:4.3.7.RELEASE]
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302) [spring-beans-4.3.7.RELEASE.jar:4.3.7.RELEASE]
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197) [spring-beans-4.3.7.RELEASE.jar:4.3.7.RELEASE]
    at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1081) [spring-context-4.3.7.RELEASE.jar:4.3.7.RELEASE]
    at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:856) [spring-context-4.3.7.RELEASE.jar:4.3.7.RELEASE]
    at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:542) [spring-context-4.3.7.RELEASE.jar:4.3.7.RELEASE]
    at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:443) [spring-web-4.3.7.RELEASE.jar:4.3.7.RELEASE]
    at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:325) [spring-web-4.3.7.RELEASE.jar:4.3.7.RELEASE]
    at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:107) [spring-web-4.3.7.RELEASE.jar:4.3.7.RELEASE]
    at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4971) [catalina.jar:7.0.53]
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5467) [catalina.jar:7.0.53]
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) [catalina.jar:7.0.53]
    at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901) [catalina.jar:7.0.53]
    at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877) [catalina.jar:7.0.53]
    at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:632) [catalina.jar:7.0.53]
    at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:1073) [catalina.jar:7.0.53]
    at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1857) [catalina.jar:7.0.53]
    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [na:1.8.0_121]
    at java.util.concurrent.FutureTask.run(FutureTask.java:266) [na:1.8.0_121]
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [na:1.8.0_121]
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [na:1.8.0_121]
    at java.lang.Thread.run(Thread.java:745) [na:1.8.0_121]
18:25:32.911 [localhost-startStop-1] DEBUG com.mchange.v2.sql.SqlUtils - Attempted to convert SQLException to SQLException. Leaving it alone. [SQLState: 0A000; errorCode: 0]
java.sql.SQLFeatureNotSupportedException: Method org.postgresql.jdbc.PgConnection.createClob() is not yet implemented.
    at org.postgresql.Driver.notImplemented(Driver.java:669) ~[postgresql-42.1.4.jar:42.1.4]
    at org.postgresql.jdbc.PgConnection.createClob(PgConnection.java:1246) ~[postgresql-42.1.4.jar:42.1.4]
    at com.mchange.v2.c3p0.impl.NewProxyConnection.createClob(NewProxyConnection.java:1408) ~[c3p0-0.9.5.2.jar:0.9.5.2]
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_121]
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_121]
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_121]
    at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_121]
    at org.hibernate.engine.jdbc.env.internal.LobCreatorBuilderImpl.useContextualLobCreation(LobCreatorBuilderImpl.java:113) [hibernate-core-5.2.9.Final.jar:5.2.9.Final]
    at org.hibernate.engine.jdbc.env.internal.LobCreatorBuilderImpl.makeLobCreatorBuilder(LobCreatorBuilderImpl.java:54) [hibernate-core-5.2.9.Final.jar:5.2.9.Final]
    at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentImpl.<init>(JdbcEnvironmentImpl.java:271) [hibernate-core-5.2.9.Final.jar:5.2.9.Final]
    at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:114) [hibernate-core-5.2.9.Final.jar:5.2.9.Final]
    at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:35) [hibernate-core-5.2.9.Final.jar:5.2.9.Final]
    at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.initiateService(StandardServiceRegistryImpl.java:88) [hibernate-core-5.2.9.Final.jar:5.2.9.Final]
    at org.hibernate.service.internal.AbstractServiceRegistryImpl.createService(AbstractServiceRegistryImpl.java:259) [hibernate-core-5.2.9.Final.jar:5.2.9.Final]
    at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:233) [hibernate-core-5.2.9.Final.jar:5.2.9.Final]
    at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:210) [hibernate-core-5.2.9.Final.jar:5.2.9.Final]
    at org.hibernate.engine.jdbc.internal.JdbcServicesImpl.configure(JdbcServicesImpl.java:51) [hibernate-core-5.2.9.Final.jar:5.2.9.Final]
    at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.configureService(StandardServiceRegistryImpl.java:94) [hibernate-core-5.2.9.Final.jar:5.2.9.Final]
    at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:242) [hibernate-core-5.2.9.Final.jar:5.2.9.Final]
    at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:210) [hibernate-core-5.2.9.Final.jar:5.2.9.Final]
    at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.handleTypes(MetadataBuildingProcess.java:352) [hibernate-core-5.2.9.Final.jar:5.2.9.Final]
    at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.complete(MetadataBuildingProcess.java:111) [hibernate-core-5.2.9.Final.jar:5.2.9.Final]
    at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.metadata(EntityManagerFactoryBuilderImpl.java:858) [hibernate-core-5.2.9.Final.jar:5.2.9.Final]
    at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:885) [hibernate-core-5.2.9.Final.jar:5.2.9.Final]
    at org.springframework.orm.jpa.vendor.SpringHibernateJpaPersistenceProvider.createContainerEntityManagerFactory(SpringHibernateJpaPersistenceProvider.java:60) [spring-orm-4.3.7.RELEASE.jar:4.3.7.RELEASE]
    at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:353) [spring-orm-4.3.7.RELEASE.jar:4.3.7.RELEASE]
    at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.buildNativeEntityManagerFactory(AbstractEntityManagerFactoryBean.java:370) [spring-orm-4.3.7.RELEASE.jar:4.3.7.RELEASE]
    at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.afterPropertiesSet(AbstractEntityManagerFactoryBean.java:359) [spring-orm-4.3.7.RELEASE.jar:4.3.7.RELEASE]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1687) [spring-beans-4.3.7.RELEASE.jar:4.3.7.RELEASE]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1624) [spring-beans-4.3.7.RELEASE.jar:4.3.7.RELEASE]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:555) [spring-beans-4.3.7.RELEASE.jar:4.3.7.RELEASE]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:483) [spring-beans-4.3.7.RELEASE.jar:4.3.7.RELEASE]
    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306) [spring-beans-4.3.7.RELEASE.jar:4.3.7.RELEASE]
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) [spring-beans-4.3.7.RELEASE.jar:4.3.7.RELEASE]
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302) [spring-beans-4.3.7.RELEASE.jar:4.3.7.RELEASE]
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197) [spring-beans-4.3.7.RELEASE.jar:4.3.7.RELEASE]
    at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1081) [spring-context-4.3.7.RELEASE.jar:4.3.7.RELEASE]
    at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:856) [spring-context-4.3.7.RELEASE.jar:4.3.7.RELEASE]
    at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:542) [spring-context-4.3.7.RELEASE.jar:4.3.7.RELEASE]
    at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:443) [spring-web-4.3.7.RELEASE.jar:4.3.7.RELEASE]
    at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:325) [spring-web-4.3.7.RELEASE.jar:4.3.7.RELEASE]
    at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:107) [spring-web-4.3.7.RELEASE.jar:4.3.7.RELEASE]
    at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4971) [catalina.jar:7.0.53]
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5467) [catalina.jar:7.0.53]
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) [catalina.jar:7.0.53]
    at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901) [catalina.jar:7.0.53]
    at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877) [catalina.jar:7.0.53]
    at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:632) [catalina.jar:7.0.53]
    at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:1073) [catalina.jar:7.0.53]
    at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1857) [catalina.jar:7.0.53]
    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [na:1.8.0_121]
    at java.util.concurrent.FutureTask.run(FutureTask.java:266) [na:1.8.0_121]
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [na:1.8.0_121]
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [na:1.8.0_121]
    at java.lang.Thread.run(Thread.java:745) [na:1.8.0_121]
18:25:32.912 [localhost-startStop-1] DEBUG c.m.v.c.impl.DefaultConnectionTester - Testing a Connection in response to an Exception:
java.sql.SQLFeatureNotSupportedException: Method org.postgresql.jdbc.PgConnection.createClob() is not yet implemented.
    at org.postgresql.Driver.notImplemented(Driver.java:669) ~[postgresql-42.1.4.jar:42.1.4]
    at org.postgresql.jdbc.PgConnection.createClob(PgConnection.java:1246) ~[postgresql-42.1.4.jar:42.1.4]
    at com.mchange.v2.c3p0.impl.NewProxyConnection.createClob(NewProxyConnection.java:1408) ~[c3p0-0.9.5.2.jar:0.9.5.2]
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_121]
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_121]
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_121]
    at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_121]
    at org.hibernate.engine.jdbc.env.internal.LobCreatorBuilderImpl.useContextualLobCreation(LobCreatorBuilderImpl.java:113) [hibernate-core-5.2.9.Final.jar:5.2.9.Final]
    at org.hibernate.engine.jdbc.env.internal.LobCreatorBuilderImpl.makeLobCreatorBuilder(LobCreatorBuilderImpl.java:54) [hibernate-core-5.2.9.Final.jar:5.2.9.Final]
    at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentImpl.<init>(JdbcEnvironmentImpl.java:271) [hibernate-core-5.2.9.Final.jar:5.2.9.Final]
    at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:114) [hibernate-core-5.2.9.Final.jar:5.2.9.Final]
    at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:35) [hibernate-core-5.2.9.Final.jar:5.2.9.Final]
    at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.initiateService(StandardServiceRegistryImpl.java:88) [hibernate-core-5.2.9.Final.jar:5.2.9.Final]
    at org.hibernate.service.internal.AbstractServiceRegistryImpl.createService(AbstractServiceRegistryImpl.java:259) [hibernate-core-5.2.9.Final.jar:5.2.9.Final]
    at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:233) [hibernate-core-5.2.9.Final.jar:5.2.9.Final]
    at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:210) [hibernate-core-5.2.9.Final.jar:5.2.9.Final]
    at org.hibernate.engine.jdbc.internal.JdbcServicesImpl.configure(JdbcServicesImpl.java:51) [hibernate-core-5.2.9.Final.jar:5.2.9.Final]
    at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.configureService(StandardServiceRegistryImpl.java:94) [hibernate-core-5.2.9.Final.jar:5.2.9.Final]
    at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:242) [hibernate-core-5.2.9.Final.jar:5.2.9.Final]
    at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:210) [hibernate-core-5.2.9.Final.jar:5.2.9.Final]
    at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.handleTypes(MetadataBuildingProcess.java:352) [hibernate-core-5.2.9.Final.jar:5.2.9.Final]
    at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.complete(MetadataBuildingProcess.java:111) [hibernate-core-5.2.9.Final.jar:5.2.9.Final]
    at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.metadata(EntityManagerFactoryBuilderImpl.java:858) [hibernate-core-5.2.9.Final.jar:5.2.9.Final]
    at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:885) [hibernate-core-5.2.9.Final.jar:5.2.9.Final]
    at org.springframework.orm.jpa.vendor.SpringHibernateJpaPersistenceProvider.createContainerEntityManagerFactory(SpringHibernateJpaPersistenceProvider.java:60) [spring-orm-4.3.7.RELEASE.jar:4.3.7.RELEASE]
    at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:353) [spring-orm-4.3.7.RELEASE.jar:4.3.7.RELEASE]
    at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.buildNativeEntityManagerFactory(AbstractEntityManagerFactoryBean.java:370) [spring-orm-4.3.7.RELEASE.jar:4.3.7.RELEASE]
    at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.afterPropertiesSet(AbstractEntityManagerFactoryBean.java:359) [spring-orm-4.3.7.RELEASE.jar:4.3.7.RELEASE]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1687) [spring-beans-4.3.7.RELEASE.jar:4.3.7.RELEASE]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1624) [spring-beans-4.3.7.RELEASE.jar:4.3.7.RELEASE]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:555) [spring-beans-4.3.7.RELEASE.jar:4.3.7.RELEASE]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:483) [spring-beans-4.3.7.RELEASE.jar:4.3.7.RELEASE]
    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306) [spring-beans-4.3.7.RELEASE.jar:4.3.7.RELEASE]
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) [spring-beans-4.3.7.RELEASE.jar:4.3.7.RELEASE]
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302) [spring-beans-4.3.7.RELEASE.jar:4.3.7.RELEASE]
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197) [spring-beans-4.3.7.RELEASE.jar:4.3.7.RELEASE]
    at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1081) [spring-context-4.3.7.RELEASE.jar:4.3.7.RELEASE]
    at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:856) [spring-context-4.3.7.RELEASE.jar:4.3.7.RELEASE]
    at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:542) [spring-context-4.3.7.RELEASE.jar:4.3.7.RELEASE]
    at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:443) [spring-web-4.3.7.RELEASE.jar:4.3.7.RELEASE]
    at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:325) [spring-web-4.3.7.RELEASE.jar:4.3.7.RELEASE]
    at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:107) [spring-web-4.3.7.RELEASE.jar:4.3.7.RELEASE]
    at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4971) [catalina.jar:7.0.53]
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5467) [catalina.jar:7.0.53]
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) [catalina.jar:7.0.53]
    at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901) [catalina.jar:7.0.53]
    at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877) [catalina.jar:7.0.53]
    at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:632) [catalina.jar:7.0.53]
    at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:1073) [catalina.jar:7.0.53]
    at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1857) [catalina.jar:7.0.53]
    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [na:1.8.0_121]
    at java.util.concurrent.FutureTask.run(FutureTask.java:266) [na:1.8.0_121]
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [na:1.8.0_121]
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [na:1.8.0_121]
    at java.lang.Thread.run(Thread.java:745) [na:1.8.0_121]

I have to note that I'm not calling createClob() myself!

So what whould I change in order to get rid of this error during Tomcat 7 startup? I have also erased postgresql driver from tomcat's lib dir.

解决方案

Set hibernate.jdbc.lob.non_contextual_creation=true on your persistence.xml

这篇关于休眠与c3p0：createClob（）尚未实现的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！

查看全文
相关文章
Java开发最新文章
热门教程
热门工具
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆