can you execute a query while processing results

[Robert Johnson]

can you execute a query in the while loop of a different resultSet?
e.g.,...

line2= ("Select teamName, played, won, lost, draw, forfor, against, points from leaguetable where tourId = " + tourId);
query4 = stmt.executeQuery(line2);
while (query4.next())
      {
      teamName = query4.getString(1);
      playedTemp = query4.getString(2);
      played = Integer.parseInt(playedTemp);
      wonTemp = query4.getString(3);
      won = Integer.parseInt(wonTemp);
      lostTemp = query4.getString(4);
      lost = Integer.parseInt(lostTemp);
      drawTemp = query4.getString(5);
      draw = Integer.parseInt(drawTemp);
      forforTemp = query4.getString(6);
      forfor = Integer.parseInt(forforTemp);
      againstTemp = query4.getString(7);
      against = Integer.parseInt(againstTemp);
      pointsTemp = query4.getString(8);
      points = Integer.parseInt(pointsTemp);
 
for (int i=0; i<homeTeams.length; i++){
 if(teamName.equals(homeTeams[i])){
 homeTeamScoreInt = Integer.parseInt(homeTeamScore[i]);
 awayTeamScoreInt = Integer.parseInt(awayTeamScore[i]);
    if(homeTeamScoreInt > awayTeamScoreInt){
        played = played + 1;
       won = won + 1;
        forfor = forfor + homeTeamScoreInt;
        against = against + awayTeamScoreInt;
        points =  points + 3;
        line3 = ("Update LEAGUETABLE set played = " + played + ", won = " + won + ", forfor = " + forfor + ", against = " + against +
                 ", points = " + points + " where tourid = " + tourId + " AND teamName = '" + teamName+ "'");
stmt.executeUpdate(line3);
}
}
}
}

it only works once, it stops at the end of the while loop, i.e., it doesnt loop around the resultSet like it should.

[edited to add code tags and change "u" to "you"]
[ March 24, 2005: Message edited by: Jeanne Boyarsky ]

[Jeanne Boyarsky]

Robert,
Executing the update on stmt indirectly closes the select query also using the stmt object. If you use a different Statement object, the problem will go away.

Also, you should consider using a PreparedStatement here. Especially since the update is occuring in a loop.

[Robert Johnson]

ok, thanks i'll try that.

i would have thought it wouldnt need the statment object as i thought it just used it once and then loop around the resultSet only.