I am new to Spring Roo and JPA and this stuff.
The database table I try to generate a model and a (Vaadin) UI for is very simple:
Column: id Type: Integer
Column: text Type: Varchar2(32)
For the column “id” I have created a sequence and a trigger setting “nextVal” before insert into the column ID.
Everything is fine within my database client (DbVisualizer).
The persistence is setup with “eclipselink” as JPA provider, because I have learned, that “eclispelink” is mandatory for Vaadin at the moment. For the same reason I am still using Roo 1.1.5.
In the RooShell (within STS) I do
database reverse engineer --schema MY_SCHEMA --includeTables "MY_TABLE"
My generated UI works fine, displays all the items, I am able to select, edit and update an item, but in case of “insert” (Button “New”) I get an exception:
vaadin generate all --package ~.web.ui --visuallyComposable true
I assume I am doing something basically wrong here. For I found no tutorial and I think this is a basic problem all Oracle Roo projects may have it would be nice to have a tutorial for this….
Error Code: 942
Call: UPDATE SEQUENCE SET SEQ_COUNT = SEQ_COUNT + ? WHERE SEQ_NAME = ?
bind => [2 parameters bound]
Query: DataModifyQuery(name="SEQUENCE" sql="UPDATE SEQUENCE SET SEQ_COUNT = SEQ_COUNT + ? WHERE SEQ_NAME = ?")