Org.springframework.orm.hibernate3.HibernateSystemException:No dialect mapping for JDBC type:-9; Nested exception is Org.hibernate.MappingException:No dialect mapping for JDBC type: 9
At Org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException ( sessionfactoryutils.java:676)
At Org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException (Hibernateaccessor.java : 412)
At Org.springframework.orm.hibernate3.HibernateTemplate.doExecute (hibernatetemplate.java:424)
At Org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession (hibernatetemplate.java:374)
At Com.metinform.modules.orm.hibernate.BaseDAO.findPageBySQLQuery (basedao.java:648)
At Com.metinform.cqcus.dao.CusTaxAddDAO.findPrintBillList (custaxadddao.java:186)
At Com.metinform.cqcus.service.CusTaxAddService.findPrintBillList (custaxaddservice.java:124)
At com.metinform.cqcus.service.custaxaddservice$ $FastClassByCGLIB $ $f 1fed68.invoke (<generated>)
At Net.sf.cglib.proxy.MethodProxy.invoke (methodproxy.java:149)
At Org.springframework.aop.framework.cglib2aopproxy$cglibmethodinvocation.invokejoinpoint (Cglib2AopProxy.java : 700)
At Org.springframework.aop.framework.ReflectiveMethodInvocation.proceed (reflectivemethodinvocation.java:149)
At Org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed ( methodinvocationproceedingjoinpoint.java:77)
At Com.metinform.modules.slf4j.BizLogAdvice.bizlog (bizlogadvice.java:30)
At Sun.reflect.GeneratedMethodAccessor43.invoke (Unknown Source)
At Sun.reflect.DelegatingMethodAccessorImpl.invoke (delegatingmethodaccessorimpl.java:25)
At Java.lang.reflect.Method.invoke (method.java:597)
At Org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs ( abstractaspectjadvice.java:627)
At Org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod (abstractaspectjadvice.java:616)
At Org.springframework.aop.aspectj.AspectJAroundAdvice.invoke (aspectjaroundadvice.java:64)
At Org.springframework.aop.framework.ReflectiveMethodInvocation.proceed (reflectivemethodinvocation.java:171)
At Org.springframework.transaction.interceptor.TransactionInterceptor.invoke (transactioninterceptor.java:106)
At Org.springframework.aop.framework.ReflectiveMethodInvocation.proceed (reflectivemethodinvocation.java:171)
At Org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke (exposeinvocationinterceptor.java:89)
At Org.springframework.aop.framework.ReflectiveMethodInvocation.proceed (reflectivemethodinvocation.java:171)
At Org.springframework.aop.framework.cglib2aopproxy$dynamicadvisedinterceptor.intercept (Cglib2AopProxy.java:635 )
At com.metinform.cqcus.service.custaxaddservice$ $EnhancerByCGLIB $$4a35c19d.findprintbilllist (<generated>)
At Com.metinform.cqcus.web.CusTaxAddAction.printForm (custaxaddaction.java:390)
At Sun.reflect.GeneratedMethodAccessor145.invoke (Unknown Source)
At Sun.reflect.DelegatingMethodAccessorImpl.invoke (delegatingmethodaccessorimpl.java:25)
At Java.lang.reflect.Method.invoke (method.java:597)
At Com.opensymphony.xwork2.DefaultActionInvocation.invokeAction (defaultactioninvocation.java:450)
At Com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly (defaultactioninvocation.java:289)
At Com.opensymphony.xwork2.DefaultActionInvocation.invoke (defaultactioninvocation.java:252)
At Com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept (Defaultworkflowinterceptor.java : 167)
At Com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept (methodfilterinterceptor.java:98)
At Com.opensymphony.xwork2.DefaultActionInvocation.invoke (defaultactioninvocation.java:246)
At Com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept (validationinterceptor.java:265)
At Org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept ( annotationvalidationinterceptor.java:68)
At Com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept (methodfilterinterceptor.java:98)
At Com.opensymphony.xwork2.DefaultActionInvocation.invoke (defaultactioninvocation.java:246)
At Com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept (conversionerrorinterceptor.java:138 )
At Com.opensymphony.xwork2.DefaultActionInvocation.invoke (defaultactioninvocation.java:246)
At Com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept (parametersinterceptor.java:239)
At Com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept (methodfilterinterceptor.java:98)
At Com.opensymphony.xwork2.DefaultActionInvocation.invoke (defaultactioninvocation.java:246)
At Com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept (parametersinterceptor.java:239)
At Com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept (methodfilterinterceptor.java:98)
At Com.opensymphony.xwork2.DefaultActionInvocation.invoke (defaultactioninvocation.java:246)
At Com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept (Staticparametersinterceptor.java : 191)
At Com.opensymphony.xwork2.DefaultActionInvocation.invoke (defaultactioninvocation.java:246)
At Org.apache.struts2.interceptor.FileUploadInterceptor.intercept (fileuploadinterceptor.java:252)
At Com.opensymphony.xwork2.DefaultActionInvocation.invoke (defaultactioninvocation.java:246)
At Com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept (modeldriveninterceptor.java:100)
At Com.opensymphony.xwork2.DefaultActionInvocation.invoke (defaultactioninvocation.java:246)
At Com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept (chaininginterceptor.java:145)
At Com.opensymphony.xwork2.DefaultActionInvocation.invoke (defaultactioninvocation.java:246)
At Com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept (prepareinterceptor.java:171)
At Com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept (methodfilterinterceptor.java:98)
At Com.opensymphony.xwork2.DefaultActionInvocation.invoke (defaultactioninvocation.java:246)
At Org.apache.struts2.interceptor.ServletConfigInterceptor.intercept (servletconfiginterceptor.java:164)
At Com.opensymphony.xwork2.DefaultActionInvocation.invoke (defaultactioninvocation.java:246)
At Com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept (parametersinterceptor.java:239)
At Com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept (methodfilterinterceptor.java:98)
At Com.opensymphony.xwork2.DefaultActionInvocation.invoke (defaultactioninvocation.java:246)
At Org.apache.struts2.interceptor.MultiselectInterceptor.intercept (multiselectinterceptor.java:73)
At Com.opensymphony.xwork2.DefaultActionInvocation.invoke (defaultactioninvocation.java:246)
At Org.apache.struts2.interceptor.CheckboxInterceptor.intercept (checkboxinterceptor.java:91)
At Com.opensymphony.xwork2.DefaultActionInvocation.invoke (defaultactioninvocation.java:246)
At Com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept (i18ninterceptor.java:161)
At Com.opensymphony.xwork2.DefaultActionInvocation.invoke (defaultactioninvocation.java:246)
At Com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept (aliasinterceptor.java:193)
At Com.opensymphony.xwork2.DefaultActionInvocation.invoke (defaultactioninvocation.java:246)
At Com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept (Exceptionmappinginterceptor.java : 189)
At Com.opensymphony.xwork2.DefaultActionInvocation.invoke (defaultactioninvocation.java:246)
At Org.apache.struts2.impl.StrutsActionProxy.execute (strutsactionproxy.java:54)
At Org.apache.struts2.dispatcher.Dispatcher.serviceAction (dispatcher.java:563)
At Org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction (executeoperations.java:77)
At Org.apache.struts2.dispatcher.ng.filter.StrutsExecuteFilter.doFilter (strutsexecutefilter.java:93)
At Org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (applicationfilterchain.java:243)
At Org.apache.catalina.core.ApplicationFilterChain.doFilter (applicationfilterchain.java:210)
At Com.opensymphony.sitemesh.webapp.SiteMeshFilter.obtainContent (sitemeshfilter.java:129)
At Com.opensymphony.sitemesh.webapp.SiteMeshFilter.doFilter (sitemeshfilter.java:77)
At Org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (applicationfilterchain.java:243)
At Org.apache.catalina.core.ApplicationFilterChain.doFilter (applicationfilterchain.java:210)
At Org.apache.struts2.dispatcher.ng.filter.StrutsPrepareFilter.doFilter (strutspreparefilter.java:91)
At Org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (applicationfilterchain.java:243)
At Org.apache.catalina.core.ApplicationFilterChain.doFilter (applicationfilterchain.java:210)
At Com.metinform.app.slf4j.MDCFilter.doFilter (mdcfilter.java:63)
At Org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (applicationfilterchain.java:243)
At Org.apache.catalina.core.ApplicationFilterChain.doFilter (applicationfilterchain.java:210)
At Org.springframework.security.util.filterchainproxy$virtualfilterchain.dofilter (FilterChainProxy.java:378)
At Org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke (Filtersecurityinterceptor.java : 109)
At Org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter (Filtersecurityinterceptor.java : 83)
At Org.springframework.security.util.filterchainproxy$virtualfilterchain.dofilter (FilterChainProxy.java:390)
At Org.springframework.security.ui.SessionFixationProtectionFilter.doFilterHttp ( SESSIONFIXATIONPROTECTIONFILTER.JAVA:67)
At Org.springframework.security.ui.SpringSecurityFilter.doFilter (springsecurityfilter.java:53)
At Org.springframework.security.util.filterchainproxy$virtualfilterchain.dofilter (FilterChainProxy.java:390)
At Org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp (exceptiontranslationfilter.java:101)
At Org.springframework.security.ui.SpringSecurityFilter.doFilter (springsecurityfilter.java:53)
At Org.springframework.security.util.filterchainproxy$virtualfilterchain.dofilter (FilterChainProxy.java:390)
At Org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp ( securitycontextholderawarerequestfilter.java:91)
At Org.springframework.security.ui.SpringSecurityFilter.doFilter (springsecurityfilter.java:53)
At Org.springframework.security.util.filterchainproxy$virtualfilterchain.dofilter (FilterChainProxy.java:390)
At Org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp (abstractprocessingfilter.java:278)
At Org.springframework.security.ui.SpringSecurityFilter.doFilter (springsecurityfilter.java:53)
At Org.springframework.security.util.filterchainproxy$virtualfilterchain.dofilter (FilterChainProxy.java:390)
At Com.metinform.modules.security.springsecurity.SpringSecurityLogFilter.doFilterHttp ( SPRINGSECURITYLOGFILTER.JAVA:46)
At Org.springframework.security.ui.SpringSecurityFilter.doFilter (springsecurityfilter.java:53)
At Org.springframework.security.util.filterchainproxy$virtualfilterchain.dofilter (FilterChainProxy.java:390)
At Org.springframework.security.ui.logout.LogoutFilter.doFilterHttp (logoutfilter.java:89)
At Org.springframework.security.ui.SpringSecurityFilter.doFilter (springsecurityfilter.java:53)
At Org.springframework.security.util.filterchainproxy$virtualfilterchain.dofilter (FilterChainProxy.java:390)
At Com.metinform.app.security.springsecurity.SpringSecurityLogOutLogFilter.doFilterHttp ( SPRINGSECURITYLOGOUTLOGFILTER.JAVA:66)
At Org.springframework.security.ui.SpringSecurityFilter.doFilter (springsecurityfilter.java:53)
At Org.springframework.security.util.filterchainproxy$virtualfilterchain.dofilter (FilterChainProxy.java:390)
At Org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp ( httpsessioncontextintegrationfilter.java:235)
At Org.springframework.security.ui.SpringSecurityFilter.doFilter (springsecurityfilter.java:53)
At Org.springframework.security.util.filterchainproxy$virtualfilterchain.dofilter (FilterChainProxy.java:390)
At Org.springframework.security.util.FilterChainProxy.doFilter (filterchainproxy.java:175)
At Org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate (delegatingfilterproxy.java:236)
At Org.springframework.web.filter.DelegatingFilterProxy.doFilter (delegatingfilterproxy.java:167)
At Org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (applicationfilterchain.java:243)
At Org.apache.catalina.core.ApplicationFilterChain.doFilter (applicationfilterchain.java:210)
At Org.jasig.cas.client.session.SingleSignOutFilter.doFilter (singlesignoutfilter.java:110)
At Org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (applicationfilterchain.java:243)
At Org.apache.catalina.core.ApplicationFilterChain.doFilter (applicationfilterchain.java:210)
At Org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal (characterencodingfilter.java:96)
At Org.springframework.web.filter.OncePerRequestFilter.doFilter (onceperrequestfilter.java:76)
At Org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (applicationfilterchain.java:243)
At Org.apache.catalina.core.ApplicationFilterChain.doFilter (applicationfilterchain.java:210)
At Org.apache.catalina.core.StandardWrapperValve.invoke (standardwrappervalve.java:224)
At Org.apache.catalina.core.StandardContextValve.invoke (standardcontextvalve.java:169)
At Org.apache.catalina.authenticator.AuthenticatorBase.invoke (authenticatorbase.java:472)
At Org.apache.catalina.core.StandardHostValve.invoke (standardhostvalve.java:168)
At Org.apache.catalina.valves.ErrorReportValve.invoke (errorreportvalve.java:98)
At Org.apache.catalina.valves.AccessLogValve.invoke (accesslogvalve.java:927)
At Org.apache.catalina.core.StandardEngineValve.invoke (standardenginevalve.java:118)
At Org.apache.catalina.connector.CoyoteAdapter.service (coyoteadapter.java:407)
At Org.apache.coyote.http11.AbstractHttp11Processor.process (abstracthttp11processor.java:987)
At Org.apache.coyote.abstractprotocol$abstractconnectionhandler.process (abstractprotocol.java:579)
At Org.apache.tomcat.util.net.jioendpoint$socketprocessor.run (jioendpoint.java:307)
At Java.util.concurrent.threadpoolexecutor$worker.runtask (threadpoolexecutor.java:886)
At Java.util.concurrent.threadpoolexecutor$worker.run (threadpoolexecutor.java:908)
At Java.lang.Thread.run (thread.java:662)
caused By:org.hibernate.MappingException:No dialect mapping for JDBC type: 9
At Org.hibernate.dialect.TypeNames.get (typenames.java:79)
At Org.hibernate.dialect.TypeNames.get (typenames.java:104)
At Org.hibernate.dialect.Dialect.getHibernateTypeName (dialect.java:393)
At Org.hibernate.loader.custom.customloader$metadata.gethibernatetype (customloader.java:582)
At Org.hibernate.loader.custom.customloader$scalarresultcolumnprocessor.performdiscovery (CustomLoader.java:508)
At Org.hibernate.loader.custom.CustomLoader.autoDiscoverTypes (customloader.java:524)
At Org.hibernate.loader.Loader.getResultSet (loader.java:1821)
At Org.hibernate.loader.Loader.doQuery (loader.java:697)
At Org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections (loader.java:259)
At Org.hibernate.loader.Loader.doList (loader.java:2232)
At Org.hibernate.loader.Loader.listIgnoreQueryCache (loader.java:2129)
At Org.hibernate.loader.Loader.list (loader.java:2124)
At Org.hibernate.loader.custom.CustomLoader.list (customloader.java:312)
At Org.hibernate.impl.SessionImpl.listCustomQuery (sessionimpl.java:1723)
At Org.hibernate.impl.AbstractSessionImpl.list (abstractsessionimpl.java:165)
At Org.hibernate.impl.SQLQueryImpl.list (sqlqueryimpl.java:175)
At Com.metinform.modules.orm.hibernate.basedao$9.doinhibernate (basedao.java:679)
At Org.springframework.orm.hibernate3.HibernateTemplate.doExecute (hibernatetemplate.java:419)
... 141 more
The SQL statements in the page, the fields are VARCHAR2, date, number type, and later modified a field nvarchar2 (as if), the above problem occurs.
Error: No dialect mapping for JDBC type:-9