While I have only worked with DB2 on other platforms and thus not with DB2/390 v8, when I look at the ` {{ DB2390V8Dialect#getCreateSequenceString(String) ` }} implementation (see [ https://github.com/hibernate/hibernate-orm/blame/master/hibernate-core/src/main/java/org/hibernate/dialect/DB2390V8Dialect.java#L26-L28) |https://github.com/hibernate/hibernate-orm/blame/master/hibernate-core/src/main/java/org/hibernate/dialect/DB2390V8Dialect.java#L26-L28)] it strikes me as odd to have the ` {{ NOCACHE ` }} option in there. Typically the default would be ` {{ CACHE 20 ` }} (which is what happens when the ` {{ CACHE ` }} clause is left out). Also a few of the other clauses could probably be left out, since they correspond to the default value and this is also how Hibernate works in the case of most other supported dialects.
` {{ NOCACHE ` }} is of course also bad for performance and I think it would for this reason also make sense to just leave out the ` {{ CACHE ` }} clause here. |
|
