java ,操作blob
SELECT t.ID,t.name,t.AGE,t.FILENAME,t.FILECOUNT FROM USERINFO t WHERE t.ID=2
rs.updateBlob(columnName, blob);时错误提示 :“未锁定含有 LOB 值的行”
而加上for update 又提示
ORA-01002: 读取违反顺序
这怎么弄,请高手看看
java.io.File f = new java.io.File(m_filePathName);
java.io.FileInputStream fin = new java.io.FileInputStream(f);
byte[] blobBuf = new byte[(int)fin.available()];
fin.read(blobBuf);
fin.close();
oracle.sql.BLOB blob = (oracle.sql.BLOB)rs.getBlob(columnName);
java.io.OutputStream out = blob.getBinaryOutputStream();
out.write(blobBuf);
out.close();
rs.updateBlob(columnName, blob);
SELECT t.ID,t.name,t.AGE,t.FILENAME,t.FILECOUNT FROM USERINFO t WHERE t.ID=2
rs.updateBlob(columnName, blob);时错误提示 :“未锁定含有 LOB 值的行”
而加上for update 又提示
ORA-01002: 读取违反顺序
这怎么弄,请高手看看
java.io.File f = new java.io.File(m_filePathName);
java.io.FileInputStream fin = new java.io.FileInputStream(f);
byte[] blobBuf = new byte[(int)fin.available()];
fin.read(blobBuf);
fin.close();
oracle.sql.BLOB blob = (oracle.sql.BLOB)rs.getBlob(columnName);
java.io.OutputStream out = blob.getBinaryOutputStream();
out.write(blobBuf);
out.close();
rs.updateBlob(columnName, blob);
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货