|
當(dāng)在hibernate中運(yùn)用原始的sql語(yǔ)句進(jìn)行操作的的時(shí)候，常常會(huì)報(bào)錯(cuò)，錯(cuò)誤很多都是關(guān)于
No Dialect mapping for JDBC type類(lèi)型的錯(cuò)誤，經(jīng)過(guò)分析和查找，問(wèn)題常常發(fā)生在幾個(gè)地方 1、錯(cuò)誤的配置了hibernate的方言 2、就是你的數(shù)據(jù)庫(kù)中的字段和java里面的類(lèi)型不匹配的問(wèn)題 具體信息如： 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]); /* 對(duì)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) 解決方法為：通過(guò)查詢(xún)hibernate的源碼，找到問(wèn)題的根本所在，就是hibernate中不支持對(duì)應(yīng)的數(shù)據(jù)類(lèi)型，具體數(shù)據(jù)類(lèi)型的值，請(qǐng)查看下表 查看 java.sql.Types 類(lèi)，可以找到對(duì)應(yīng)類(lèi)型，調(diào)整相應(yīng)的數(shù)據(jù)庫(kù)里的類(lèi)型，或者其他支持這個(gè)類(lèi)型的方言。 
|
|
|
