Caused by: org.hibernate.HibernateException: could not instantiate CacheProvider: ...please help me

[Vinod Vinu]

Iam working on a j2ee using struts, spring and hibernate using mysql .

Iam getting the following error on my console of ecplise :-

Nov 25, 2009 4:20:17 PM org.apache.catalina.core.StandardWrapperValve invoke
SEVERE: Servlet.service() for servlet action threw exception
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'txManager' defined in ServletContext resource [/WEB-INF/applicationContext.xml]: Cannot resolve reference to bean 'sFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sFactory' defined in ServletContext resource [/WEB-INF/applicationContext.xml]: Invocation of init method failed; nested exception is org.hibernate.HibernateException: could not instantiate CacheProvider: org.hibernate.hql.ast.ASTQueryTranslatorFactory
	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:275)
	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:104)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1172)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:940)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:437)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:383)
	at java.security.AccessController.doPrivileged(Native Method)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:353)
	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:245)
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:169)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:242)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164)
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:400)
	at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:736)
	at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:369)
	at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:261)
	at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:199)
	at org.springframework.web.context.ContextLoaderServlet.init(ContextLoaderServlet.java:81)
	at javax.servlet.GenericServlet.init(GenericServlet.java:212)
	at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1139)
	at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:966)
	at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3956)
	at org.apache.catalina.core.StandardContext.start(StandardContext.java:4230)
	at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
	at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)
	at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
	at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
	at org.apache.catalina.core.StandardService.start(StandardService.java:448)
	at org.apache.catalina.core.StandardServer.start(StandardServer.java:700)
	at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)
	at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sFactory' defined in ServletContext resource [/WEB-INF/applicationContext.xml]: Invocation of init method failed; nested exception is org.hibernate.HibernateException: could not instantiate CacheProvider: org.hibernate.hql.ast.ASTQueryTranslatorFactory
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1260)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:438)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:383)
	at java.security.AccessController.doPrivileged(Native Method)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:353)
	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:245)
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:169)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:242)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164)
	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:269)
	... 35 more
Caused by: org.hibernate.HibernateException: could not instantiate CacheProvider: org.hibernate.hql.ast.ASTQueryTranslatorFactory
	at org.hibernate.cfg.SettingsFactory.createCacheProvider(SettingsFactory.java:374)
	at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:241)
	at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2009)
	at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1292)
	at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:799)
	at org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:733)
	at org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPropertiesSet(AbstractSessionFactoryBean.java:211)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1288)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1257)
	... 44 more
Caused by: java.lang.ClassCastException: org.hibernate.hql.ast.ASTQueryTranslatorFactory cannot be cast to org.hibernate.cache.CacheProvider
	at org.hibernate.cfg.SettingsFactory.createCacheProvider(SettingsFactory.java:371)
	... 52 more

    

Following is my applicationContext.xml:-

  
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC
    "-//SPRING//DTD BEAN//EN"
    "http://www.springframework.org/dtd/spring-beans.dtd">
    
<beans>

   	<!--  Bean for creating  db source object passing db info -->
   <bean id="dbSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource" >
         <property name="driverClassName">
             <value>com.mysql.jdbc.Driver</value>
         </property>         
         <property name="url">
             <value>jdbc:mysql://localhost:3306/company</value>
         </property>         
         <property name="username">
         <value>root</value>
         </property>                
         <property name="password">
         <value>password</value>
         </property>         
   </bean>       

  <!-- Creating Transaction Manager Object -->
  <bean id="txManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
    <property name="sessionFactory">
     <ref bean="sFactory"/>
    </property>  
  </bean>
  
  <!-- Creating the Session Factory Object -->
  <bean id="sFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
    <property name="dataSource">
    <ref bean="dbSource"/>
    </property>
    
      <!-- Hibernate Dialect Information -->
       <property name="hibernateProperties">
         <props>
             <prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
             <prop key="hibernate.cache.provider_class">org.hibernate.hql.ast.ASTQueryTranslatorFactory</prop>
             <prop key="hibernate.show_sql">true</prop>
			 <prop key="hibernate.format_sql">true</prop>
			 <prop key="hibernate.cache.use_query_cache">true</prop>
			 <prop key="hibernate.bytecode.use_reflection_optimizer">true</prop>
         </props>      
       </property>
       
       
      <!-- List of HBM Files --> 
      <property name="mappingResources">
        <list>
           <value>model/employee.hbm.xml</value>
        </list>      
      </property>      
  </bean>
  
     <!-- Creating Hibernate Template Object -->     
     <bean id="hibernateTemplate" class="org.springframework.orm.hibernate3.HibernateTemplate">
       <property name="sessionFactory">
         <ref bean="sFactory"/>
       </property>       
     </bean>


    <!-- List DAO Created by the Programmer -->
    <bean name="empDao" class="dao.EmployeeDAOImpl">
       <property name="sessionFactory">
			<ref bean="sFactory" />
		</property>
		<property name="hibernateTemplate">
			<ref bean="hibernateTemplate" />
		</property>    
    </bean>

</beans>    

Thanks in advance

[Al Coson]

Are you sure you have supplyed the right cache provider? It seems as you have provided org.hibernate.hql.ast.ASTQueryTranslatorFactory Which by the look of the name doesn't have much to do with cache.

I dont know much about this, probably less than you, but id try replace that with something else. Like: org.hibernate.cache.EhCacheProvider

This is probably the solution to the other thread you alos posted.

Do tell how it goes.

[Al Coson]

Im using this for my cache provider: "org.hibernate.cache.NoCacheProvider". Why? I have not clue. Does it work? It sure does.

[Aditya Keyal]

You cannot use org.hibernate.hql.ast.ASTQueryTranslatorFactory since it implements QueryTranslatorFactory.

For the CacheProvider you need to use any of the following classes
1) AbstractJndiBoundCacheProvider
2) EhCacheProvider
3)HashtableCacheProvider,
4) NoCacheProvider,
5) OptimisticTreeCacheProvider,
6) OSCacheProvider,
7) SwarmCacheProvider,
8) TreeCacheProvider

You can get more details on all of the above from the given links.