blob字段的长度限制是:?????
我用JAVA-JDBC-ORACLE向blob字段插入文件,小的文件可以,如1,2k,但是一个35k的文件怎么也插不进去。为是么?请帮忙,谢谢!
代码如下:
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn= DriverManager.getConnection("jdbc:oracle:thin:@sunxiaoming:1521:sxm", "sunxiaoming", "sunxiaoming");
conn.setAutoCommit(false);
Statement stmt=conn.createStatement();
File file=new File("jbWheel.zip");
InputStream is=new FileInputStream(file);
System.out.print(file.length());
PreparedStatement pstmt=conn.prepareStatement("insert into test values (?,?)");
pstmt.setInt(1,1234);
pstmt.setBinaryStream(2,is,(int)file.length());
pstmt.executeUpdate();
pstmt.close();
stmt.close();
conn.close();