I would like to share some experiences that I had connecting to DB2 9.7
with Torque 3.3-RC2.
First of all: I also had the problem that all records received from
village where readOnly so I was not able to write data back to the
database. Is there any better solution available than patching the
village working dog? Will there be an official update to deal with that
Second I had to customize the templates to deal with the problem that
BOOLEANCHAR was mapped to VHARCHAR without a size declaration. This
caused a syntax error in the SQL script. I changed it to VARCHAR(1).
Further data type adaptations were necessary because some of the data
types were too small to meet our special needs, i.e. the binary data,
which I changed to BLOB.
Another problem is a DB2 specialty that does not allow UNIQUE
constraints on nullable columns. Since we also use other databases
without this restraint I could not find a solution for that. Does
anybody have an idea for a workaround?
One final question: How far is DB2 9.7 already supported by Torque?
Does anyone have experience with it and likes to share the experiences
with us so were are prepared to further problems we might meet?