hibernateのデータベース方言関数の追加
4176 ワード
セッションファクトリでhibernateを設定します.dialectプロパティmysqlを例にclassをカスタムクラスに設定します.
<bean id="chartSessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="dataSource" ref="chartDataSource" />
<property name="mappingLocations">
<list>
<value>classpath*:com/landray/kmss/hrt/chart/model/*.hbm.xml</value>
<value>classpath:com/landray/kmss/component/dbop/model/CompDbcp.hbm.xml</value>
<value>classpath:com/landray/kmss/hrt/config/model/HrtConfigPersonalInfo.hbm.xml</value>
<value>classpath:com/landray/kmss/hrt/config/model/HrtConfigTrainServer.hbm.xml</value>
<value>classpath:com/landray/kmss/hrt/config/model/HrtConfigTrainMain.hbm.xml</value>
<value>classpath:com/landray/kmss/hrt/config/model/HrtConfigTechnology.hbm.xml</value>
<value>classpath:com/landray/kmss/hrt/config/model/HrtConfigPolitics.hbm.xml</value>
<value>classpath:com/landray/kmss/hrt/config/model/HrtConfigFunction.hbm.xml</value>
<value>classpath:com/landray/kmss/hrt/config/model/HrtConfigEducation.hbm.xml</value>
<value>classpath:com/landray/kmss/hrt/config/model/HrtConfigNation.hbm.xml</value>
<value>classpath:com/landray/kmss/sys/organization/model/SysOrgPost.hbm.xml</value>
<value>classpath:com/landray/kmss/sys/organization/model/SysOrgGroupCate.hbm.xml</value>
<value>classpath:com/landray/kmss/sys/organization/model/SysOrgGroup.hbm.xml</value>
<value>classpath:com/landray/kmss/sys/organization/model/SysOrgElement.hbm.xml</value>
<value>classpath:com/landray/kmss/sys/organization/model/SysOrgPerson.hbm.xml</value>
<value>classpath:com/landray/kmss/hrt/course/scorm/model/HrtStudyCourse.hbm.xml</value>
<value>classpath:com/landray/kmss/hrt/course/scorm/model/HrtStudyCourseType.hbm.xml</value>
<value>classpath:com/landray/kmss/hrt/course/scorm/model/HrtCourseProperties.hbm.xml</value>
<value>classpath:com/landray/kmss/hrt/course/scorm/model/HrtStudyStudentCourse.hbm.xml</value>
</list>
</property>
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">com.landray.kmss.util.MySQLLocalDialect</prop>
<prop key="hibernate.show_sql">${chartDB.hibernate.show_sql}</prop>
<prop key="hibernate.format_sql">${chartDB.hibernate.format_sql}</prop>
<prop key="hibernate.jdbc.fetch_size">${chartDB.hibernate.jdbc.fetch_size}</prop>
<prop key="hibernate.jdbc.batch_size">${chartDB.hibernate.jdbc.batch_size}</prop>
<prop key="hibernate.cache.provider_class">org.hibernate.cache.HashtableCacheProvider</prop>
</props>
</property>
<property name="lobHandler" ref="defaultLobHandler2"></property>
</bean>
package com.landray.kmss.util;
import org.hibernate.dialect.function.SQLFunctionTemplate;
/**
* @author Zhangyanan
* mysql
*/
public class MySQLLocalDialect extends org.hibernate.dialect.MySQL5Dialect {
public MySQLLocalDialect(){
super();
registerFunction("convert", new SQLFunctionTemplate(org.hibernate.Hibernate.STRING, "convert(?1 using ?2)") );
registerFunction("convert_gbk", new SQLFunctionTemplate(org.hibernate.Hibernate.STRING, "convert(?1 using gbk)") );
}
}
hql select u from User order by convert(personName,gbk) select u from User order by convert_gbk(userName)