DBRE on Oracle table

[ahs94]

Hi all!

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"

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

[ahs94]

Hi.

I really need your help! Please help me.

Thank you.

Regards,
Philipp

[jbbarquero]

You have provided little information in order to help you.

Roo creates the identifier for a table with a strategy of auto-generate values:

    @Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    @Column(name = "id")
    private Long MyTable.id;

I don't know Oracle, but I assume that it will use a global table (I presume it is called SEQUENCE) for the entire database with a row for each table (for instance, your MY_TABLE) storing the next sequence value (or the last used to provide the next, who cares)

Maybe your error is related with that:

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

Find what does mean "Error Code: 942" and try to fix it.

You have an alternative with Roo: move the id field with its get and set methods to the Java class, and use another strategy for generating values. You can even obviate the annotation, thus the ids should be provided manually.