2 Replies Latest reply on Feb 29, 2012 11:43 AM by Adam Warski

    c3p0 connection issue

    sky cool Newbie

      Could 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...