當(dāng)在hibernate中運(yùn)用原始的sql語句進(jìn)行操作的的時(shí)候，常常會報(bào)錯(cuò)，錯(cuò)誤很多都是關(guān)于
No Dialect mapping for JDBC type 類型的錯(cuò)誤，經(jīng)過分析和查找，問題常常發(fā)生在幾個(gè)地方
1、錯(cuò)誤的配置了hibernate的方言
2、就是你的數(shù)據(jù)庫中的字段和java里面的類型不匹配的問題
具體信息如：
eg：
Session session = HibernateSessionFactory.getSession();
String sql = "SELECT Daymarketinfo.* FROM (select * from daymarketinfo d order by market_time desc ) as Daymarketinfo group by contract_id;";
Query query = session.createSQLQuery(sql);
List<?> list = query.list();//錯(cuò)誤出現(xiàn)位置
List<JsonData> jsonList = new ArrayList<JsonData>();
for (Object obj : list) {
? Object[] arr = (Object[])obj;
? JsonData oJson = new JsonData();
? oJson.setId((Integer)arr[0]);
? /*
??? 對arr數(shù)組取出一個(gè)個(gè)取出相應(yīng)的數(shù)據(jù)就可以了，在這里就不多贅述
? */
jsonList.add(dk);
}
request.setAttribute("jsonList", jsonList);
return mapping.findForward("success");

錯(cuò)誤信息如下：

org.hibernate.MappingException: No Dialect mapping for JDBC type: 7
at org.hibernate.dialect.TypeNames.get(TypeNames.java:56)
at org.hibernate.dialect.TypeNames.get(TypeNames.java:81)
at org.hibernate.dialect.Dialect.getHibernateTypeName(Dialect.java:192)
at org.hibernate.loader.custom.CustomLoader.getHibernateType(CustomLoader.java:161)
at org.hibernate.loader.custom.CustomLoader.autoDiscoverTypes(CustomLoader.java:131)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1678)
at org.hibernate.loader.Loader.doQuery(Loader.java:662)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
at org.hibernate.loader.Loader.doList(Loader.java:2145)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
at org.hibernate.loader.Loader.list(Loader.java:2024)
at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:111)
at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1655)
at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:142)
at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:164)
at com.futures.action.manage.DaymarketinfoAction.execute(DaymarketinfoAction.java:57)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:105)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Unknown Source)


解決方法為：通過查詢hibernate的源碼，找到問題的根本所在，就是hibernate中不支持對應(yīng)的數(shù)據(jù)類型，具體數(shù)據(jù)類型的值，請查看下表


查看 java.sql.Types 類，可以找到對應(yīng)類型，調(diào)整相應(yīng)的數(shù)據(jù)庫里的類型，或者其他支持這個(gè)類型的方言。

?

為讓hibernate知道此類型。

必須一下做法：

package com.quduan;

import java.sql.Types;
import org.hibernate.Hibernate;
import org.hibernate.dialect.MySQLDialect;

public class ZJCMySQLDialect extends MySQLDialect{

public ZJCMySQLDialect () {
super();
registerHibernateType(Types.DECIMAL, Hibernate.BIG_DECIMAL.getName());
registerHibernateType(-1, Hibernate.STRING.getName());
}

}

修改：

<prop key="hibernate.dialect">
com.quduan.ZJCMySQLDialect
</prop>

這樣就可以支持BigDecimal類型了。

?

轉(zhuǎn)自： http://blog.sina.com.cn/s/blog_6b30a46b01011yw6.html

?????????? http://andinker.iteye.com/blog/789352