WebObjects Error in Wonder D2W when populating MS SQL Server example

Daniel Beatty Fri, 26 Sep 2008 10:27:56 -0700

Greetings Ladies, and Gentlemen,

I am having a bit of a difficulty with Wonder D2W project that I amusing to test out an MS SQL Server model for a class and I am hopingto work out the details of our favorite technology, soon. The erroroccurs when trying to populate a table in the database, in this casethe "dept" table. I have produced a record of my work at http://venus.cs.ttu.edu/groups/webobjects/wiki/f136d/Reverse_Engineering_a_MS_SQL_Server_Database_with_Entity_Modeler.html, which is intended to be completed as class example for a databasecourse (preferably using WO.) I could definately use some assistancefrom the gurus on this one.

In a nutshell, this is intended to be as "plain vanilla" of a D2Wexample as possible given that we are using a MS SQL Server 2005database. The good news is that D2W/ Entity Modeler were/ are goodfor debugging such the database model. The down side, the errorshown below is generated when trying to save a new entry in to thedatabase such as dept= {dnum = ?, dname = "pain", mname ="", length="0", takess = null} where dnum is the key and is a nchar of length 10.

I suppose the question is, how do I ensure that D2W or the databasegenerates a key when it otherwise does not display it? Or should itcome from the database, and if so how do I set that property?


Thank you,
Dan


Re-enter
employeeCourseD2W2              Exception Description
Application:     employeeCourseD2W2

Error: java.lang.IllegalStateException: Adaptor[EMAIL PROTECTED] failed to provide newprimary keys for entity 'Dept'Reason: Adaptor [EMAIL PROTECTED] failedto provide new primary keys for entity 'Dept'

Stack trace:    
File    Line#   Method  Package

EODatabaseContext.java 5709 prepareForSaveWithCoordinatorcom.webobjects.eoaccessEOObjectStoreCoordinator.java 365 saveChangesInEditingContextcom.webobjects.eocontrol

EOEditingContext.java   3176    saveChanges     com.webobjects.eocontrol
ERXEC.java      937     _saveChanges    er.extensions
ERXEC.java      860     saveChanges     er.extensions
ERD2WInspectPage.java   198     tryToSaveChanges        er.directtoweb
ERD2WInspectPage.java   244     submitAction    er.directtoweb
NativeMethodAccessorImpl.java   NA      invoke0 sun.reflect
NativeMethodAccessorImpl.java   39      invoke  sun.reflect
DelegatingMethodAccessorImpl.java       25      invoke  sun.reflect
Method.java     585     invoke  java.lang.reflect
NSKeyValueCoding.java   636     methodValue     com.webobjects.foundation
NSKeyValueCoding.java   1134    valueInObject   com.webobjects.foundation
NSKeyValueCoding.java   1293    valueForKey     com.webobjects.foundation
WOComponent.java        1686    valueForKey     com.webobjects.appserver
NSKeyValueCoding.java   447     valueForKey     com.webobjects.foundation

NSKeyValueCodingAdditions.java 212 valueForKeyPathcom.webobjects.foundation

WOComponent.java        1754    valueForKeyPath com.webobjects.appserver

WOKeyValueAssociation.java 50 valueInComponentcom.webobjects.appserver._private

WOImageButton.java      257     invokeAction    
com.webobjects.appserver._private