EOModeler 5.2 cannot generate SQL for tables using unsigned int columns?
EOModeler 5.2 cannot generate SQL for tables using unsigned int columns?
- Subject: EOModeler 5.2 cannot generate SQL for tables using unsigned int columns?
- From: Tom Donaldson <email@hidden>
- Date: Mon, 7 Feb 2005 11:18:41 -0500
I am new to WebObjects.
I am using EOModeler to reverse engineer a MySQL database that uses unsigned integer data types (e.g., "int unsigned", "smallint unsigned", "tinyint unsigned").
EOModeler correctly shows the external data type for these columns. However, when I attempt the "Property:Generate SQL..." command for any table that uses an unsigned type I get an error dialog saying that it does not understand the unsigned type.
For example, for table 'Staff', with column 'staffId' of type 'smallint unsigned', I see:
"Alert Unable to find type information for external type 'smallint unsigned' in attribute 'staffId' of entity 'Staff'. Check spelling and capitalization.".
If I change the external data type in EOModeler to unsigned types, EOModeler will generate the SQL, but the generated SQL is incorrect since it does not includes the unsigned attribute.
Am I doing something wrong, or is this a problem with EOModeler (or the MySQL connector, or with MySQL, or ...)?
How can I fix it or work around it (other than to change the database so that it does not use unsigned ints)?
I guess if this only affects generation of SQL, then maybe it does not matter.
Will anything else in the generated model be affected by EOModeler's confusion over unsigned types?
Here is what I am using:
EOModeler: v5.2
MySQL Connector: mysql-connector-java-3.0.16-ga-bin.jar
MySQL: 4.1.4-gamma-standard-log
OS: Mac OS X 10.3.7
Thanks,
Tom
---
Tom "Continuous Traveler" Donaldson
www.mactom.com _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden