• 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
Problem: generating SQL for many-to-many relationships using EOModeler and OpenBase
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Problem: generating SQL for many-to-many relationships using EOModeler and OpenBase


  • Subject: Problem: generating SQL for many-to-many relationships using EOModeler and OpenBase
  • From: Tom Woteki <email@hidden>
  • Date: Fri, 2 May 2003 16:45:58 -0400
  • Resent-date: Fri, 2 May 2003 16:48:00 -0400
  • Resent-from: Tom Woteki <email@hidden>
  • Resent-message-id: <email@hidden>
  • Resent-to: email@hidden (webobjects dev), email@hidden

I am having problems generating SQL for an OpenBase database using EOModeler and OpenBase 7.0.12 on OSX 10.2.5 with Java 1.4.x. Additionally, my WebObjects apps throw exceptions when I do manage to generate the SQL, as described below, though the generation is clearly suspect.

Here is a simple setup: 2 entities Foo and Bar joined in a many-to-many using a correlation table BarFoo.

1) When I go to generate sql with the "Primary Key Constraints" checkbox in the SQL Generation dialog window checked, I get the following alert: "*** -[NSCFDictionary setObject:forKey:]: attempt to insert nil value" and no SQL is generated
2) If I uncheck the checkbox, SQL is generated but the resulting app throws an exception. I can provide a stack trace.
3) If recheck the preceding checkbox while the dialog window is open I get the following alert:


"An unexpected error has occurred which may cause EOModeler to malfunction. You may want to save copies of your open documents and quit EOModeler.

Error: NSInvalidArgumentException: *** -[NSCFDictionary setObject:forKey:]: attempt to insert nil value
Stack Trace:
NSInvalidArgumentException: *** -[NSCFDictionary setObject:forKey:]: attempt to insert nil value
at com.apple.cocoa.foundation.NSMutableDictionary.setObjectForKey(Native Method)
at OpenBasePlugIn$OpenBaseSynchronizationFactory.primaryKeyConstraintStatem entsForEntityGroup(OpenBasePlugIn.java:237)
at EOSynchronizationFactory.primaryKeyConstraintStatementsForEntityGroups(E OSynchronizationFactory.java:529)
at EOSynchronizationFactory.schemaCreationStatementsForEntities(EOSynchroni zationFactory.java:862)
at EOSynchronizationFactory.schemaCreationScriptForEntities(EOSynchronizati onFactory.java:663)"


Note that all this misbehavior occurs whether or not I use EOModeler's menu command for auto-generating a many to many relationship. I can duplicate the problem on 2 different machines.

Help?

TIA,

Tom
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.

  • Follow-Ups:
    • Re: Problem: generating SQL for many-to-many relationships using EOModeler and OpenBase
      • From: Ricardo Strausz <email@hidden>
  • Prev by Date: Re: the port number on the URL when running the development system
  • Next by Date: embedded objects
  • Previous by thread: Re: the port number on the URL when running the development system
  • Next by thread: Re: Problem: generating SQL for many-to-many relationships using EOModeler and OpenBase
  • Index(es):
    • Date
    • Thread