Integration

Hi all!

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" ]
and

[ vaadin generate all --package ~.web.ui --visuallyComposable true ]

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:

[ 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 = ?") ]

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….

Regards,
Philipp