在休眠状态下禁用ONLY_FULL_GROUP_BY [英] Disable ONLY_FULL_GROUP_BY in hibernate
本文介绍了在休眠状态下禁用ONLY_FULL_GROUP_BY的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我需要在休眠状态下禁用ONLY_FULL_GROUP_BY. 这是我当前的会话工厂. 我不确定如何在其中指定sql_mode =''.
I need to disable ONLY_FULL_GROUP_BY in hibernate. This is my current session factory. I am not sure how to specify the sql_mode='' in this.
<bean id="eAgilitySessionFactory"
class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="dataSource" ref="eAgilitysDataSource"/>
<property name="configLocation">
<value>classpath:hibernate.cfg.xml</value>
</property>
<property name="configurationClass">
<value>org.hibernate.cfg.AnnotationConfiguration</value>
</property>
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">${mysql.dialect}</prop>
<prop key="hibernate.show_sql">false</prop>
<prop key="hibernate.connection.useUnicode">true</prop>
<prop key="hibernate.connection.characterEncoding">UTF-8</prop>
<prop key="hibernate.connection.charSet">UTF-8</prop>
<prop key="hibernate.connection.url">${dwh.db.url}</prop>
<prop key="hibernate.connection.driver_class">com.mysql.jdbc.Driver</prop>
</props>
</property>
</bean>
推荐答案
我认为您可以在JDBC连接字符串中设置sql_mode
,例如
I think you can set sql_mode
in your JDBC connection string, e.g.
jdbc:mysql://localhost:3306/dbName?sessionVariables=sql_mode=''
这篇关于在休眠状态下禁用ONLY_FULL_GROUP_BY的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文