QueryContainer doesn't allow closing without losing container data.

[Mauno Haukila]

Created QueryContainer? for database table that has two rows (SELECT * FROM table). If I set that QueryContainer? to Table's containerDataSource it shows all headers ok but it shows those two rows with empty values (see attached picture).

[Mauno Haukila]

Changed this bug description and and topic. Problem isn't in table, it is in QueryContainer?. QueryContainer? doesn't contain any values if it's closed. This is unwanted behavior because without closing queries cursors to database are left open.

[Jani Laakso]

Copy QueryContainer? items to new container called IndexedContainer, close QueryContainer? and use IndexedContainer instead. Here's an example:

try {
			QueryContainer qc = new QueryContainer("SELECT * FROM employee",
					sampleDatabase.getConnection());
			IndexedContainer ic = new IndexedContainer(qc.getItemIds());
			qc.close();
			table.setContainerDataSource(ic);
		} catch (SQLException e) {
			e.printStackTrace();
		}

[Jani Laakso]

Note from Mauno, you need to copy items and properties aswell, above example copies only ids. Re-opening this ticket.

[Jani Laakso]

Suggest you add helper method directly to QueryContainer? which copies QueryContainer? resultset into IndexedContainer using 3 for loops.

[Jani Laakso]

Lots of methods should throw "not implemented", QC needs major rework. For example, when you read data from database table, you may then edit Container (POJO) items but this is not wise move because there is no way to commit POJO Container changes back to database. At this point user notices that I got to do all this manually..

Perhaps we should consider moving QueryContainer? more like SQLContainer (invented in Testing Tools), it's a lot simpler "read only from SQL table" Container. All item additions / updates are done always directly to SQL table and then SQLContainer simply refreshes itself.

[Joonas Lehtinen]

Milestone Sprint 4 backlog deleted

[Joonas Lehtinen]

Milestone User Interface Library 5.1.2 deleted