为什么我不能从本机Java Blob强制转换Oracle BLOB [英] Why I cannot cast oracle BLOB from native java 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

这篇关于为什么我不能从本机Java Blob强制转换Oracle BLOB的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！