b cannot be cast to com.mysql.jdbc.blob_有遇到这种错误的吗，使用hibernate框架向mysql存入blob类型的值时报这种错，求解决。...

最新推荐文章于 2023-02-28 09:59:00 发布
最新推荐文章于 2023-02-28 09:59:00 发布
阅读量435 收藏
点赞数
文章标签： b cannot be cast to com.mysql.jdbc.blob
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_42501881/article/details/113375858
版权

org.hibernate.exception.SQLGrammarException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'blob) values ('zhangsan', 'man', 22, 'china', '2017-06-10', _binary'ÿû�d\0\0\' at line 1

at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:122)

at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)

at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)

at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)

at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:129)

at org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81)

at com.sun.proxy.$Proxy7.executeUpdate(Unknown Source)

at org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:96)

at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:58)

at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2767)

at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3278)

at org.hibernate.action.internal.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:81)

at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:362)

at org.hibernate.engine.spi.ActionQueue.addResolvedEntityInsertAction(ActionQueue.java:203)

at org.hibernate.engine.spi.ActionQueue.addInsertAction(ActionQueue.java:183)

at org.hibernate.engine.spi.ActionQueue.addAction(ActionQueue.java:167)

at org.hibernate.event.internal.AbstractSaveEventListener.addInsertAction(AbstractSaveEventListener.java:320)

at org.hibernate.event.internal.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:287)

at org.hibernate.event.internal.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:193)

at org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:126)

at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:204)

at org.hibernate.event.internal.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:55)

at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:189)

at org.hibernate.event.internal.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:49)

at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:90)

at org.hibernate.internal.SessionImpl.fireSave(SessionImpl.java:757)

at org.hibernate.internal.SessionImpl.save(SessionImpl.java:749)

at org.hibernate.internal.SessionImpl.save(SessionImpl.java:745)

at test.jutest.testblod(jutest.java:63)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:606)

at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:44)

at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15)

at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:41)

at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:20)

at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:28)

at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:31)

at org.junit.runners.BlockJUnit4ClassRunner.runNotIgnored(BlockJUnit4ClassRunner.java:79)

at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:71)

at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:49)

at org.junit.runners.ParentRunner$3.run(ParentRunner.java:193)

at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:52)

at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:191)

at org.junit.runners.ParentRunner.access$000(ParentRunner.java:42)

at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:184)

at org.junit.runners.ParentRunner.run(ParentRunner.java:236)

at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:50)

at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)

at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467)

at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683)

at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390)

at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197)

Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'blob) values ('zhangsan', 'man', 22, 'china', '2017-06-10', _binary'ÿû�d\0\0\' at line 1

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2941)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1623)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1715)

at com.mysql.jdbc.Connection.execSQL(Connection.java:3249)

at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1268)

at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1541)

at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1455)

at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1440)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:606)

at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:122)

... 49 more

org.hibernate.AssertionFailure: null id in test.students entry (don't flush the Session after an exception occurs)

at org.hibernate.event.internal.DefaultFlushEntityEventListener.checkId(DefaultFlushEntityEventListener.java:79)

at org.hibernate.event.internal.DefaultFlushEntityEventListener.getValues(DefaultFlushEntityEventListener.java:194)

at org.hibernate.event.internal.DefaultFlushEntityEventListener.onFlushEntity(DefaultFlushEntityEventListener.java:156)

at org.hibernate.event.internal.AbstractFlushingEventListener.flushEntities(AbstractFlushingEventListener.java:225)

at org.hibernate.event.internal.AbstractFlushingEventListener.flushEverythingToExecutions(AbstractFlushingEventListener.java:99)

at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51)

at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1214)

at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:403)

at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.beforeTransactionCommit(JdbcTransaction.java:101)

at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.commit(AbstractTransactionImpl.java:175)

at test.jutest.destory(jutest.java:68)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:606)

at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:44)

at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15)

at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:41)

at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:37)

at org.junit.runners.BlockJUnit4ClassRunner.runNotIgnored(BlockJUnit4ClassRunner.java:79)

at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:71)

at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:49)

at org.junit.runners.ParentRunner$3.run(ParentRunner.java:193)

at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:52)

at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:191)

at org.junit.runners.ParentRunner.access$000(ParentRunner.java:42)

at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:184)

at org.junit.runners.ParentRunner.run(ParentRunner.java:236)

at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:50)

at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)

at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467)

at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683)

at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390)

at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197)

缪华武
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
解决can‘t cast to oralce.sql.BLOB架包
10-30
rt，出现这种情况，可以更换下hibernate核心包 即可解决
weblogic.jdbc.wrapper.Clob_oracle_sql_CLOB 类型转换解决办法
05-10
weblogic下转换oracle 的clob类型经常报转型错误，本例子通过反射解决weblogic.jdbc.wrapper.Clob_oracle_sql_CLOB转型成oracle.sql.CLOB问题
b cannot be cast to com.mysql.jdbc.blob_jbpm4.4 部署流程时出现 $Proxy8 cannot be cast to oracle.sql.BLOB...
weixin_28874917的博客
01-21 242
我原来使用的是mysql部署很正常，把数据库换成oracle 部署时就出现了错误,搞了半天还是不行Hibernate: insert into jbpm4.JBPM4_LOB (DBVERSION_, BLOB_VALUE_, DBID_) values (?, ?, ?)java.lang.ClassCastException: $Proxy8 cannot be cast to oracle....
b cannot be cast to com.mysql.jdbc.blob_mysql导入LongBLOB字段，提示: java.lang.ClassCastException...
weixin_33914679的博客
01-26 328
pid:1 nid:1 exception:setl:com.alibaba.otter.node.etl.load.exception.LoadException: java.util.concurrent.ExecutionException: com.alibaba.otter.node.etl.load.exception.LoadException: com.alibaba.otter....
B cannot be cast to java.sql.Blob
farxix的博客
05-06 5106
问题描述：BLOB类型的数据从数据库提取出来，提示不能强制转换为BLOG 解决方案：转换为二进制数组 byte[] object = (byte[]) Map.get("blob");
oracle中图片查询转换成Blob/cannot be cast to java.sql.blob
qq_41028696的博客
08-11 821
oracle中图片查询转换成Blob String sql = " select img1 from tbl_image where wzid='" + tblXywz.getWid() + "' and img1 is not null "; List list = entityManager.createNativeQuery(sql).getResultList(); //主要解决（cannot be cast to java.sql.blob）异常 SerializableBlobProxy p
QT-Mysql-Blob.zip_mysql blob_qt blob 文件_qt blob类型_qt的blob
09-19
mysql+Qt 下对blob数据类型操作
jsp1.rar_jsp blob_jsp 图片_mysql blob_图片 MySQL
09-14
jsp页面从mysql读取图片(BLOB)
工业文字识别（遥控器）.rar_OCR HALCON_blob分析_halcon遥控器_remote screen_屏幕 文字识
07-14
halcon遥控器屏幕文字识别，工业文字识别，OCR识别，BLOB分析
java.lang.ClassCastException: oracle.sql.BLOB cannot be cast to oracle.sql.BLOB解决方案
01-01 5709
前些时候再做照片批量上传数据库用的是oracle，在得到java.sql.Blob对象后强制转换为oracle.sql.BLOB是报这个错误很奇怪。折腾了半天最后发现是ojdbc14.jar惹的祸。我在项目的lib和tomcat6.0下的lib放了这个jar包，运行不行；仅在项目下面加上不行；非要在tomcat6的lib下放上这个jar包然后再项目中引进来就没错误了。想了想没明白为啥？！
java属于什么类型,什么类型的Java类型是“[B”？
weixin_36261424的博客
02-18 714
I am trying to get MD5 encrypted pass from MySQL DB via Java code (Hibernate). But I cant get neither String nor any reasonable Java type.The only thing I am getting is this unhelpful message:java.lan...
JDBC访问KingbaseES数据库异常 -- 案例分析
lyu1026的博客
02-28 1921
应用使用jdbc访问KingbaseES数据库发生异常：SocketTimeoutException Read timed out 一、异常现象： 应用显示ERROR信息： Caused By: java.net.SocketTimeoutException: Read timed out at java.base/java.net.SocketInputStream.so...
com.mysql.cj.jdbc.ConnectionImpl cannot be cast to com.mysql.jdbc.Connection
weixin_44772948的博客
04-06 1万+
在进行eclipse下进行jdbc操作时出现以下错误： com.mysql.cj.jdbc.ConnectionImpl cannot be cast to com.mysql.jdbc.Connection 分析问题主要是导包错误。 需要把原来的包：import com.mysql.jdbc.Connection; 改成import java.sql.Connection;即可。 ...
解决： Caused by: java.lang.IllegalStateException: Cannot load driver class: dm.jdbc.driver.DmDriver
weixin_71921932的博客
11-07 3000
-如果驱动包报错，可以添加本地驱动，手动引入第三方jar包-->-- 添加dm8 jdbc jar 包依赖。原因分析：达梦的驱动包找不到。
oracle数据库中blob照片存放到本地
梦幻通灵
11-30 1297
最近有个需求是将oracle数据库中存放的blob类型的二进制流照片，下载到本地，下面记录这个过程，以备之后的查看。 File folderFile = new File(picturePathFolder); JSONObject resJson = new JSONObject(); if (!folderFile.exists()) { folderFile.mkdir(); ...
hibernate 3.5+ 后的BLOB操作cannot be cast to oracle.sql.BLOB
热门推荐
running_snail_的专栏
03-18 1万+
如果你以前在创建blob类型的实体时，你一定会像这样 private Blob image; 其中Blob是java.sql.Blob 在操作Blob对象的时候会用到SerializableBlob这个类 但是当你的hibernate3.5后org.hibernate.lob.SerializableBlob这个类会被取消掉，取而代之的是org.hibernate.jdbc.ResultS
java.lang.ClassCastException: oracle.sql.BLOB cannot be cast to oracle.sql.BLOB
qin_zhimou的专栏
10-14 6494
oracle.sql.BLOB blob = (oracle.sql.BLOB) rs.getClob("BLOB ");在java中使用的时候出现如标题所示的错误。 解决办法是用以下代码替换：OutputStream out = rs.getBlob(1).setBinaryStream(1L);
oracle.sql.CLOB cannot be cast to oracle.sql.BLOB
最新发布
04-24
这种错误通常发生在使用JDBC连接Oracle数据库时读写数据库的时候，出现类型转换问题。可能是因为你在读写数据库时使用的是错误的数据类型，或者是因为数据类型不匹配所导致的。建议您检查您的代码中的数据类型是否正确，并且在进行数据库操作时要注意使用正确的数据类型。如果您需要更详细的帮助，可以在Stack Overflow等技术社区上寻求帮助。

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值