Hi
I was wondering if it is possible to get JOOQ to support insertable views?
We're going to have to use insertable/updatable views to be able to do more
running upgrades of our application, so for most tables we will be
following the pattern of having a Java entity "Foo", a table "foo_tab" and
a view called "foo".
Our database is Oracle, but several other databases (even open source ones)
support insertable/updatable views and it would be nice if JOOQ could make
the Records extends UpdatableRecordImpl instead of just TableRecordImpl. In
other words, I would like this to still work:
PersonRecord r = new PersonRecord();
r.setId(id);
r.setName(person.name);
dsl.attach(r);
r.insert();
instead of having to do this:
PersonRecord r = dsl.insertInto(PERSON).
set(PERSON.ID, id).
set(PERSON.NAME, person.name).
returning().
fetchOne();
--
Trygve
--
You received this message because you are subscribed to the Google Groups "jOOQ
User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
