Re: large tables, large keycaches

[Roland Bouman]

Does it not take advantage of the generic java interface?

I mean,

import java.sql.*;

Connection conn;
//init conn
...
PreparedStatement pstmt = conn.prepareStatement("SELECT * FROM somtable WHERE someStringColumn = ?");
pstmt.setString(1,"myValue");
ResultSet rst = pstmt.executeQuery();
//traverse the resultset:
while (rst.next()){
//do stuff with this current row
}