list1234 发表于 2016-11-15 05:38:30

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