Re: SQL Generation

From: Kieran Kelleher (kieran_list..ac.com)
Date: Wed May 02 2007 - 17:35:37 EDT

  • Next message: Mike Schrag: "Re: Entity Modeler ... how to edit external width, scale, precision?"

    OK, I just got WOLips to generate the xcode file so I could open the
    project in XCode and launch the eomodel form there and generate the
    SQL, so my immediate problem is solved.

    FWIW, here is the complete index.eomodeld file with jdbc info ......
    seems OK ..... and EOModeler did generate the SQL ....

    kieranbook:~/DevProjects/eclipseworkspace/cheetah/Resources/
    cheetah.eomodeld kieran$ cat index.eomodeld

    {
         EOModelVersion = 2.1;
         adaptorName = JDBC;
         connectionDictionary =
         {
             URL = "jdbc:mysql://localhost/cheetah?
    capitalizeTypenames=true";
             driver = "";
             jdbc2Info =
             {
                 ANSI92_CONFORMANCE = ANSI92EntryLevel;
                 DBMS_NAME = MySQL;
                 DRIVER_NAME = "MySQL-AB JDBC Driver";
                 DRIVER_VER = "mysql-connector-java-3.0.17-ga ( $Date:
    2005/04/06 14:12:56 $, $Revision: 1.27.2.47 $ )";
                 IDENTIFIER_QUOTE_STRING = "`";
                 NON_NULLABLE_COLUMNS = T;
                 STRING_FUNCTIONS =
    "ASCII,BIN,BIT_LENGTH,CHAR,CHARACTER_LENGTH,CHAR_LENGTH,CONCAT,CONCAT_WS
    ,CONV,ELT,EXPORT_SET,FIELD,FIND_IN_SET,HEX,INSERT,INSTR,LCASE,LEFT,LENGT
    H,LOAD_FILE,LOCATE,LOCATE,LOWER,LPAD,LTRIM,MAKE_SET,MATCH,MID,OCT,OCTET_
    LENGTH,ORD,POSITION,QUOTE,REPEAT,REPLACE,REVERSE,RIGHT,RPAD,RTRIM,SOUNDE
    X,SPACE,STRCMP,SUBSTRING,SUBSTRING,SUBSTRING,SUBSTRING,SUBSTRING_INDEX,T
    RIM,UCASE,UPPER";
                 typeInfo =
                 {
                     BIGINT =
                     {
                         createParams = 1;
                         defaultJDBCType =
                         (
                            BIGINT
                         );
                         isNullable = T;
                         isSearchable = T;
                         maxScale = 0;
                         minScale = 0;
                         precision = 19;
                     };
                     BINARY =
                     {
                         createParams = 1;
                         defaultJDBCType =
                         (
                            BINARY
                         );
                         isNullable = T;
                         isSearchable = T;
                         maxScale = 0;
                         minScale = 0;
                         precision = 255;
                     };
                     BIT =
                     {
                         createParams = 1;
                         defaultJDBCType =
                         (
                            BIT
                         );
                         isNullable = T;
                         isSearchable = T;
                         maxScale = 0;
                         minScale = 0;
                         precision = 1;
                     };
                     BLOB =
                     {
                         createParams = 0;
                         defaultJDBCType =
                         (
                            "LONG VARBINARY"
                         );
                         isNullable = T;
                         isSearchable = T;
                         maxScale = 0;
                         minScale = 0;
                         precision = 65535;
                     };
                     BOOL =
                     {
                         createParams = 1;
                         defaultJDBCType =
                         (
                            BIT
                         );
                         isNullable = T;
                         isSearchable = T;
                         maxScale = 0;
                         minScale = 0;
                         precision = 1;
                     };
                     CHAR =
                     {
                         createParams = 1;
                         defaultJDBCType =
                         (
                            CHAR
                         );
                         isNullable = T;
                         isSearchable = T;
                         maxScale = 0;
                         minScale = 0;
                         precision = 255;
                     };
                     DATE =
                     {
                         createParams = 1;
                         defaultJDBCType =
                         (
                            DATE
                         );
                         isNullable = T;
                         isSearchable = T;
                         maxScale = 0;
                         minScale = 0;
                         precision = 0;
                     };
                     DATETIME =
                     {
                         createParams = 1;
                         defaultJDBCType =
                         (
                            TIMESTAMP
                         );
                         isNullable = T;
                         isSearchable = T;
                         maxScale = 0;
                         minScale = 0;
                         precision = 0;
                     };
                     DECIMAL =
                     {
                         createParams = 2;
                         defaultJDBCType =
                         (
                            DECIMAL
                         );
                         isNullable = T;
                         isSearchable = T;
                         maxScale = 308;
                         minScale = "-308";
                         precision = 17;
                     };
                     DOUBLE =
                     {
                         createParams = 2;
                         defaultJDBCType =
                         (
                            DOUBLE
                         );
                         isNullable = T;
                         isSearchable = T;
                         maxScale = 308;
                         minScale = "-308";
                         precision = 17;
                     };
                     "DOUBLE PRECISION" =
                     {
                         createParams = 2;
                         defaultJDBCType =
                         (
                            DOUBLE
                         );
                         isNullable = T;
                         isSearchable = T;
                         maxScale = 308;
                         minScale = "-308";
                         precision = 17;
                     };
                     ENUM =
                     {
                         createParams = 1;
                         defaultJDBCType =
                         (
                            VARCHAR
                         );
                         isNullable = T;
                         isSearchable = T;
                         maxScale = 0;
                         minScale = 0;
                         precision = 65535;
                     };
                     FLOAT =
                     {
                         createParams = 2;
                         defaultJDBCType =
                         (
                            REAL
                         );
                         isNullable = T;
                         isSearchable = T;
                         maxScale = 38;
                         minScale = "-38";
                         precision = 10;
                     };
                     INT =
                     {
                         createParams = 1;
                         defaultJDBCType =
                         (
                            INTEGER
                         );
                         isNullable = T;
                         isSearchable = T;
                         maxScale = 0;
                         minScale = 0;
                         precision = 10;
                     };
                     INTEGER =
                     {
                         createParams = 1;
                         defaultJDBCType =
                         (
                            INTEGER
                         );
                         isNullable = T;
                         isSearchable = T;
                         maxScale = 0;
                         minScale = 0;
                         precision = 10;
                     };
                     "LONG VARBINARY" =
                     {
                         createParams = 1;
                         defaultJDBCType =
                         (
                            "LONG VARBINARY"
                         );
                         isNullable = T;
                         isSearchable = T;
                         maxScale = 0;
                         minScale = 0;
                         precision = 16777215;
                     };
                     "LONG VARCHAR" =
                     {
                         createParams = 1;
                         defaultJDBCType =
                         (
                            "LONG VARCHAR"
                         );
                         isNullable = T;
                         isSearchable = T;
                         maxScale = 0;
                         minScale = 0;
                         precision = 16777215;
                     };
                     LONGBLOB =
                     {
                         createParams = 0;
                         defaultJDBCType =
                         (
                            "LONG VARBINARY"
                         );
                         isNullable = T;
                         isSearchable = T;
                         maxScale = 0;
                         minScale = 0;
                         precision = 2147483647;
                     };
                     LONGTEXT =
                     {
                         createParams = 1;
                         defaultJDBCType =
                         (
                            "LONG VARCHAR"
                         );
                         isNullable = T;
                         isSearchable = T;
                         maxScale = 0;
                         minScale = 0;
                         precision = 2147483647;
                     };
                     MEDIUMBLOB =
                     {
                         createParams = 0;
                         defaultJDBCType =
                         (
                            "LONG VARBINARY"
                         );
                         isNullable = T;
                         isSearchable = T;
                         maxScale = 0;
                         minScale = 0;
                         precision = 16777215;
                     };
                     MEDIUMINT =
                     {
                         createParams = 1;
                         defaultJDBCType =
                         (
                            INTEGER
                         );
                         isNullable = T;
                         isSearchable = T;
                         maxScale = 0;
                         minScale = 0;
                         precision = 7;
                     };
                     MEDIUMTEXT =
                     {
                         createParams = 1;
                         defaultJDBCType =
                         (
                            "LONG VARCHAR"
                         );
                         isNullable = T;
                         isSearchable = T;
                         maxScale = 0;
                         minScale = 0;
                         precision = 16777215;
                     };
                     NUMERIC =
                     {
                         createParams = 2;
                         defaultJDBCType =
                         (
                            NUMERIC
                         );
                         isNullable = T;
                         isSearchable = T;
                         maxScale = 308;
                         minScale = "-308";
                         precision = 17;
                     };
                     REAL =
                     {
                         createParams = 2;
                         defaultJDBCType =
                         (
                            DOUBLE
                         );
                         isNullable = T;
                         isSearchable = T;
                         maxScale = 308;
                         minScale = "-308";
                         precision = 17;
                     };
                     SET =
                     {
                         createParams = 1;
                         defaultJDBCType =
                         (
                            VARCHAR
                         );
                         isNullable = T;
                         isSearchable = T;
                         maxScale = 0;
                         minScale = 0;
                         precision = 64;
                     };
                     SMALLINT =
                     {
                         createParams = 1;
                         defaultJDBCType =
                         (
                            SMALLINT
                         );
                         isNullable = T;
                         isSearchable = T;
                         maxScale = 0;
                         minScale = 0;
                         precision = 5;
                     };
                     TEXT =
                     {
                         createParams = 1;
                         defaultJDBCType =
                         (
                            "LONG VARCHAR"
                         );
                         isNullable = T;
                         isSearchable = T;
                         maxScale = 0;
                         minScale = 0;
                         precision = 65535;
                     };
                     TIME =
                     {
                         createParams = 1;
                         defaultJDBCType =
                         (
                            TIME
                         );
                         isNullable = T;
                         isSearchable = T;
                         maxScale = 0;
                         minScale = 0;
                         precision = 0;
                     };
                     TIMESTAMP =
                     {
                         createParams = 1;
                         defaultJDBCType =
                         (
                            TIMESTAMP
                         );
                         isNullable = T;
                         isSearchable = T;
                         maxScale = 0;
                         minScale = 0;
                         precision = 0;
                     };
                     TINYBLOB =
                     {
                         createParams = 0;
                         defaultJDBCType =
                         (
                            "LONG VARBINARY"
                         );
                         isNullable = T;
                         isSearchable = T;
                         maxScale = 0;
                         minScale = 0;
                         precision = 255;
                     };
                     TINYINT =
                     {
                         createParams = 1;
                         defaultJDBCType =
                         (
                            TINYINT
                         );
                         isNullable = T;
                         isSearchable = T;
                         maxScale = 0;
                         minScale = 0;
                         precision = 3;
                     };
                     TINYTEXT =
                     {
                         createParams = 1;
                         defaultJDBCType =
                         (
                            "LONG VARCHAR"
                         );
                         isNullable = T;
                         isSearchable = T;
                         maxScale = 0;
                         minScale = 0;
                         precision = 255;
                     };
                     VARBINARY =
                     {
                         createParams = 1;
                         defaultJDBCType =
                         (
                            VARBINARY
                         );
                         isNullable = T;
                         isSearchable = T;
                         maxScale = 0;
                         minScale = 0;
                         precision = 255;
                     };
                     VARCHAR =
                     {
                         createParams = 1;
                         defaultJDBCType =
                         (
                            VARCHAR
                         );
                         isNullable = T;
                         isSearchable = T;
                         maxScale = 0;
                         minScale = 0;
                         precision = 255;
                     };
                 };
             };
             password = "XXXXXXXXXX";
             plugin = "";
             username = XXXXXXXXX;
         };
         entities =
         (

            {
                className = wk.cheetah.eof.CTAccount;
                name = CTAccount;
            },

            {
                className = wk.cheetah.eof.CTAccountAbstractTransaction;
                name = CTAccountAbstractTransaction;
            },

            {
                className = wk.cheetah.eof.CTAccountOnlineTransaction;
                name = CTAccountOnlineTransaction;
                parent = CTAccountAbstractTransaction;
            },

            {
                className = wk.cheetah.eof.CTAccountTransaction;
                name = CTAccountTransaction;
                parent = CTAccountAbstractTransaction;
            },

            {
                className = wk.cheetah.eof.CTAddress;
                name = CTAddress;
            },

            {
                className = wk.cheetah.eof.CTBrand;
                name = CTBrand;
            },

            {
                className = wk.cheetah.eof.CTCampaign;
                name = CTCampaign;
            },

            {
                className = wk.cheetah.eof.CTCcInformation;
                name = CTCcInformation;
            },

            {
                className = wk.cheetah.eof.CTCode;
                name = CTCode;
            },

            {
                className = wk.cheetah.eof.CTCodeList;
                name = CTCodeList;
            },

            {
                className = wk.cheetah.eof.CTCommission;
                name = CTCommission;
            },

            {
                className = wk.cheetah.eof.CTCustomer;
                name = CTCustomer;
                parent = CTTrader;
            },

            {
                className = EOGenericRecord;
                name = CTCustomerCTMediaTemplate;
            },

            {
                className = wk.cheetah.eof.CTDataList;
                name = CTDataList;
            },

            {
                className = wk.cheetah.eof.CTDataRecord;
                name = CTDataRecord;
            },

            {
                className = wk.cheetah.eof.CTEmailBlast;
                name = CTEmailBlast;
            },

            {
                className = wk.cheetah.eof.CTFrequentlyAskedQuestion;
                name = CTFrequentlyAskedQuestion;
            },

            {
                className = wk.cheetah.eof.CTGeoRegion;
                name = CTGeoRegion;
            },

            {
                className = wk.cheetah.eof.CTGeoSpatialPoint;
                name = CTGeoSpatialPoint;
            },

            {
                className = wk.cheetah.eof.CTGeography;
                name = CTGeography;
            },

            {
                className = wk.cheetah.eof.CTGeographySpec;
                name = CTGeographySpec;
            },

            {
                className = wk.cheetah.eof.CTIndustry;
                name = CTIndustry;
            },

            {
                className = wk.cheetah.eof.CTInternetAddress;
                name = CTInternetAddress;
            },

            {
                className = wk.cheetah.eof.CTJob;
                name = CTJob;
            },

            {
                className = wk.cheetah.eof.CTKeyCode;
                name = CTKeyCode;
            },

            {
                className = wk.cheetah.eof.CTListSpec;
                name = CTListSpec;
            },

            {
                className = wk.cheetah.eof.CTLocation;
                name = CTLocation;
            },

            {
                className = wk.cheetah.eof.CTMailTemplate;
                name = CTMailTemplate;
                parent = CTMediaTemplate;
            },

            {
                className = wk.cheetah.eof.CTMailingRate;
                name = CTMailingRate;
            },

            {
                className = wk.cheetah.eof.CTMedia;
                name = CTMedia;
            },

            {
                className = wk.cheetah.eof.CTMediaTemplate;
                name = CTMediaTemplate;
            },

            {
                className = wk.cheetah.eof.CTMerchantAccount;
                name = CTMerchantAccount;
            },

            {
                className = wk.cheetah.eof.CTMessage;
                name = CTMessage;
            },

            {
                className = wk.cheetah.eof.CTOnlineTransactionEvent;
                name = CTOnlineTransactionEvent;
            },

            {
                className = wk.cheetah.eof.CTOptoutEmail;
                name = CTOptoutEmail;
            },

            {
                className = wk.cheetah.eof.CTOutputMedia;
                name = CTOutputMedia;
            },

            {
                className = wk.cheetah.eof.CTPerson;
                name = CTPerson;
            },

            {
                className = wk.cheetah.eof.CTPrivilege;
                name = CTPrivilege;
            },

            {
                className = wk.cheetah.eof.CTProduct;
                name = CTProduct;
            },

            {
                className = wk.cheetah.eof.CTProductTransaction;
                name = CTProductTransaction;
            },

            {
                className = wk.cheetah.eof.CTProgram;
                name = CTProgram;
            },

            {
                className = wk.cheetah.eof.CTProgramClass;
                name = CTProgramClass;
            },

            {
                className = EOGenericRecord;
                name = CTProgramDefaults;
            },

            {
                className = EOGenericRecord;
                name = CTProgramDefaultsCTProduct;
            },

            {
                className = wk.cheetah.eof.CTProspect;
                name = CTProspect;
            },

            {
                className = wk.cheetah.eof.CTRegion;
                name = CTRegion;
            },

            {
                className = wk.cheetah.eof.CTReseller;
                name = CTReseller;
                parent = CTTrader;
            },

            {
                className = wk.cheetah.eof.CTSalesperson;
                name = CTSalesperson;
                parent = CTTrader;
            },

            {
                className = wk.cheetah.eof.CTScheduledTask;
                name = CTScheduledTask;
            },

            {
                className = wk.cheetah.eof.CTScheduledTaskEvent;
                name = CTScheduledTaskEvent;
            },

            {
                className = wk.cheetah.eof.CTSkin;
                name = CTSkin;
            },

            {
                className = wk.cheetah.eof.CTSmartMixJob;
                name = CTSmartMixJob;
                parent = CTJob;
            },

            {
                className = wk.cheetah.eof.CTSmartMixMessage;
                name = CTSmartMixMessage;
                parent = CTMessage;
            },

            {
                className = wk.cheetah.eof.CTStatement;
                name = CTStatement;
            },

            {
                className = wk.cheetah.eof.CTString16Mb;
                name = CTString16Mb;
            },

            {
                className = wk.cheetah.eof.CTString64K;
                name = CTString64K;
            },

            {
                className = EOGenericRecord;
                name = CTTaxRate;
            },

            {
                className = EOGenericRecord;
                name = CTTemplateField;
            },

            {
                className = wk.cheetah.eof.CTTrader;
                name = CTTrader;
            },

            {
                className = wk.cheetah.eof.CTUser;
                name = CTUser;
            },

            {
                className = EOGenericRecord;
                name = CTUserCTCustomer;
            },

            {
                className = EOGenericRecord;
                name = CTUserCTLocation;
            },

            {
                className = EOGenericRecord;
                name = CTUserCTPrivilege;
            },

            {
                className = EOGenericRecord;
                name = CTUserCTSalesperson;
            },

            {
                className = wk.cheetah.eof.CTVariableField;
                name = CTVariableField;
            },

            {
                className = wk.cheetah.eof.CTVariableFieldEntry;
                name = CTVariableFieldEntry;
            },

            {
                className = wk.cheetah.eof.CTZip5Region;
                name = CTZip5Region;
                parent = CTRegion;
            },

            {
                className = EOGenericRecord;
                name = XXCustomerSuppressList;
            },

            {
                className = EOGenericRecord;
                name = XXDataListDataRecord;
            },

            {
                className = EOGenericRecord;
                name = ZTestUnique;
            }
         );
         entitiesWithSharedObjects =
         (
            CTCode
         );
         userInfo =
         {
             _EntityModeler =
             {
                 activeDatabaseConfigName = Default;
                 databaseConfigs =
                 {
                     Default =
                     {
                         adaptorName = JDBC;
                         connectionDictionary =
                         {
                             URL = "jdbc:mysql://localhost/cheetah?
    capitalizeTypenames=true";
                             driver = "";
                             jdbc2Info =
                             {
                                 ANSI92_CONFORMANCE = ANSI92EntryLevel;
                                 DBMS_NAME = MySQL;
                                 DRIVER_NAME = "MySQL-AB JDBC Driver";
                                 DRIVER_VER = "mysql-connector-
    java-3.0.17-ga ( $Date: 2005/04/06 14:12:56 $, $Revision: 1.27.2.47
    $ )";
                                 IDENTIFIER_QUOTE_STRING = "`";
                                 NON_NULLABLE_COLUMNS = T;
                                 STRING_FUNCTIONS =
    "ASCII,BIN,BIT_LENGTH,CHAR,CHARACTER_LENGTH,CHAR_LENGTH,CONCAT,CONCAT_WS
    ,CONV,ELT,EXPORT_SET,FIELD,FIND_IN_SET,HEX,INSERT,INSTR,LCASE,LEFT,LENGT
    H,LOAD_FILE,LOCATE,LOCATE,LOWER,LPAD,LTRIM,MAKE_SET,MATCH,MID,OCT,OCTET_
    LENGTH,ORD,POSITION,QUOTE,REPEAT,REPLACE,REVERSE,RIGHT,RPAD,RTRIM,SOUNDE
    X,SPACE,STRCMP,SUBSTRING,SUBSTRING,SUBSTRING,SUBSTRING,SUBSTRING_INDEX,T
    RIM,UCASE,UPPER";
                                 typeInfo =
                                 {
                                     BIGINT =
                                     {
                                         createParams = 1;
                                         defaultJDBCType =
                                         (
                                            BIGINT
                                         );
                                         isNullable = T;
                                         isSearchable = T;
                                         maxScale = 0;
                                         minScale = 0;
                                         precision = 19;
                                     };
                                     BINARY =
                                     {
                                         createParams = 1;
                                         defaultJDBCType =
                                         (
                                            BINARY
                                         );
                                         isNullable = T;
                                         isSearchable = T;
                                         maxScale = 0;
                                         minScale = 0;
                                         precision = 255;
                                     };
                                     BIT =
                                     {
                                         createParams = 1;
                                         defaultJDBCType =
                                         (
                                            BIT
                                         );
                                         isNullable = T;
                                         isSearchable = T;
                                         maxScale = 0;
                                         minScale = 0;
                                         precision = 1;
                                     };
                                     BLOB =
                                     {
                                         createParams = 0;
                                         defaultJDBCType =
                                         (
                                            "LONG VARBINARY"
                                         );
                                         isNullable = T;
                                         isSearchable = T;
                                         maxScale = 0;
                                         minScale = 0;
                                         precision = 65535;
                                     };
                                     BOOL =
                                     {
                                         createParams = 1;
                                         defaultJDBCType =
                                         (
                                            BIT
                                         );
                                         isNullable = T;
                                         isSearchable = T;
                                         maxScale = 0;
                                         minScale = 0;
                                         precision = 1;
                                     };
                                     CHAR =
                                     {
                                         createParams = 1;
                                         defaultJDBCType =
                                         (
                                            CHAR
                                         );
                                         isNullable = T;
                                         isSearchable = T;
                                         maxScale = 0;
                                         minScale = 0;
                                         precision = 255;
                                     };
                                     DATE =
                                     {
                                         createParams = 1;
                                         defaultJDBCType =
                                         (
                                            DATE
                                         );
                                         isNullable = T;
                                         isSearchable = T;
                                         maxScale = 0;
                                         minScale = 0;
                                         precision = 0;
                                     };
                                     DATETIME =
                                     {
                                         createParams = 1;
                                         defaultJDBCType =
                                         (
                                            TIMESTAMP
                                         );
                                         isNullable = T;
                                         isSearchable = T;
                                         maxScale = 0;
                                         minScale = 0;
                                         precision = 0;
                                     };
                                     DECIMAL =
                                     {
                                         createParams = 2;
                                         defaultJDBCType =
                                         (
                                            DECIMAL
                                         );
                                         isNullable = T;
                                         isSearchable = T;
                                         maxScale = 308;
                                         minScale = "-308";
                                         precision = 17;
                                     };
                                     DOUBLE =
                                     {
                                         createParams = 2;
                                         defaultJDBCType =
                                         (
                                            DOUBLE
                                         );
                                         isNullable = T;
                                         isSearchable = T;
                                         maxScale = 308;
                                         minScale = "-308";
                                         precision = 17;
                                     };
                                     "DOUBLE PRECISION" =
                                     {
                                         createParams = 2;
                                         defaultJDBCType =
                                         (
                                            DOUBLE
                                         );
                                         isNullable = T;
                                         isSearchable = T;
                                         maxScale = 308;
                                         minScale = "-308";
                                         precision = 17;
                                     };
                                     ENUM =
                                     {
                                         createParams = 1;
                                         defaultJDBCType =
                                         (
                                            VARCHAR
                                         );
                                         isNullable = T;
                                         isSearchable = T;
                                         maxScale = 0;
                                         minScale = 0;
                                         precision = 65535;
                                     };
                                     FLOAT =
                                     {
                                         createParams = 2;
                                         defaultJDBCType =
                                         (
                                            REAL
                                         );
                                         isNullable = T;
                                         isSearchable = T;
                                         maxScale = 38;
                                         minScale = "-38";
                                         precision = 10;
                                     };
                                     INT =
                                     {
                                         createParams = 1;
                                         defaultJDBCType =
                                         (
                                            INTEGER
                                         );
                                         isNullable = T;
                                         isSearchable = T;
                                         maxScale = 0;
                                         minScale = 0;
                                         precision = 10;
                                     };
                                     INTEGER =
                                     {
                                         createParams = 1;
                                         defaultJDBCType =
                                         (
                                            INTEGER
                                         );
                                         isNullable = T;
                                         isSearchable = T;
                                         maxScale = 0;
                                         minScale = 0;
                                         precision = 10;
                                     };
                                     "LONG VARBINARY" =
                                     {
                                         createParams = 1;
                                         defaultJDBCType =
                                         (
                                            "LONG VARBINARY"
                                         );
                                         isNullable = T;
                                         isSearchable = T;
                                         maxScale = 0;
                                         minScale = 0;
                                         precision = 16777215;
                                     };
                                     "LONG VARCHAR" =
                                     {
                                         createParams = 1;
                                         defaultJDBCType =
                                         (
                                            "LONG VARCHAR"
                                         );
                                         isNullable = T;
                                         isSearchable = T;
                                         maxScale = 0;
                                         minScale = 0;
                                         precision = 16777215;
                                     };
                                     LONGBLOB =
                                     {
                                         createParams = 0;
                                         defaultJDBCType =
                                         (
                                            "LONG VARBINARY"
                                         );
                                         isNullable = T;
                                         isSearchable = T;
                                         maxScale = 0;
                                         minScale = 0;
                                         precision = 2147483647;
                                     };
                                     LONGTEXT =
                                     {
                                         createParams = 1;
                                         defaultJDBCType =
                                         (
                                            "LONG VARCHAR"
                                         );
                                         isNullable = T;
                                         isSearchable = T;
                                         maxScale = 0;
                                         minScale = 0;
                                         precision = 2147483647;
                                     };
                                     MEDIUMBLOB =
                                     {
                                         createParams = 0;
                                         defaultJDBCType =
                                         (
                                            "LONG VARBINARY"
                                         );
                                         isNullable = T;
                                         isSearchable = T;
                                         maxScale = 0;
                                         minScale = 0;
                                         precision = 16777215;
                                     };
                                     MEDIUMINT =
                                     {
                                         createParams = 1;
                                         defaultJDBCType =
                                         (
                                            INTEGER
                                         );
                                         isNullable = T;
                                         isSearchable = T;
                                         maxScale = 0;
                                         minScale = 0;
                                         precision = 7;
                                     };
                                     MEDIUMTEXT =
                                     {
                                         createParams = 1;
                                         defaultJDBCType =
                                         (
                                            "LONG VARCHAR"
                                         );
                                         isNullable = T;
                                         isSearchable = T;
                                         maxScale = 0;
                                         minScale = 0;
                                         precision = 16777215;
                                     };
                                     NUMERIC =
                                     {
                                         createParams = 2;
                                         defaultJDBCType =
                                         (
                                            NUMERIC
                                         );
                                         isNullable = T;
                                         isSearchable = T;
                                         maxScale = 308;
                                         minScale = "-308";
                                         precision = 17;
                                     };
                                     REAL =
                                     {
                                         createParams = 2;
                                         defaultJDBCType =
                                         (
                                            DOUBLE
                                         );
                                         isNullable = T;
                                         isSearchable = T;
                                         maxScale = 308;
                                         minScale = "-308";
                                         precision = 17;
                                     };
                                     SET =
                                     {
                                         createParams = 1;
                                         defaultJDBCType =
                                         (
                                            VARCHAR
                                         );
                                         isNullable = T;
                                         isSearchable = T;
                                         maxScale = 0;
                                         minScale = 0;
                                         precision = 64;
                                     };
                                     SMALLINT =
                                     {
                                         createParams = 1;
                                         defaultJDBCType =
                                         (
                                            SMALLINT
                                         );
                                         isNullable = T;
                                         isSearchable = T;
                                         maxScale = 0;
                                         minScale = 0;
                                         precision = 5;
                                     };
                                     TEXT =
                                     {
                                         createParams = 1;
                                         defaultJDBCType =
                                         (
                                            "LONG VARCHAR"
                                         );
                                         isNullable = T;
                                         isSearchable = T;
                                         maxScale = 0;
                                         minScale = 0;
                                         precision = 65535;
                                     };
                                     TIME =
                                     {
                                         createParams = 1;
                                         defaultJDBCType =
                                         (
                                            TIME
                                         );
                                         isNullable = T;
                                         isSearchable = T;
                                         maxScale = 0;
                                         minScale = 0;
                                         precision = 0;
                                     };
                                     TIMESTAMP =
                                     {
                                         createParams = 1;
                                         defaultJDBCType =
                                         (
                                            TIMESTAMP
                                         );
                                         isNullable = T;
                                         isSearchable = T;
                                         maxScale = 0;
                                         minScale = 0;
                                         precision = 0;
                                     };
                                     TINYBLOB =
                                     {
                                         createParams = 0;
                                         defaultJDBCType =
                                         (
                                            "LONG VARBINARY"
                                         );
                                         isNullable = T;
                                         isSearchable = T;
                                         maxScale = 0;
                                         minScale = 0;
                                         precision = 255;
                                     };
                                     TINYINT =
                                     {
                                         createParams = 1;
                                         defaultJDBCType =
                                         (
                                            TINYINT
                                         );
                                         isNullable = T;
                                         isSearchable = T;
                                         maxScale = 0;
                                         minScale = 0;
                                         precision = 3;
                                     };
                                     TINYTEXT =
                                     {
                                         createParams = 1;
                                         defaultJDBCType =
                                         (
                                            "LONG VARCHAR"
                                         );
                                         isNullable = T;
                                         isSearchable = T;
                                         maxScale = 0;
                                         minScale = 0;
                                         precision = 255;
                                     };
                                     VARBINARY =
                                     {
                                         createParams = 1;
                                         defaultJDBCType =
                                         (
                                            VARBINARY
                                         );
                                         isNullable = T;
                                         isSearchable = T;
                                         maxScale = 0;
                                         minScale = 0;
                                         precision = 255;
                                     };
                                     VARCHAR =
                                     {
                                         createParams = 1;
                                         defaultJDBCType =
                                         (
                                            VARCHAR
                                         );
                                         isNullable = T;
                                         isSearchable = T;
                                         maxScale = 0;
                                         minScale = 0;
                                         precision = 255;
                                     };
                                 };
                             };
                             password = "XXXXXXXXX";
                             plugin = "";
                             username = XXXXXXXX;
                         };
                         prototypeEntityName = EOPrototypes;
                     };
                 };
             };
         };
    }

    On May 2, 2007, at 4:58 PM, Chuck Hill wrote:

    > Bad jdbc2info in the model can do this. Have you changed the DB or
    > JDCB driver too? Is the jdbc2info in the model corrupted? Is
    > there some different external type for these attributes?
    >
    > Chuck
    >
    > On May 2, 2007, at 1:49 PM, Kieran Kelleher wrote:
    >
    >> I set up a new entity in a model that was previously maintained by
    >> EOModeler.
    >>
    >> When trying the generate SQL for the new Entity, I get this error:
    >> java.lang.ClassCastException: java.lang.Integer
    >> at
    >> com.webobjects.jdbcadaptor.JDBCExpression.columnTypeStringForAttribut
    >> e(JDBCExpression.java:293)
    >> at
    >> com.webobjects.eoaccess.EOSQLExpression.addCreateClauseForAttribute
    >> (EOSQLExpression.java:2498)
    >> at
    >> com.webobjects.eoaccess.EOSynchronizationFactory.createTableStatement
    >> sForEntityGroup(EOSynchronizationFactory.java:318)
    >> at
    >> com.webobjects.eoaccess.EOSynchronizationFactory.createTableStatement
    >> sForEntityGroups(EOSynchronizationFactory.java:487)
    >> at
    >> com.webobjects.eoaccess.EOSynchronizationFactory.schemaCreationStatem
    >> entsForEntities(EOSynchronizationFactory.java:951)
    >> at
    >> com.webobjects.eoaccess.EOSynchronizationFactory.schemaCreationScript
    >> ForEntities(EOSynchronizationFactory.java:747)
    >> at
    >> org.objectstyle.wolips.eomodeler.sql.EOFSQLGenerator.getSchemaCreatio
    >> nScript(EOFSQLGenerator.java:389)
    >> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    >> at sun.reflect.NativeMethodAccessorImpl.invoke
    >> (NativeMethodAccessorImpl.java:39)
    >> at sun.reflect.DelegatingMethodAccessorImpl.invoke
    >> (DelegatingMethodAccessorImpl.java:25)
    >> at java.lang.reflect.Method.invoke(Method.java:585)
    >> at
    >> org.objectstyle.wolips.eomodeler.actions.GenerateSQLDialog.generateSq
    >> l(Unknown Source)
    >> at org.objectstyle.wolips.eomodeler.actions.GenerateSQLDialog
    >> $1.run(Unknown Source)
    >> at java.lang.Thread.run(Thread.java:613)
    >>
    >>
    >> The setup is:
    >> WOLips and Wonder of today.
    >> All frameworks are "linked" in from workspace and also exist in /
    >> Library/Frameworks
    >> I am using my own prototypes. ERPrototypes framework is not
    >> referenced by the project at all.
    >>
    >> I'll go get this done by hand right now since it is just a half-
    >> dozen attributes in the new entity, but any ideas on what this
    >> problem is?
    >
    > --
    >
    > Practical WebObjects - for developers who want to increase their
    > overall knowledge of WebObjects or who are trying to solve specific
    > problems.
    > http://www.global-village.net/products/practical_webobjects
    >
    >
    >
    >
    >



    This archive was generated by hypermail 2.0.0 : Wed May 02 2007 - 17:36:00 EDT