连接oracle 12c时的bug

wangsm

最近接触这个jeecg，下载了3.6.6版本来试用一下，选择了oracle 12c作为数据库
配置好后启动应用，一切正常，也能正常登录，进入主页后点击左边的菜单下面的功能，都报错，错误是找不到方言。求解

1. [org.jeecgframework.core.common.exception.GlobalExceptionResolver]全局处理异常捕获:
   
2. org.hibernate.MappingException: No Dialect mapping for JDBC type: -9
   
3.         at org.hibernate.dialect.TypeNames.get(TypeNames.java:76)
   
4.         at org.hibernate.dialect.TypeNames.get(TypeNames.java:99)
   
5.         at org.hibernate.dialect.Dialect.getHibernateTypeName(Dialect.java:565)
   
6.         at org.hibernate.loader.custom.CustomLoader$Metadata.getHibernateType(CustomLoader.java:660)
   
7.         at org.hibernate.loader.custom.CustomLoader$ScalarResultColumnProcessor.performDiscovery(CustomLoader.java:564)
   
8.         at org.hibernate.loader.custom.CustomLoader.autoDiscoverTypes(CustomLoader.java:580)
   
9.         at org.hibernate.loader.Loader.getResultSet(Loader.java:1970)
   
10.         at org.hibernate.loader.Loader.doQuery(Loader.java:829)
    
11.         at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:289)
    
12.         at org.hibernate.loader.Loader.doList(Loader.java:2447)
    
13.         at org.hibernate.loader.Loader.doList(Loader.java:2433)
    
14.         at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2263)
    
15.         at org.hibernate.loader.Loader.list(Loader.java:2258)
    
16.         at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:331)
    
17.         at org.hibernate.internal.SessionImpl.listCustomQuery(SessionImpl.java:1697)
    
18.         at org.hibernate.internal.AbstractSessionImpl.list(AbstractSessionImpl.java:225)
    
19.         at org.hibernate.internal.SQLQueryImpl.list(SQLQueryImpl.java:156)
    
20.         at org.jeecgframework.core.common.dao.impl.GenericBaseCommonDao.findListbySql(GenericBaseCommonDao.java:406)
    
21.         at org.jeecgframework.core.common.service.impl.CommonServiceImpl.findListbySql(CommonServiceImpl.java:196)
    
22.         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    
23.         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    
24.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    
25.         at java.lang.reflect.Method.invoke(Method.java:606)
    
26.         at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
    
27.         at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
    
28.         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
    
29.         at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:98)
    
30.         at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:262)
    
31.         at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:95)
    
32.         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    
33.         at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
    
34.         at com.sun.proxy.$Proxy92.findListbySql(Unknown Source)
    
35.         at org.jeecgframework.core.interceptors.AuthInterceptor.hasMenuAuth(AuthInterceptor.java:230)
    
36.         at org.jeecgframework.core.interceptors.AuthInterceptor.preHandle(AuthInterceptor.java:92)
    
37.         at org.springframework.web.servlet.HandlerExecutionChain.applyPreHandle(HandlerExecutionChain.java:134)
    
38.         at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:932)
    
39.         at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:870)
    
40.         at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:961)
    
41.         at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:852)
    
42.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:624)
    
43.         at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:837)
    
44.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
    
45.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
    
46.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    
47.         at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
    
48.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
    
49.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    
50.         at org.jeecgframework.core.aop.GZipFilter.doFilter(GZipFilter.java:93)
    
51.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
    
52.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    
53.         at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:140)
    
54.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
    
55.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    
56.         at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
    
57.         at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
    
58.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
    
59.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    
60.         at org.springframework.orm.hibernate4.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:150)
    
61.         at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
    
62.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
    
63.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    
64.         at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:218)
    
65.         at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
    
66.         at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:506)
    
67.         at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
    
68.         at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
    
69.         at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:962)
    
70.         at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
    
71.         at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:452)
    
72.         at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1087)
    
73.         at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)
    
74.         at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2536)
    
75.         at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2525)
    
76.         at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    
77.         at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
    
78.         at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
    
79.         at java.lang.Thread.run(Thread.java:745)

复制代码

admin

官方支持oracle11g 12请自行调优