Hi Jeff,
Have you considered just uploading the working SQL file to the server
and executing the script from FrontBaseManager on the server? I think
that the key is the "Deferrable Initially Deferred" foreign key
constraint in the working version that doesn't exist in the non-
working version. I suspect the first version you posted has the
foreign key referencing a table that hasn't yet been created at the
moment the foreign key constraint is being created.
David
On 8-Nov-08, at 7:36 PM, Jeff Schmitz wrote:
I just noticed, the SQL generated on my development machine (and
that works) is quite a bit different (pasted below). I'm guessing I
have a versioning problem somewhere. Would this indicate something
with my project wonder versions? I'm pretty sure I've installed 5.4
on both machines into /Library/Frameworks.
CREATE TABLE "t_team_popup" (
"c_combo_index" INTEGER CONSTRAINT
NOT_NULL_t_team_popup__c_combo_index NOT NULL,
"comboTeamID" INTEGER CONSTRAINT NOT_NULL_t_team_popup__comboTeamID
NOT NULL,
"group" INTEGER CONSTRAINT NOT_NULL_t_team_popup__group NOT NULL,
"id" INTEGER CONSTRAINT NOT_NULL_t_team_popup__id NOT NULL,
"c_pool_type" INTEGER CONSTRAINT NOT_NULL_t_team_popup__c_pool_type
NOT NULL,
"c_seed" INTEGER CONSTRAINT NOT_NULL_t_team_popup__c_seed NOT NULL,
"c_team_id" INTEGER CONSTRAINT NOT_NULL_t_team_popup__c_team_id NOT
NULL,
"c_team_pos" INTEGER CONSTRAINT NOT_NULL_t_team_popup__c_team_pos
NOT NULL
);
SET UNIQUE = 1000000 FOR "t_team_popup";
ALTER TABLE "T_TEAM_POPUP" ADD CONSTRAINT
PRIMARY_KEY_t_team_popup_id PRIMARY KEY ("ID") NOT DEFERRABLE
INITIALLY IMMEDIATE;
ALTER TABLE "T_TEAM_POPUP" ADD CONSTRAINT
FOREIGN_KEY_t_team_popup_comboTeamID_t_combo_team_id FOREIGN KEY
("COMBOTEAMID") REFERENCES "T_COMBO_TEAM" ("ID") DEFERRABLE
INITIALLY DEFERRED;
Thanks,
Jeff
On Nov 8, 2008, at 9:28 PM, Jeff Schmitz wrote:
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/jeffandmonica%40mac.com
This email sent to [EMAIL PROTECTED]
_______________________________________________
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/programmingosx%40mac.com
This email sent to [EMAIL PROTECTED]
_______________________________________________
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]
