I use PostgreSQL. Sequences (when generated by specifying SERIAL as
the datatype) follow this pattern:

schema.tablename_columnname_seq

I have a NamingConvention to get sequence values. I have a map like
so:

HashMap seqMap = new HashMap();
seqMap.put("public.roles", "roles_roleid_seq");
seqMap.put("public.userroles", "userroles_userroleid_seq");
seqMap.put("public.users", "users_userid_seq");
seqMap.put("public.usertypes", "usertypes_usertypeid_seq");

I can generate this from the database, but I'd prefer to do this by
convention for easier maintenance. I'm wondering if we could have a
getSequenceNameByConvention method. I suppose this would take the
class. I'd fish out the table name and id column name to form the
sequence name.

Thanks.

/Daryl