Re: generate sql from entity modeler in Eclipse -- MySQL
Re: generate sql from entity modeler in Eclipse -- MySQL
- Subject: Re: generate sql from entity modeler in Eclipse -- MySQL
- From: Tarun Reddy <email@hidden>
- Date: Tue, 20 Nov 2007 18:04:58 -0700
Since this is along the same lines, I thought I'd add to the thread...
I'm using mysql and when generating SQL for a simple entity, I get the
following:
CREATE TABLE CATEGORY ("CATEGORY_NAME" VARCHAR(255)NOT NULL,
"CATEGORY_OID" INTEGER NOT NULL, "CATEGORY_ORDER" INTEGER NOT NULL);
ALTER TABLE CATEGORY ADD PRIMARY KEY (CATEGORY_OID);
I'm still getting the no space between the VARCHAR and NOT NULL in
3.3.4655 of WOLips. In addition, mysql complains that the double
quotes around CATEGORY_NAME, CATEGORY_OID, and CATEGORY_ORDER are
invalid for mysql 5.0. Specifically I get this error when pasting in
directly into mysql
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near '"CATEGORY_NAME" VARCHAR(255)NOT NULL,
"CATEGORY_OID" INTEGER NOT NULL, "CATEGORY' at line 1
If I remove the double quotes and add the missing space, all works.
Another WO5.4 bug?
Thanks,
Tarun
On Nov 18, 2007, at 9:39 PM, Mike Schrag wrote:
Right, I remember ... I actually still have that class flying
around in my project for the stuff we were talking about the last
time: SQL generation for sub entities and not null attributes. Is
that still necessary?
Can you send me that code, actually? That should just go into the
core ... I still think it's a bug in EOF.
ms
_______________________________________________
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
_______________________________________________
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