java怎么关闭oracle游标,java – 关闭结果集后,Oracle不会删除游标

注意：我们重用单连接.

************************************************

public Connection connection() {

try {

if ((connection == null) || (connection.isClosed()))

{

if (connection!=null)

log.severe("Connection was closed !");

connection = DriverManager.getConnection(jdbcURL, username, password);

}

} catch (SQLException e) {

log.severe("can't connect: " + e.getMessage());

}

return connection;

}

**************************************************

public IngisObject[] select(String query, String idColumnName, String[] columns) {

Connection con = connection();

Vector objects = new Vector();

try {

Statement stmt = con.createStatement();

String sql = query;

ResultSet rs =stmt.executeQuery(sql);//oracle increases cursors count here

while(rs.next()) {

IngisObject o = new IngisObject("New Result");

o.setIdColumnName(idColumnName);

o.setDatabase(this);

for(String column: columns)

o.attrs().put(column, rs.getObject(column));

objects.add(o);

}

rs.close();// oracle don't decrease cursor count here, while it's expected

stmt.close();

}

catch (SQLException ex) {

System.out.println(query);

ex.printStackTrace();

}