Re: generate sql from entity modeler in Eclipse -- MySQL

2007-11-22 Thread Tarun Reddy
On Nov 20, 2007, at 7:15 PM, Mike Schrag wrote: I'm still getting the no space between the VARCHAR and NOT NULL in 3.3.4655 of WOLips. This is because the regex I'm using is wrong ... I use \w (or \W .. i don't recall) and I think it's not matching ) on varchar(xxx) Cool... look forward t

Re: generate sql from entity modeler in Eclipse -- MySQL

2007-11-20 Thread Mike Schrag
I'm still getting the no space between the VARCHAR and NOT NULL in 3.3.4655 of WOLips. This is because the regex I'm using is wrong ... I use \w (or \W .. i don't recall) and I think it's not matching ) on varchar(xxx) In addition, mysql complains that the double quotes around CATEGORY_NAME

Re: generate sql from entity modeler in Eclipse -- MySQL

2007-11-20 Thread Tarun Reddy
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