Re: EOM Generating SQL for MySQL 5

From: Mike Schrag (mschra..dimension.com)
Date: Fri Jun 13 2008 - 16:55:22 EDT

  • Next message: David Holt: "Java icon in dock"

    If you're using WO 5.4, SQL generation doesn't work with EM until 5.4.2.

    ms

    On Jun 13, 2008, at 1:46 PM, Klaus Berkling wrote:

    > Anyone seen this? Can't just be me.
    >
    > The SQL generated by Entity Modeler puts quotes around the column
    > names and MySQL does not seem to like it.
    >
    > Works:
    > CREATE TABLE Country (_id INT NOT NULL);
    >
    > Does not:
    > CREATE TABLE Country ("_id" INT NOT NULL);
    >
    > ERROR 1064 (42000) at line <n>
    >
    > MySQL:
    > mysql Ver 14.12 Distrib 5.0.51a, for apple-darwin8.5.1 (i686) using
    > readline 5.0
    >
    > Eclipse:
    > Version: 3.3.2
    > Build id: M20080221-1800
    >
    > WOLips:
    > First seen in 5047 and reproduces in 5233
    >
    > Thanks
    >
    > kib
    >
    > "Success is not final, failure is not fatal: it is the courage to
    > continue that counts.”
    > - Winston Churchill
    >
    > Klaus Berkling
    > Systems Administrator
    > DynEd International, Inc.
    > www.dyned.com | www.eskimo.com/~kiberkli
    >
    >
    >

    This archive was generated by hypermail 2.0.0 : Fri Jun 13 2008 - 16:56:09 EDT