spring+hibernate+mysql执行HQL查询报未打开游标错误

Question

spring配置:
[code="java"]


java:comp/env/jdbc/MY

org.hibernate.dialect.MySQL5InnoDBDialect

true

            <prop key="hibernate.max_fetch_depth">0</prop>      
            <prop key="hibernate.jdbc.fetch_size">100</prop>
            <prop key="hibernate.jdbc.batch_size">50</prop>
            <prop key="hibernate.cache.provider_class">org.hibernate.cache.HashtableCacheProvider</prop>
         </props>

    </property>
        </bean>

p:sessionFactory-ref="sessionFactory"/>
[/code]

执行HibernateTemplate的HQL查询语句(如:getHibernateTemplate().find("from SysUser")方法)时候报错: The statement (1) has no open cursor.

有遇到过同样问题的吗？

Answer 1

用JDBC5.0驱动