[daisy] Porting to DB2

[Bruno Dumon]

On Tue, 2006-09-12 at 17:22 +0200, Aaron.Digulla at Globus.ch wrote:
> Hello,
> 
> I'm currently trying to port Daisy 1.5 to DB2 (IBM).
> 
> I've had some success with the Torque/Velocity templated but I've run into 
> an issue: On DB2, names of constraints are limited to 18 characters.
> 
> What's the best way to fix this? Is it possible to shorten all names in 
> the table model of daisy? Or would that create a ripple of other changes?
> 
> Or can I create "aliases" for the constraints? (normal table names can be 
> 128 chars, so they are not a problem).

The constraint names are automatically assigned by torque/velocity, and
Daisy doesn't use these names, thus they can be anything. So if possible
I suggest you modify the velocity templates to generate short names
(e.g. simply a prefix + counter).

> 
> Also, DB2 complains that "email_queue.id" is not defined as NOT NULL. Can 
> this be fixed?

yep, it is fixed now.

> 
> And lastly: Did anyone already manage to port Daisy to HSQLDB? If so, can 
> you send me the patches or create a JIRA?
> 
> Regards,
> 
-- 
Bruno Dumon                             http://outerthought.org/
Outerthought - Open Source, Java & XML Competence Support Center
bruno at outerthought.org                          bruno at apache.org