OracleÖÐBLOB/CLOB×ֶοÉÄÜÓöµ½µÄÎÊÌâ

Blob ²ÉÓõ¥×Ö½Ú´æ´¢£¬Êʺϱ£´æ¶þ½øÖÆÊý¾Ý£¬ÈçͼƬ¡¢ÊÓƵµÈ¡£
Clob ²ÉÓöà×Ö½Ú´æ´¢£¬Êʺϱ£´æ´óÐÍÎı¾Êý¾Ý¡£
1. ÔÚOracle JDBCÖвÉÓÃÁ÷»úÖÆ¶Ô BLOB/CLOB ½øÐжÁд²Ù×÷£¬ËùÒÔҪעÒâ²»ÄÜÔÚÅú´¦ÀíÖжÁд BLOB/CLOB×ֶΣ¬·ñÔò½«³öÏÖ
Stream type cannot be used in batching Òì³£¡£
2. Oracle BLOB/CLOB ×ֶα¾ÉíÓµÓÐÒ»¸öÓα꣨cursor£©£¬JDBCͨ¹ýÓαê¶ÔBlob/Clob×ֶνøÐвÙ×÷£¬ÔÚBlob/Clob×ֶδ´½¨Ö®Ç°£¬ÎÞ·¨»ñÈ¡ÆäÓαê¾ä±ú£¬»á³öÏÖ
Connection reset by peer: socket write error Òì³£¡£
ÕýÈ·µÄ×ö·¨ÊÇ£ºÊ×ÏÈ´´½¨Ò»¸ö¿Õ Blob/Clob ×ֶΣ¬ÔÙ´ÓÕâ¸ö¿Õ Blob/Clob×ֶλñÈ¡Óα꣬ÀýÈçÏÂÃæµÄ´úÂ룺
PreparedStatement ps  =  conn.prepareStatement( " insert into PICTURE(image,resume) values(?,?) " );
//  Í¨¹ýoralce.sql.BLOB/CLOB.empty_lob()¹¹Ôì¿ÕBlob/Clob¶ÔÏó
ps.setBlob( 1 ,oracle.sql.BLOB.empty_lob());
ps.setClob( 2 ,oracle.sql.CLOB.empty_lob());
ps.excuteUpdate();
ps.close();
//  ÔٴζԶÁ³öBlob/Clob¾ä±ú
ps  =  conn.prepareStatement( " select image,resume from PICTURE where id=? for update " );
ps.setInt( 1 , 100 );
ResultSet rs  =  ps.executeQuery();
rs.next();
oracle.sql.BLOB imgBlob  =  (oracle.sql.BLOB)rs.getBlob( 1 );
oracle.sql.CLOB resClob  =  (oracle.sql.CLOB)rs.getClob( 2 );
//  ½«¶þ½øÖÆÊý¾ÝдÈëBlob
FileInputStream inStream  =   new  FileInputStream( " c://image.jpg " );
OutputStream outStream  =  imgBlob.getBinaryOutputStream();
byte [] buf  =   new   byte [ 10240 ];
int  len;
while (len = inStream.read(buf) > 0 ) {
 outStream.write(buf, 0 ,len);
}
inStream.close();
outStream.cloese();
//  ½«×Ö·û´®Ð´ÈëClob
resClob.putString( 1 , " this is a clob " );
//  ÔÙ½«Blob/Clob×ֶθüе½Êý¾Ý¿â
ps  =  conn.prepareStatement( " update PICTURE set image=? and resume=? where id=? " );
ps.setBlob( 1 ,imgBlob);
ps.setClob( 2 ,resClob);
ps.setInt( 3 , 100 );
ps.executeUpdate();
ps.close();
²Î¿¼×ÊÁÏ£º¿ª·¢ÕßÔÚÏßhttp://www.builder.com.cn/files/list-0-0-50259-1-1.