ssh项目 com.mchange.v2.c3p0.impl.NewProxyPreparedStatement不能转换为 java.sql.CallableS
16lz
2021-01-22
本人第一次做ssh项目，面对这些不常见的异常有点摸不着头脑，希望大神们解答，谢谢！
Exceptioninthread"Timer-0"java.lang.ClassCastException:com.mchange.v2.c3p0.impl.NewProxyPreparedStatementcannotbecasttojava.sql.CallableStatement
atorg.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:75)
atorg.hibernate.loader.Loader.getResultSet(Loader.java:2066)
atorg.hibernate.loader.Loader.executeQueryStatement(Loader.java:1863)
atorg.hibernate.loader.Loader.executeQueryStatement(Loader.java:1839)
atorg.hibernate.loader.Loader.doQuery(Loader.java:910)
atorg.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:355)
atorg.hibernate.loader.Loader.doList(Loader.java:2554)
atorg.hibernate.loader.Loader.doList(Loader.java:2540)
atorg.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2370)
atorg.hibernate.loader.Loader.list(Loader.java:2365)
atorg.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:497)
atorg.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:387)
atorg.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:236)
atorg.hibernate.internal.SessionImpl.list(SessionImpl.java:1300)
atorg.hibernate.internal.QueryImpl.list(QueryImpl.java:103)
atcn.it.shop.service.impl.CategoryServiceImpl.queryByHot(CategoryServiceImpl.java:47)
atsun.reflect.NativeMethodAccessorImpl.invoke0(NativeMethod)
atsun.reflect.NativeMethodAccessorImpl.invoke(UnknownSource)
atsun.reflect.DelegatingMethodAccessorImpl.invoke(UnknownSource)
atjava.lang.reflect.Method.invoke(UnknownSource)
atorg.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)
atorg.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
atorg.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
atorg.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
atorg.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
atorg.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
atorg.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
atorg.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
atorg.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
atorg.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208)
atcom.sun.proxy.$Proxy29.queryByHot(UnknownSource)
atcn.it.shop.utils.impl.ProductTimerTask.run(ProductTimerTask.java:41)
atjava.util.TimerThread.mainLoop(UnknownSource)
atjava.util.TimerThread.run(UnknownSource)
数据库表字段和javaBean的映射有差异，如增加了字段，或者字段精度限制发生了变化
Exceptioninthread"Timer-0"java.lang.ClassCastException:com.mchange.v2.c3p0.impl.NewProxyPreparedStatementcannotbecasttojava.sql.CallableStatement
atorg.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:75)
atorg.hibernate.loader.Loader.getResultSet(Loader.java:2066)
atorg.hibernate.loader.Loader.executeQueryStatement(Loader.java:1863)
atorg.hibernate.loader.Loader.executeQueryStatement(Loader.java:1839)
atorg.hibernate.loader.Loader.doQuery(Loader.java:910)
atorg.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:355)
atorg.hibernate.loader.Loader.doList(Loader.java:2554)
atorg.hibernate.loader.Loader.doList(Loader.java:2540)
atorg.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2370)
atorg.hibernate.loader.Loader.list(Loader.java:2365)
atorg.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:497)
atorg.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:387)
atorg.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:236)
atorg.hibernate.internal.SessionImpl.list(SessionImpl.java:1300)
atorg.hibernate.internal.QueryImpl.list(QueryImpl.java:103)
atcn.it.shop.service.impl.CategoryServiceImpl.queryByHot(CategoryServiceImpl.java:47)
atsun.reflect.NativeMethodAccessorImpl.invoke0(NativeMethod)
atsun.reflect.NativeMethodAccessorImpl.invoke(UnknownSource)
atsun.reflect.DelegatingMethodAccessorImpl.invoke(UnknownSource)
atjava.lang.reflect.Method.invoke(UnknownSource)
atorg.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)
atorg.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
atorg.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
atorg.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
atorg.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
atorg.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
atorg.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
atorg.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
atorg.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
atorg.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208)
atcom.sun.proxy.$Proxy29.queryByHot(UnknownSource)
atcn.it.shop.utils.impl.ProductTimerTask.run(ProductTimerTask.java:41)
atjava.util.TimerThread.mainLoop(UnknownSource)
atjava.util.TimerThread.run(UnknownSource)
4 个解决方案
#1
数据库表字段和javaBean的映射有差异，如增加了字段，或者字段精度限制发生了变化
更多相关文章
- MySQL字段名与保留字冲突
- 写SQL语句，如何找到部分字段内容一样的两条记录？实现调货的功能
- Mysql 修改字段类型
- [置顶] sql server中对日期字段值的比较
- Mssql根据表名获取字段
- 注解匹配表字段与实体字段
- Mysql查询时，对于数值型字段加单引号会引起的误解～
- 如何在Android应用里对HTTP请求头部添加适当的User-Agent字段
- Javassist生成class（生成类，方法，字段，注解）