hibernate
新增没有问题 查询报错,
数据库存储为blob类型
实体类:IdCardInfo字段为:private byte[] PHOTOS;//照片
dao:
Session session = null;
List listIdCardInfo = null;
Transaction tx = session.beginTransaction();
SQLQuery query = session.createSQLQuery(sql);
query.setResultTransformer(Transformers.aliasToBean(IdCardInfo.class));
System.out.print( "*****"+query);
listIdCardInfo = query.list();
tx.commit();
return listIdCardInfo;
在listIdCardInfo = query.list();报错
报错信息:
2708850 [SpringJobSchedulerFactoryBean_Worker-10] DEBUG com.mchange.v2.c3p0.impl.NewPooledConnection - com.mchange.v2.c3p0.impl.NewPooledConnection@ca5f99b handling a throwable.
com.ibm.db2.jcc.b.SqlException: BigDecimal conversion exception [ibm][db2][jcc][converters] Overflow occurred during numeric data type conversion of "269647".. See attached Throwable.
at com.ibm.db2.jcc.c.mb.a(mb.java:1827)
at com.ibm.db2.jcc.c.pb.a(pb.java:1098)
at com.ibm.db2.jcc.c.pb.a(pb.java:812)
at com.ibm.db2.jcc.c.pb.a(pb.java:163)
at com.ibm.db2.jcc.c.dc.a(dc.java:266)
at com.ibm.db2.jcc.b.tf.a(tf.java:1682)
at com.ibm.db2.jcc.b.tf.d(tf.java:2103)
at com.ibm.db2.jcc.b.tf.Y(tf.java:540)
at com.ibm.db2.jcc.b.tf.executeUpdate(tf.java:523)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:133)
at org.hibernate.engine.query.spi.NativeSQLQueryPlan.performExecuteUpdate(NativeSQLQueryPlan.java:204)
at org.hibernate.internal.SessionImpl.executeNativeUpdate(SessionImpl.java:1313)
at org.hibernate.internal.SQLQueryImpl.executeUpdate(SQLQueryImpl.java:401)
at cn.com.boomhope.face.dao.hibernate.impl.HbFaceWsLogDao.saveFaceWsLog(HbFaceWsLogDao.java:201)
at cn.com.boomhope.face.dao.hibernate.impl.HbFaceWsLogDao.batchAdd(HbFaceWsLogDao.java:44)
at cn.com.boomhope.face.service.impl.HbLogServiceImpl.batchAddFaceWsLog(HbLogServiceImpl.java:139)
at sun.reflect.GeneratedMethodAccessor21.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.util.MethodInvoker.invoke(MethodInvoker.java:273)
at org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean$MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactoryBean.java:311)
at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:113)
at org.quartz.core.JobRunShell.run(JobRunShell.java:223)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549)
查询数据类型为blob类型 报错
- 写回答
- 好问题 0 提建议
- 追加酬金
- 关注问题
- 邀请回答
-
2条回答 默认 最新
- COCO_AS 2017-11-21 13:22关注
如果我没有看错的话, 下面报错的堆栈与你上面给出的代码没有关系.
下面的quartz定时任务报错: at cn.com.boomhope.face.dao.hibernate.impl.HbFaceWsLogDao.saveFaceWsLog(HbFaceWsLogDao.java:201)
解决 无用评论 打赏 举报
悬赏问题
- ¥20 删除和修改功能无法调用
- ¥15 kafka topic 所有分副本数修改
- ¥15 小程序中fit格式等运动数据文件怎样实现可视化?(包含心率信息))
- ¥15 如何利用mmdetection3d中的get_flops.py文件计算fcos3d方法的flops?
- ¥40 串口调试助手打开串口后,keil5的代码就停止了
- ¥15 电脑最近经常蓝屏,求大家看看哪的问题
- ¥60 高价有偿求java辅导。工程量较大,价格你定,联系确定辅导后将采纳你的答案。希望能给出完整详细代码,并能解释回答我关于代码的疑问疑问,代码要求如下,联系我会发文档
- ¥50 C++五子棋AI程序编写
- ¥30 求安卓设备利用一个typeC接口,同时实现向pc一边投屏一边上传数据的解决方案。
- ¥15 SQL Server analysis services 服务安装失败