alexgreenbar 发表于 2013-1-25 22:41:05

DB2 JDBC driver's bug?, Connection is closed

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: Invalidoperation: 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?
页: [1]
查看完整版本: DB2 JDBC driver's bug?, Connection is closed