I' m sending query to DB2 7.2 (installed on Win 2000) using JDBC driver
COM.ibm.db2.jdbc.net.DB2Driver like this:
String query = "SELECT dercert from vacert "
+ "WHERE vrijediod=(select max(vrijediod) from vacert where
vrijediod<?)";
java.sql.Timestamp timeStamp = new
java.sql.Timestamp(System.currentTimeMillis());
Connection cc = DriverManager.getConnection(url, user, psw);
PreparedStatement statement = connection.prepareStatement(sql);
fillStatement(statement, params);
ResultSet resultSet = statement.executeQuery();
if (!resultSet.next()) {
return null;
}
And I get SQL exception on resultSet.next().
SQL exception is:
COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL0501N The
cursor specified in a FETCH or CLOSE statement is not open.
SQLSTATE=24501
What is the problem?
Driver url, username and password are OK.
Alan