Important Notice - Forums is archived
To simplify things and help our users to be more productive, we have archived the current forum and focus our efforts on helping developers on Stack Overflow. You can post new questions on Stack Overflow or join our Discord channel.

Vaadin lets you build secure, UX-first PWAs entirely in Java.
Free ebook & tutorial.
Table autocmmit is not working right?
Hello,
I am using a TableQuery inside a SQLContainer to a mysql database and using that container inside a Table. The data form the database is showing up fine in the table but when I edit a cell in the table and click out of it, it will not save to mysql. The only way I can get it to save back to the database is by clicking one of the column headers on the table to resort the table. I am running the application via the Eclipse plugin in Tomcat 7. If you need anymore info let me know but I have been banging my head trying to figure out why I am messing this up..
ADMIN_accountEdit is the Table but declared in a different part of the application.
pool = new SimpleJDBCConnectionPool("com.mysql.jdbc.Driver", "jdbc:mysql://localhost:3306/<REMOVED SENSITIVE DATA>");
TableQuery accountTQ = new TableQuery("accounts", pool);
accountTQ.setVersionColumn("OPTLOCK");
SQLContainer accountContainer = new SQLContainer(accountTQ);
accountContainer.setAutoCommit(true);
ADMIN_accountEdit.setEditable(true);
ADMIN_accountEdit.setWriteThrough(true);
ADMIN_accountEdit.setImmediate(true);
ADMIN_accountEdit.setContainerDataSource(accountContainer);
ADMIN_accountEdit.setVisibleColumns(new Object[] {"username","password","teamID","role"});
also somewhat unrelated, is it possible to customize the table to show the teamID as a dropdown mapped to another table in the DB? like if teamID was 1 I would want it to have the teamName from a different table instead of display the 1.... I think maybe I will have to do the freeformquery and reimplement stuff for it? I kind of got confused with what the vaadin book was saying and how to apply it to my situation.
Thanks!