Thomas Dudziak wrote:
And there certainly is room for improvement
in DdlUtils. E.g. it would be useful to have the ability to specify
sequences in an database-independent way.
By this do you mean abstracting the issue of ID generation? e.g .
if oracle -> use a sequcnce
if hsql -> use integer IDENTITY column
if mysql -> use integer autoincrement
....
If so, then I would soundly endorse this.
Creating this in a db independent manner shoudl be reasonably straight
fowrard.
Reading it from an exising db would be trickier - in oracle I don't
think the sequence is not specifically associated to the table it is
being used by, so DDLUtils would need some hints?
Tim