openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Tim Holloway <t...@mousetech.com>
Subject Re: BUG: MySQL DDL Generation
Date Tue, 27 Nov 2007 23:39:24 GMT
I'm repeating this, since it never received action:

On Fri, 2007-11-09 at 18:14 -0500, Tim Holloway wrote:
> I turned the schema tool loose on a MySQL production database this
> afternoon and it failed. The essence of the problem appears that DDL was
> being generated with a type declaration of this form:
> 
> int unsigned(10)
> 
> In MySQL, the proper form is:
> 
> int(10) unsigned
> 
> viz:
> 
> ALTER TABLE fubar MODIFY col1 int(10) unsigned;
> 
> Checking other options indicates that similar constructs such as CREATE
> TABLE are likewise defective.
> 
> I looked at the svn trunk head source code in
> org.apache.openjpa.jdbc.sql.MySQLDictionary.java and the parent class
> DBDictionary.java. The offending method appears to be:
> 
> 1508:     public String getTypeName(Column col) 
> 
> This method has no override in MySQLDictionary, but apparently needs
> one. I think it's a minor mod, but I'm not currently set up to build and
> test in the environment where the offending database exists.
> 
> This is a SEVERE error. It causes generation of defective SQL for
> SQL-generating options and causes live updates to schemas to fail.
> 
> I don't have a Jira login at present, so if someone could log this, it
> would be appreciated.
> 
>    Thanks,
> 
>     Tim Holloway
> 


Mime
View raw message