c3p0 connection issue
coolsky Feb 28, 2012 4:08 AMCould anyone here help me sort out this issue? It seems related to c3p0 connection provider. Please suggest. Thanks in advance.
17:05:22,969 INFO [org.hibernate.service.jdbc.connections.internal.ConnectionProviderInitiator] (MSC service thread 1-5) HHH000130: Instantiating exp licit connection provider: org.hibernate.service.jdbc.connections.internal.C3P0ConnectionProvider 17:05:22,969 INFO [stdout] (MSC service thread 1-5) org.hibernate.service.spi.ServiceException: Unable to create requested service [org.hibernate.ser vice.jdbc.connections.spi.ConnectionProvider] 17:05:22,969 INFO [stdout] (MSC service thread 1-5) at org.hibernate.service.internal.AbstractServiceRegistryImpl.createService(AbstractServiceReg istryImpl.java:187) 17:05:22,969 INFO [stdout] (MSC service thread 1-5) at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServic eRegistryImpl.java:150) 17:05:22,979 INFO [stdout] (MSC service thread 1-5) at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegist ryImpl.java:131) 17:05:22,979 INFO [stdout] (MSC service thread 1-5) at org.hibernate.engine.jdbc.internal.JdbcServicesImpl.buildJdbcConnectionAccess(JdbcServicesI mpl.java:234) 17:05:22,979 INFO [stdout] (MSC service thread 1-5) at org.hibernate.engine.jdbc.internal.JdbcServicesImpl.configure(JdbcServicesImpl.java:91) 17:05:22,979 INFO [stdout] (MSC service thread 1-5) at org.hibernate.service.internal.StandardServiceRegistryImpl.configureService(StandardService RegistryImpl.java:75) 17:05:22,989 INFO [stdout] (MSC service thread 1-5) at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServic eRegistryImpl.java:159) 17:05:22,989 INFO [stdout] (MSC service thread 1-5) at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegist ryImpl.java:131) 17:05:22,989 INFO [stdout] (MSC service thread 1-5) at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:71) 17:05:22,989 INFO [stdout] (MSC service thread 1-5) at org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.java:2270) 17:05:22,989 INFO [stdout] (MSC service thread 1-5) at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2266) 17:05:22,999 INFO [stdout] (MSC service thread 1-5) at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1735) 17:05:22,999 INFO [stdout] (MSC service thread 1-5) at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1775)
Caused by: org.hibernate.HibernateException: Could not instantiate connection provider [org.hibernate.service.jdbc.connections.internal.C3P0Connection Provider] at org.hibernate.service.jdbc.connections.internal.ConnectionProviderInitiator.instantiateExplicitConnectionProvider(ConnectionProviderInitiat or.java:190) [hibernate-core-4.0.1.Final.jar:4.0.1.Final] at org.hibernate.service.jdbc.connections.internal.ConnectionProviderInitiator.initiateService(ConnectionProviderInitiator.java:112) [hibernat e-core-4.0.1.Final.jar:4.0.1.Final] at org.hibernate.service.jdbc.connections.internal.ConnectionProviderInitiator.initiateService(ConnectionProviderInitiator.java:54) [hibernate -core-4.0.1.Final.jar:4.0.1.Final] at org.hibernate.service.internal.StandardServiceRegistryImpl.initiateService(StandardServiceRegistryImpl.java:69) [hibernate-core-4.0.1.Final .jar:4.0.1.Final] at org.hibernate.service.internal.AbstractServiceRegistryImpl.createService(AbstractServiceRegistryImpl.java:177) [hibernate-core-4.0.1.Final. jar:4.0.1.Final] ... 51 more Caused by: org.hibernate.service.classloading.spi.ClassLoadingException: Unable to load class [org.hibernate.service.jdbc.connections.internal.C3P0Con nectionProvider] at org.hibernate.service.classloading.internal.ClassLoaderServiceImpl.classForName(ClassLoaderServiceImpl.java:141) [hibernate-core-4.0.1.Fina l.jar:4.0.1.Final] at org.hibernate.service.jdbc.connections.internal.ConnectionProviderInitiator.instantiateExplicitConnectionProvider(ConnectionProviderInitiat or.java:187) [hibernate-core-4.0.1.Final.jar:4.0.1.Final] ... 55 more Caused by: java.lang.ClassNotFoundException: Could not load requested class : org.hibernate.service.jdbc.connections.internal.C3P0ConnectionProvider at org.hibernate.service.classloading.internal.ClassLoaderServiceImpl$1.findClass(ClassLoaderServiceImpl.java:99) [hibernate-core-4.0.1.Final. jar:4.0.1.Final] at java.lang.ClassLoader.loadClass(ClassLoader.java:306) [rt.jar:1.6.0_07] at java.lang.ClassLoader.loadClass(ClassLoader.java:251) [rt.jar:1.6.0_07] at org.hibernate.service.classloading.internal.ClassLoaderServiceImpl.classForName(ClassLoaderServiceImpl.java:138) [hibernate-core-4.0.1.Fina
I read from Hibernate 4 document and it seems c3p0 connection pool can be configured but why I still get this error above...