2007-11-28

DB2 JDBC driver's bug?, Connection is closed

关键字: JDBC
I use code(DB2 JDBC 4 type driver): 
Connection conn = ...;
Statement stat = conn.prepareCall(query);
state.execute();
...
resultSet.getMetaData();


and I get exception like: 
com.ibm.db2.jcc.b.SqlException: [ibm][db2][jcc][10335][10366] Invalid
operation: Connection is closed.
at com.ibm.db2.jcc.b.bb.Nb(bb.java:3356)
at com.ibm.db2.jcc.b.bb.a(bb.java:1589)
at com.ibm.db2.jcc.b.bb.prepareStatement(bb.java:490)


It's very strange that the same code works fine on MySql, Oracle, Sybase etc, at last it works, but I must create Statement like: 
 statement = conn.prepareCall(query,
ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);


So it's a DB2 JDBC driver implementation bug?
评论
发表评论

提醒: 该博客已发表在公共论坛，博客所有留言会成为论坛回贴，留言请注意遵守论坛发贴规则

您还没有登录，请登录后发表评论

alexgreenbar
搜索本博客
最近加入圈子
存档
最新评论