(Oracle中写入BLOB.docVIP

通过java往oracle中blob字段写入数据 (2007-10-19 15:53:06) 这两天忙着修改浙大的学院服务系统中关于照片的上传与读取（直接从数据库里），以前都是直接文件读取出来。 ZP：blob 在写入的过程中，出现如下错误： java.sql.SQLException: ORA-01460: unimplemented or unreasonable conversion requested ? 往oracle里面类型为blob写入时，必须先插入一个empty_blob，实行update…… 具体java里面写入blob的代码如下：public class applyPhotoBLOB { ?final static String sDBDriver = oracle.jdbc.driver.OracleDriver; ?public static void main(String[] args) {???Connection connSDC = null;? ?Connection conn = null;??String sConnStr = jdbc:oracle:thin:@:1521:sledu;??String sConnStrSDC = jdbc:oracle:thin:@2:1521:rac2;??String sDBUid = test;??String sDBPwd = test;??String sDBUidSDC = sdcmanager;??String sDBPwdSdc = sdcmanager_888;????try??{???applyPhotoBLOB apply = new applyPhotoBLOB(); ??connSDC = apply.getConn(sConnStrSDC,sDBUidSDC,sDBPwdSdc);???if(connSDC!=null)???{????apply.testBOLB(connSDC);???}???System.out.println(处理完成！);??}??catch(Exception e){???System.out.println(e.getMessage());??}??finally???? {???? try???? {????? if(conn!=null) conn.close();????? if(connSDC!=null) connSDC.close();???? }???? catch(Exception e)???? {????? System.out.println(e.getMessage());???? }???? }?} ? ?public void testBOLB(Connection conn) throws Exception?{??String strSQL = Insert Into BKS_XSZPXX(XH,ZPLXM,ZP) Values(3071801040,1,empty_blob());??updateTable1(strSQL,conn);??conn.setAutoCommit(false);??strSQL = Select ZP from BKS_XSZPXX where XH=3071801040 For Update;????Statement stmt = null;??ResultSet rs = null;????stmt = conn.createStatement();??rs = stmt.executeQuery(strSQL); ??rs.next();??BLOB blob = (BLOB) rs.getBlob(ZP);??OutputStream os = blob.getBinaryOutputStream();// 建立输出流??BufferedOutputStream output = new BufferedOutputStream(os);??BufferedInputStream input = new BufferedInputStream(new File(F:/3071801040.jpg).toURL().openStream());??byte[] buff = new byte[2048000];? //用做文件写入的缓冲??int bytesRead;??while(-1 != (bytesRead = input.read(buff, 0, buff.length)))??{???? output.w