Hi, I'm in the middle of a 2.4 -> 2.5 upgrade and I've found that my generated table record appears to be non-updatable):
java.lang.IllegalStateException: The ON DUPLICATE KEY IGNORE/UPDATE clause cannot be simulated when inserting into non-updatable tables : PUBLIC.ENDPOINTS at org.jooq.impl.InsertQueryImpl.toMerge(InsertQueryImpl.java:416) at org.jooq.impl.InsertQueryImpl.toSQL(InsertQueryImpl.java:188) at org.jooq.impl.DefaultRenderContext.sql(DefaultRenderContext.java:311) at org.jooq.impl.DefaultRenderContext.render(DefaultRenderContext.java:120) at org.jooq.impl.Factory.render(Factory.java:681) at org.jooq.impl.AbstractQueryPart.getSQL(AbstractQueryPart.java:117) at org.jooq.impl.AbstractQueryPart.getSQL(AbstractQueryPart.java:99) at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:158) at org.jooq.impl.InsertImpl.execute(InsertImpl.java:95) Is there some property of the source database that JOOQ reads when generating table records that indicates whether a table is not updatable (I'm using HSQLDB to do the codegen)? Cheers, Ben
