The second problem is the generated SQL has a couple comments in it, but is apparently using illegal comment syntax for Frontbase. The example I have get is:
/* The 'Create Primary Key Support' option is unavaliable. */; Which causes Frontbase to choke.The still unanswered question is, why has the EOGenerator started generating the names without the quotes when it used to use quotes. And second, why the illegal comment syntax?
No biggie anymore for me I guess ,as I know how to get around the problem, but thought maybe someone might want to look into the Frontbase SQL generator code.
Thanks, Jeff On Nov 21, 2008, at 3:26 PM, Jeff Schmitz wrote:
Hello,After trying a few things, I have still been unable to get my app deployed because the SQL generated from my EOModel doesn't work on my deployment machine, so I decided on the "nuclear" option of clean installing OSX Server 10.5 and starting from scratch. While doing so, I documented each and every step, with many pictures, in hope that first, someone might be able to see what might be the problem, and second (if I get things working) I could update it as a sort of step by step, "Getting the Webobjects tools installed" instructions if folks think that might be useful to beginners.Anyway, my tale begins here: http://web.mac.com/jeffandmonica/iWeb/Site%203/Webobjects%20for%20the%20Rest%20of%20Us/F7A70CE4-09F1-45AE-B272-1203677064B3.html Any help would be greatly appreciated. Thanks, Jeff On Nov 19, 2008, at 10:10 PM, Chuck Hill wrote:On Nov 19, 2008, at 7:09 PM, Jeff Schmitz wrote:How do you know what version of webobjects you have installed? I guess I thought if you had Leopard running on two machines with dev tools installed, the version of Webobjects would be the same via the software updates, no?If you installed the same version of the dev tools and did not hack up anything, yes. But that does got guarantee the same versions of anything else.I've copied over all the wonder frameworks directly from my dev machine (Library/Frameworks/ER...) to my deployment machine, as well as the Frontbase framework.The Frontbase framework from Wonder or the identically named one from FrontBase? Is it on your project's classpath?Are the versions of Eclipse and WOLips the same?I've also copied over the /Library/Java/extensions/ frontbasejdbc.jar file from my dev machine to my deployment machine. My project was imported (with copy) directly from my dev machine to into the workspace on my deployment machine. I really don't know what else to check to try to get the machines in sync. Any other ideas out there?Check the Console.app logs. Any relevant messages? ChuckThanks, Jeff On Nov 16, 2008, at 10:33 PM, Chuck Hill wrote:On Nov 16, 2008, at 8:04 PM, Jeff Schmitz wrote:Hello,I'm still not getting anywhere with this problem. I've verified that webobjects, wonder frameworks and the frontbase plugin are the same on both machines.And only one copy of each? This might be a WebObjects vs Wonder version of the plug-in symptom. The plugin jar could be corrupted and not loading on the deployment machine.ChuckBut for some reason, the SQL generated by the EOModeler is different for the same eomodeld file. e.g. This is what's created for one of my EOs on my development machine where things work:CREATE TABLE "t_entry" ( "c_games" INTEGER NOT NULL, "c_groups" INTEGER NOT NULL, "id" INTEGER NOT NULL, "c_last_save" TIMESTAMP NOT NULL, "c_name" VARCHAR(50) NOT NULL, "c_password" VARCHAR(255) NOT NULL, "c_picks_confirmed" VARCHAR(5) NOT NULL, "poolID" INTEGER NOT NULL, "real" VARCHAR(5) NOT NULL, "spare_bool" VARCHAR(5) NOT NULL, "spare_int" INTEGER NOT NULL, "spare_str" VARCHAR(255) NOT NULL, "c_still_alive_first" VARCHAR(5) NOT NULL, "c_still_alive_second" VARCHAR(5) NOT NULL, "c_still_alive_third" VARCHAR(5) NOT NULL, "c_tie_breaker" INTEGER NOT NULL, "userID" INTEGER NOT NULL );While this is generated on my "deployment" machine and doesn't work when run:CREATE TABLE t_entry ( c_games INTEGER NOT NULL, c_groups INTEGER NOT NULL, id INTEGER NOT NULL, c_last_save TIMESTAMP NOT NULL, c_name VARCHAR(50) NOT NULL, c_password VARCHAR(255) NOT NULL, c_picks_confirmed VARCHAR(5) NOT NULL, poolID INTEGER NOT NULL, real VARCHAR(5) NOT NULL, spare_bool VARCHAR(5) NOT NULL, spare_int INTEGER NOT NULL, spare_str VARCHAR(255) NOT NULL, c_still_alive_first VARCHAR(5) NOT NULL, c_still_alive_second VARCHAR(5) NOT NULL, c_still_alive_third VARCHAR(5) NOT NULL, c_tie_breaker INTEGER NOT NULL, userID INTEGER NOT NULL); Any ideas on specifically what might cause such a discrepancy? Thanks, Jeff On Nov 9, 2008, at 7:41 AM, Jeff Schmitz wrote:On Nov 9, 2008, at 7:25 AM, Mike Schrag wrote:I should have specified, not while it's actually in the act of deploying.since I sometimes I may not have my development machine available and need to use my deployment server for development.yikes ...I'll double check the frontbase plugin, but I also tried downloading the "all in one" Eclipse + WOLips installer, which includes the frontbase plugin, and got the same results. Also both machines have Leopard installed (one client, one server), don't they both automatically install the same version of webobjects?Do you think the differences in what's generated is due to some kind of library version difference somewhere?You either have different versions of WO or different versions of the FrontBasePlugIn.From Apple's kb: Installing the WebObjects 5.4.3 update for Mac OS X 10.5 ServerThis update is available through the Software Update feature of Mac OS X Server. It is part of the Mac OS X 10.5.5 Update and cannot be obtained as a separate download.System requirements • Mac OS X Server 10.5 or later • Java 5If you are updating a WebObjects 5.4 system or performing a new installation of Mac OS X 10.5 Server:• Install Mac OS X Server version 10.5• Run Software update to update to Mac OS X Server version 10.5.5 or laterJeffms _______________________________________________ Do not post admin requests to the list. They will be ignored.Webobjects-dev mailing list (Webobjects- [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/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/chill%40global-village.net This email sent to [EMAIL PROTECTED]-- Chuck Hill Senior Consultant / VP DevelopmentPractical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems.http://www.global-village.net/products/practical_webobjects-- Chuck Hill Senior Consultant / VP DevelopmentPractical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems.http://www.global-village.net/products/practical_webobjects_______________________________________________ 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/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
