PreparedStatement.setNull()的bug??

Posted on 2007-10-09 19:39 bluoy 阅读(905) 评论(0)  编辑  收藏
The follow statement execute error using 9i driver(Oracle JDBC Driver version - 9.0.2.0.0).
throw UncategorizedSQLException(Invalid Column Type Exception), 
errorcode: 17004.
Upgrade to Oracle JDBC Driver version - 10.2.0.1.0, it is OK.

Example:

......
PreparedStatement pst = cn.prepareStatement("select sysdate from dual where 1=?");
pst.setNull(index,  java.sql.Types.NULL);   -------- throw exception!!
......





只有注册用户登录后才能发表评论。


网站导航: