Uneditable columns in Grid using SQLContainer and FreeformQuery (bug?)

Vaadin 6 / 7 / 8 Framework Data Binding
1

I’m having a problem with an editable Grid that is using SQLContainer with a FreeformQuery and FreeformStatementDelegate. Adding and updating rows works as expected, except that only the first column is editable.

My quey is similar to this: SELECT foo.id, foo.name, bar.something FROM foo LEFT JOIN bar ON foo.id = bar.id In terms of this example, I would expect foo.name and bar.something to be editable, but only foo.name is editable. I’ve tried setting Grid columns editable, but that doesn’t help.

Vaadin version is 7.7.6 and database is MySql

2

Solved.
Apparently SQLContainer determines column editability from jdbc resultset metadata, which reports groupped columns as uneditable. They are of course uneditable as such, but in my particular case those values needed to be editable.