• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: EO Table creation failing
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: EO Table creation failing


  • Subject: Re: EO Table creation failing
  • From: Chuck Hill <email@hidden>
  • Date: Sat, 22 Nov 2008 20:50:17 -0800


On Nov 22, 2008, at 8:28 PM, Jeff Schmitz wrote:

I've at least figured out exactly what's wrong with the SQL that's being generated. There are really two problems. First, having no quotes around all the table and table column names is under most circumstances not a problem. However, it does open you up to problems if you happen to use a keyword for a column name. Well, of course that is exactly what I did. For my column names I always start them with a 'c_', so I should be immune to the problem. However, out of all my column names (which must number around 50 I guess), I forgot to do this for a single one, and of course that single one also happened to be a Frontbase keyword (group). Once again, my ability to find problems against all odds has reared its ugly head.

You do seem to possess some innate skill in this area. :-P


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.

As FrontBase does have primary key support, this strong suggests that the FrontBasePlugin.framework is not getting loaded like you think it is. Check where it is. Is that the same location configured in your project? Check the permissions. Try jar tf <framework jar file> to verify that the jar is not corrupt. Check the EO Model on that machine to make sure that FrontBase is still configured for that model.



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.

Again, I think the answer is that it is NOT using the plugin like you think it is. Mike might have some debugging you can turn on. Run Console.app (Applications/Utilities) when you generate the SQL and see there are any messages. IIRC, there can be a delay before they show up in that app.



Chuck


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 3/Webobjects for the Rest of Us/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?


Chuck



Thanks,
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.


Chuck


But 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:

since I sometimes I may not have my development machine available and need to use my deployment server for development.
yikes ...
I should have specified, not while it's actually in the act of deploying.



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.
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?

From Apple's kb:

Installing the WebObjects 5.4.3 update for Mac OS X 10.5 Server

This 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 5
If 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 later



Jeff


ms

_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden )
Help/Unsubscribe/Update your Subscription:

This email sent to email@hidden

_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (Webobjects- email@hidden)
Help/Unsubscribe/Update your Subscription:

This email sent to email@hidden

_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (email@hidden) Help/Unsubscribe/Update your Subscription: This email sent to email@hidden

-- Chuck Hill Senior Consultant / VP Development

Practical 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 Development

Practical 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@hidden) Help/Unsubscribe/Update your Subscription: This email sent to email@hidden

_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (email@hidden) Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden


-- Chuck Hill Senior Consultant / VP Development

Practical 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@hidden) Help/Unsubscribe/Update your Subscription: This email sent to email@hidden
  • Follow-Ups:
    • Re: EO Table creation failing
      • From: Mike Schrag <email@hidden>
References: 
 >EO Table creation failing (From: Jeff Schmitz <email@hidden>)
 >Re: EO Table creation failing (From: Jeff Schmitz <email@hidden>)
 >Re: EO Table creation failing (From: David Holt <email@hidden>)
 >Re: EO Table creation failing (From: Jeff Schmitz <email@hidden>)
 >Re: EO Table creation failing (From: Mike Schrag <email@hidden>)
 >Re: EO Table creation failing (From: Jeff Schmitz <email@hidden>)
 >Re: EO Table creation failing (From: Jeff Schmitz <email@hidden>)
 >Re: EO Table creation failing (From: Chuck Hill <email@hidden>)
 >Re: EO Table creation failing (From: Jeff Schmitz <email@hidden>)
 >Re: EO Table creation failing (From: Chuck Hill <email@hidden>)
 >Re: EO Table creation failing (From: Jeff Schmitz <email@hidden>)
 >Re: EO Table creation failing (From: Jeff Schmitz <email@hidden>)

  • Prev by Date: Re: EO Table creation failing
  • Next by Date: Re: About instance's integrity.
  • Previous by thread: Re: EO Table creation failing
  • Next by thread: Re: EO Table creation failing
  • Index(es):
    • Date
    • Thread