On 21/06/2006, at 9:20 PM, Mike Schrag wrote:

Is Person a subclass of another entity by any chance? If so, you are probably running into

http://en.wikibooks.org/wiki/Programming:WebObjects/EOF/Using_EOF/ Common_Pitfalls_and_Troubleshooting (Subclass Missing Primary Key)

Excellent advice. Thanks for creating this page Mike.

. Is there a reason you're using forceConnectionWithModel rather than just setConnectionDictionary on the EOModel?

A very good reason – it's the code on p 106 of Apple's Enterprise Objects Programming Guide (5.3)! However, as you suggest, setConnectionDictionary works better because it sets the dictionary rather than overrides it, so has the effect of clearing out the jdbc2Info setting.

On investigation, the jdbc2Info only differs in the 'defaultJDBCType' settings, some models have a CLOB type and others a BLOB (although I don't use that), so it looks like this is enough to make EO use a separate connection and thus for some reason not generate PKs. So this following code works:

    public Application () {
                super ();

                NSMutableDictionary d = new NSMutableDictionary ();
                d.takeValueForKey (Server_configuration.db_username, 
"username");
                d.takeValueForKey (Server_configuration.db_password, 
"password");
                d.takeValueForKey (Server_configuration.db_URL, "URL");
                EOEditingContext ec = new EOEditingContext ();
                
                try {
Enumeration /*[EOModel]*/ e = EOModelGroup.defaultGroup ().models ().objectEnumerator ();
                        
                        while (e.hasMoreElements ()) {
                                ((EOModel)e.nextElement 
()).setConnectionDictionary (d);
                        }
                } catch (Exception x) {
log.fatal ("Problem connecting to database. Reason: " + x.getMessage ());
                        System.exit (99);
                }
    }

Thanks again
Ian
Sportstec

For those WhO WOnder what we do, here is a little story at the BBC about our software (not the WO stuff) being used at the WOrld Cup:

http://www.bbcworld.com/content/template_clickonline.asp? pageid=665&co_pageid=3


ms

On Jun 21, 2006, at 3:28 AM, Ian Joyner wrote:

Good evening Mr Phelps,

I have put a usercode and password on our database to restrict any kind of access beneath Enterprise Objects (eg, with OpenBaseManager, but this should be independent of any particular database). I have added code to the Application constructor to log the EOModels into this DB with the following code:

    public Application () {
                super ();

                NSMutableDictionary d = new NSMutableDictionary ();
                d.takeValueForKey (Server_configuration.db_username, 
"username");
                d.takeValueForKey (Server_configuration.db_password, 
"password");
                d.takeValueForKey (Server_configuration.db_URL, "URL");
                EOEditingContext ec = new EOEditingContext ();
                
                try {
Enumeration e = EOModelGroup.defaultGroup ().models ().objectEnumerator ();
                        
                        while (e.hasMoreElements ()) {
EODatabaseContext.forceConnectionWithModel ((EOModel) e.nextElement (), d, ec);
                        }
                } catch (Exception x) {
log.fatal ("Problem connecting to database. Reason: " + x.getMessage ());
                        System.exit (99);
                }
    }

_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to archive@mail-archive.com

Reply via email to