On 8/14/06, Roger I Martin PhD <[EMAIL PROTECTED]> wrote:
I'm currently going thru the ddlutils source and everything looks clean(and understandable but I got more learning to go) but I haven't discovered where the type gets set to OTHER. Think it has to be the mysql driver but I fairly certain I'm using the same driver in both cases.
DdlUtils uses the JDBC type that is returned by the driver (via DatabaseMetaData), and only in a few cases modifies this type (e.g. for Oracle which only has the NUMBER numeric type, but we want to have e.g. BIGINT etc.). In the case of MySql, I'd suggest that you try a newer driver to see whether you get better results (not unlikely considering the changelists of the last few drivers). For DdlUtils 1.1 there are also some enhancements to the native type mapping planned which will give a more finegrained control over the mapping (e.g. http://issues.apache.org/jira/browse/DDLUTILS-86). Tom
