When using identity as an id generation strategy, I figured out (looked in the code :)) that to retrieve the id the fixed sql string "select identity_val_local() from sysibm.sysdummy1" is used. However we generally use the "system" naming strategy instead of the "sql" naming strategy. We specify no libraries in the mapping files and specify a library list. The approach gives now problems, a slash is expected as separator instead of a dot.
How do you as400 users solve this problem? Is everyone using "sql" naming? We use "system" as "sql" gives a whole different meaning to library lists.
Of course it is possible to switch from approach or to change the hibernate DB2400Dialect code, but I'm wondering how others tackle this.

Bart.