File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes freeze after 20 itrations Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Reply locked New topic

freeze after 20 itrations

tarik el berrak

Joined: Oct 06, 2006
Posts: 29

I have a problem and need some help.

I get a connection, i run an sql request with my satement.
the request takes abount 2 minutes and should return 180 rows. when i iterate over the resultset, the program freeze at the 20th rows without any exception.
when i debug it in my eclipse IDE, at the 20th row the couldn't be read by the debugger

Any idea???

here is my method in my dao class

public List<Record> buildRecords(String request, int idControl,
List<Column> columns) throws SQLException {

logger.log(Level.INFO, "Building records for control : "+idControl+" from request : \n"+request);
long start = System.currentTimeMillis();

List<Record> list = new ArrayList<Record>();
Statement iStmt = null;
ResultSet iResultSet = null;
long elapsed = 0;

try {

iStmt = conn.createStatement();

elapsed = System.currentTimeMillis() - start;

iResultSet = iStmt.executeQuery(request);"Request executed in : "+elapsed+" milliseconds with ");

int i = 0;

while ( {

Record record = new Record(i, idControl);

Column clone = null;

try {

Object idAnomalyStr = iResultSet.getObject(Constant.ID_ANOMALY);
long idAnomaly = Long.parseLong(idAnomalyStr.toString());

for (Iterator<Column> iColumn = columns.iterator(); iColumn.hasNext();) {

Column column =;
clone = column.clone();
Object value = iResultSet.getObject(column.getName());


} catch (SQLException e) {
logger.log(Level.SEVERE, "Couldn't build record cause of column '"
+ clone.getName()+"' for idAnomaly : "+record.getIdAnomaly()+" for control "+idControl, e);




elapsed = System.currentTimeMillis() - elapsed;"Data got from resultSet in : "+elapsed+" milliseconds.");

} finally {


return list;



SCJP 1.5<br />New Target (SCWCD 5)
Campbell Ritchie

Joined: Oct 13, 2005
Posts: 46375
Despite the different user number, please continue all discussion on this thread. Please don't post the same question twice.
Closing topic. Please e-mail one of the sheriffs if you think this topic should be reopened,
I agree. Here's the link:
subject: freeze after 20 itrations
It's not a secret anymore!