setBinaryStream为什么总报错?

Question

错误信息:
java.sql.SQLException: [IBM][CLI Driver] CLI0102E  郒刲b SQLSTATE=07006
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6031)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:6188)
at sun.jdbc.odbc.JdbcOdbc.SQLBindInParameterAtExec(JdbcOdbc.java:660)
at sun.jdbc.odbc.JdbcOdbcPreparedStatement.setStream(JdbcOdbcPreparedStatement.java:2727)
at sun.jdbc.odbc.JdbcOdbcPreparedStatement.setBinaryStream(JdbcOdbcPreparedStatement.java:983)
at _test._testblob__jsp._jspService(/test/testblob.jsp:59)
at com.caucho.jsp.JavaPage.service(JavaPage.java:87)
at com.caucho.jsp.JavaPage.subservice(JavaPage.java:81)
at com.caucho.jsp.Page.service(Page.java:474)
at com.caucho.server.http.FilterChainPage.doFilter(FilterChainPage.java:166)
at com.caucho.server.http.Invocation.service(Invocation.java:277)
at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:129)
at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:216)
at com.caucho.server.http.HttpRequest.handleConnection(HttpRequest.java:158)
at com.caucho.server.TcpConnection.run(TcpConnection.java:140)
at java.lang.Thread.run(Thread.java:484)

Answer 1

是不是你连接数据库有问题？？
还有就是
int fileLength = (int)imageFile.length();这块好象是long fileLength  = (long)imageFile.length();这样吧
我印象里应该是这样

Answer 2

stmt = conn.prepareStatement("INSERT INTO NULLID.TEST_DB VALUES(?,?,?)");
File imageFile = new File("F:\\temp\\ff.gif");
int fileLength = (int)imageFile.length();
stmt.setInt(1,3);
stmt.setInt(2,3);
InputStream inputStream = new FileInputStream(imageFile);
stmt.setBinaryStream(3,inputStream,fileLength);
试一下