SQLContainer + TableQuery + Oracle

Flow
1

Hi!

I have a problem with the Vaadin Address Book demo application using SQLContainer and TableQuery.

I am trying to create a City CRUD but i am having some problems…

Adding new items and deleting works ok but when i want to update an existing record from the table i get:

ORA-00001: unique constraint violated…

I dont know whats wrong and i cant see which sql statemets is vaadin executing because the setDebug(true) doesnt work.

Can someone help me?

thanks

2

Hi,

I had the same error today. It went away after I set a version column on the table.

	TableQuery tableQuery = new TableQuery("mc_roles", pool, new OracleGenerator());
	tableQuery.setVersionColumn("ID");

-Kai