SQLContainer and a join table

Vaadin 6 / 7 / 8 Framework Data Binding
1

I have an existing database with 3 tables. Table 1 contains users and has an ‘id’ column. Table 2 contains roles, and also has an id column. The third table is a join table - it just contains [ userId, roleId ]
pairs. I was able to use a FreeFormQuery to read the entries in the join table, but I’m having trouble figuring out how to add or remove an entry from the table. I know what the SQL statement should look like, but can someone show me how to set up and execute the insert or delete statement? I’m assuming this is simple, but since there is no separate id field, it doesn’t look like I can use the regular addItem() calls…

Thanks,

nbc

2

I’m not sure if this is the best solution, but I have managed to create a FreeformQuery and a FreeformStatementDelegate which has allowed me to access the join table correctly - I was able to add records to the system…

nbc