I'm trying to build a simple CRUD app that populates an editable table with multiple rows from a query using Hibernate 2.1, MySQL 4.0. I can edit and save existing data but removing or inserting rows doesn't work.

My question: is it supposed to? The docs show examples of containers embedded in objects but not a list returned from a query.

Here's a code snippet:

// list contains table contents
list = hs.find(q);

// change some existing data
list.get(0).username = "John";

// new row successfully added
list.add(newrow);

// serialize to db
hs.flush();

// existing row was updated; new row was NOT inserted
list = hs.find(q);

Any help greatly appreaciated. Thanks.

your code cannot work if you want to insert new instance, call session.save(newrow)

it is in the doc