yes, but I'd like to be able to re-generate directly from my
deployment machine too since I sometimes I may not have my development
machine available and need to use my deployment server for development.
Do you think the differences in what's generated is due to some kind
of library version difference somewhere?
Jeff
On Nov 8, 2008, at 10:04 PM, David Holt wrote:
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]
