为什么我不能从本机Java Blob强制转换Oracle BLOB

本文介绍了为什么我不能从本机Java Blob强制转换Oracle BLOB的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我正在从ResultSet中读取文件，并且需要将文件保存到Oracle数据库中.

I am reading file from ResultSet and it's required to save file into Oracle Database.

... ResultSet rs = ... java.sql.Blob myfile = rs.getBlob("field") java.io.OutputStream os = ((oracle.sql.BLOB) myfile).getBinaryOutputStream();

我收到此错误消息

java.lang.ClassCastException

有人对此有解决方案吗?谢谢！

Any one have solution to this? Thanks!

推荐答案

我找到了解决方案.我想和有这个问题的人分享.

I have found the solution. I'd like to share with those who has this problem.

从oracle blob获取输出流的代码是:

The code to get outputstream from oracle blob is:

java.io.OutputStream os = ((oracle.sql.BLOB) myBlob).setBinaryStream(1L);

setBinaryStream()实际上返回java.io.OutputStream对象

setBinaryStream() is actually returning java.io.OutputStream object