Resultset Closed (Mysql)

[super_günther]

Hallo,
ich bekomme diesen Fehler : java.sql.SQLException: Operation not allowed after ResultSet closed
wenn ich in der Datenbank einen neuen Publicroom hinzufüge.

hier der code wodurch die Publicrooms gecached werden:

public Publicroom[] get_pubrooms() {
	   Publicroom[] tmp = null;
	   ResultSet res;
	   try {

                ResultSet res2 = statement.executeQuery("SELECT COUNT(*) FROM `pubrooms`");
		res2.next();
                int len = res2.getInt(1);
                tmp = new Publicroom[len];
                res = statement.executeQuery("SELECT * FROM `pubrooms`");

		for (int k = 0; k < len; k++) {
			res.next();
			tmp[k] = new Publicroom(res.getInt("id"), res.getString("name"),res.getString("heightmap"),25, get_pub_furnis(res.getInt("id")));
			tmp[k].x = tmp[k].map.split("\r")[0].length();
			tmp[k].y = tmp[k].map.split("\r").length;
                        tmp[k].cache_furnis();
		}
	} catch (Exception e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}
	   return tmp;
   }

Gruß Günther

 

[kirax]

Hi

in welcher Zeile kommt der Fehler?

 

[super_günther]

bei res.next();

 

[XHelp]

Sofern ich es richtig in Erinnerung habe wird biem Ausführen von

executeQuery

der bestehende ResultSet geschlossen.
[EDIT]
Jepp, so ist es: Statement (Java Platform SE 6)

By default, only one ResultSet object per Statement object can be open at the same time. Therefore, if the reading of one ResultSet object is interleaved with the reading of another, each must have been generated by different Statement objects. All execution methods in the Statement interface implicitly close a statment's current ResultSet object if an open one exists.

[/EDIT]

 

[super_günther]

und wie kann ich den Fehler beheben?

 

[XHelp]

Therefore, if the reading of one ResultSet object is interleaved with the reading of another, each must have been generated by different Statement objects.

In dem du genau das tust: für 2 ResultSets auch 2 Statement nehmen.