Hello,
I'm trying to deploy a project that I have on my developement
machine on my server but am having trouble creating my EO Tables on
the server machine using EO Modeler. I have installed the same
version of Eclipse and WOLips on both machines, and imported my
project into the workspace on my server machine.
On my development machine I can use EO modeler to create my tables
fine with Frontbase. However, when I try to do this on my server
machine using the same eomodel file, I get a series of errors when I
execute the SQL generated by EO modeler, and two of my tables don't
get created. The errors I get are:
Syntax error 180. Illegal Direct SQL statement
Syntax error 144. Illegal or missing base table element.
When I just try to create just one of the problem tables I get the
same errors.
This is the SQL that EOModeler generates for me for one of the tables
that causes the errors:
CREATE TABLE t_team_popup (c_combo_index INTEGER NOT NULL, comboTeamID
INTEGER NOT NULL, group INTEGER NOT NULL, id INTEGER NOT NULL,
c_pool_type INTEGER NOT NULL, c_seed INTEGER NOT NULL, c_team_id
INTEGER NOT NULL, c_team_pos INTEGER NOT NULL);
/* The 'Create Primary Key Support' option is unavailable. */;
ALTER TABLE t_team_popup ADD PRIMARY KEY (id);
ALTER TABLE t_team_popup ADD CONSTRAINT t_team_popup_comboTeam_FK
FOREIGN KEY (comboTeamID) REFERENCES t_combo_team (id);
Any ideas?
Thanks,
Jeff
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [EMAIL PROTECTED]
