0 Replies Latest reply on Sep 14, 2013 3:58 AM by syedmuqthar

    Error in Hibernate Tool in Eclipse Unable to create requested service [org.hibernate.service.jdbc.connections.spi.ConnectionProvider]

    syedmuqthar
    syedmuqthar Sep 14, 2013 3:58 AM

      Please help me out.

         

      I am using

      JBoss Hibernate Tool 3.3

      Eclipse Indigo

         

      **hibernate.cfg.xml**

         

          <hibernate-configuration>

          <session-factory>

          <property name="hibernate.connection.driver_class">oracle.jdbc.driver.OracleDriver</property>

          <property name="hibernate.connection.password">cisadm</property>

          <property name="hibernate.connection.url">jdbc:oracle:thin:@localhost:1521:CCB240</property>

          <property name="hibernate.connection.username">cisadm</property>

          <property name="hibernate.dialect">org.hibernate.dialect.Oracle10gDialect</property>

         

          </session-factory>

          </hibernate-configuration>

         

         

      hibernate.properties

         

          hibernate.connection.driver_class = oracle.jdbc.driver.OracleDriver

         

          hibernate.connection.url = jdbc:oracle:thin:@localhost:1521:CCB240

         

          hibernate.connection.username = cisadm

          hibernate.connection.password = ENC(YoYU3xkTjrrX1hIbldx9DhkGadCBjvliVNh/i4CWQvg=)

          hibernate.dialect = org.hibernate.dialect.Oracle10gDialect

          hibernate.show_sql = false

          hibernate.max_fetch_depth = 2

          hibernate.transaction.factory_class = org.hibernate.transaction.JDBCTransactionFactory

         

          hibernate.jdbc.fetch_size = 100

          hibernate.jdbc.batch_size = 30

         

          hibernate.query.factory_class=org.hibernate.hql.classic.ClassicQueryTranslatorFactory

          hibernate.cache.use_second_level_cache = false

          hibernate.query.substitutions = true 'Y', false 'N'

         

         

          hibernate.connection.provider_class=org.hibernate.connection.C3P0ConnectionProvider

          hibernate.c3p0.acquire_increment=1

          hibernate.c3p0.idle_test_period=180

          hibernate.c3p0.max_size=60

          hibernate.c3p0.max_statements=0

          hibernate.c3p0.min_size=10

         

        And my Hibernate Tool Configuration are in the link below.

      http://tinypic.com/a/2thn5/4

       

       

      But when I run the hql in HQL Editor I get the below error

         

          org.hibernate.service.spi.ServiceException: Unable to create requested service [org.hibernate.service.jdbc.connections.spi.ConnectionProvider]

          at org.hibernate.service.internal.AbstractServiceRegistryImpl.createService(AbstractServiceRegistryImpl.java:193)

          at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:156)

          at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:139)

          at org.hibernate.engine.jdbc.internal.JdbcServicesImpl.buildJdbcConnectionAccess(JdbcServicesImpl.java:208)

          at org.hibernate.engine.jdbc.internal.JdbcServicesImpl.configure(JdbcServicesImpl.java:85)

          at org.hibernate.service.internal.StandardServiceRegistryImpl.configureService(StandardServiceRegistryImpl.java:75)

          at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:165)

          at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:139)

          at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:71)

          at org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.java:2259)

          at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2255)

          at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1724)

          at org.jboss.tools.hibernate4_0.HibernateExtension4_0$3.execute(HibernateExtension4_0.java:118)

          at org.hibernate.console.execution.DefaultExecutionContext.execute(DefaultExecutionContext.java:63)

          at org.jboss.tools.hibernate4_0.HibernateExtension4_0.execute(HibernateExtension4_0.java:211)

          at org.jboss.tools.hibernate4_0.HibernateExtension4_0.buildSessionFactory(HibernateExtension4_0.java:110)

          at org.hibernate.console.ConsoleConfiguration.buildSessionFactory(ConsoleConfiguration.java:283)

          at org.hibernate.eclipse.console.actions.ExecuteQueryAction.execute(ExecuteQueryAction.java:82)

          at org.hibernate.eclipse.console.actions.ExecuteQueryAction.run(ExecuteQueryAction.java:56)

          at org.eclipse.jface.action.Action.runWithEvent(Action.java:498)

          at org.hibernate.eclipse.console.actions.ExecuteQueryAction.runWithEvent(ExecuteQueryAction.java:60)

          at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:584)

          at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:501)

          at org.eclipse.jface.action.ActionContributionItem$6.handleEvent(ActionContributionItem.java:452)

          at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)

          at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1053)

          at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4165)

          at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3754)

          at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2696)

          at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2660)

          at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2494)

          at org.eclipse.ui.internal.Workbench$7.run(Workbench.java:674)

          at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)

          at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:667)

          at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)

          at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:123)

          at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)

          at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)

          at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)

          at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:344)

          at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)

          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

          at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

          at java.lang.reflect.Method.invoke(Method.java:597)

          at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:622)

          at org.eclipse.equinox.launcher.Main.basicRun(Main.java:577)

          at org.eclipse.equinox.launcher.Main.run(Main.java:1410)

          at org.eclipse.equinox.launcher.Main.main(Main.java:1386)

          Caused by: org.hibernate.HibernateException: Could not instantiate connection provider [org.hibernate.service.jdbc.connections.internal.C3P0ConnectionProvider]

          at org.hibernate.service.jdbc.connections.internal.ConnectionProviderInitiator.instantiateExplicitConnectionProvider(ConnectionProviderInitiator.java:190)

          at org.hibernate.service.jdbc.connections.internal.ConnectionProviderInitiator.initiateService(ConnectionProviderInitiator.java:112)

          at org.hibernate.service.jdbc.connections.internal.ConnectionProviderInitiator.initiateService(ConnectionProviderInitiator.java:54)

          at org.hibernate.service.internal.StandardServiceRegistryImpl.initiateService(StandardServiceRegistryImpl.java:69)

          at org.hibernate.service.internal.AbstractServiceRegistryImpl.createService(AbstractServiceRegistryImpl.java:183)

          ... 48 more

         

      I am adding the hibernate-c3p0-4.1.0.Final.jar and in the drop down I am selecting Hibernate version as 4. Can you please let me know what am I doing wrong