openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Michael Dick" <michael.d.d...@gmail.com>
Subject Re: BUG: MySQL DDL Generation
Date Wed, 28 Nov 2007 00:16:47 GMT
I went ahead and opened the JIRA for you (OPENJPA-455). I'll take a closer
look tomorrow, sorry for missing it earlier.

-Mike

On Nov 27, 2007 5:39 PM, Tim Holloway <timh@mousetech.com> wrote:

> 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
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message