• 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: WebObjects Error in Wonder D2W when populating MS SQL Server example
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: WebObjects Error in Wonder D2W when populating MS SQL Server example


  • Subject: Re: WebObjects Error in Wonder D2W when populating MS SQL Server example
  • From: Chuck Hill <email@hidden>
  • Date: Fri, 26 Sep 2008 13:12:46 -0700


On Sep 26, 2008, at 1:02 PM, Daniel Beatty wrote:

Greetings Chuck,
Thanks for the response. I added the table in query mode, and it ended up placing the dbo prefix on the darn thing. Assuming that was not a problem,

That probably was a problem.


I ran my D2W example again, and received a similar error.

Yes, it needs to be in the same schema / dbo prefix as the other tables with the same permissions.



The plug in you sent seems to have a similar function, even though it is complaining about missing/ unresolved framework members such as ERXArrayUtilities, ERXEntityFKConstraintOrder, ERXJDBCPluginUtilities, er.extensions.jdbc, , er.extensions.er.

Any ideas?

Yes, you are not using Wonder. That plugin only works if the ERExtensions.framework from Wonder is included in the application.


Chuck


On Sep 26, 2008, at 1:14 PM, Chuck Hill wrote:

Hi Dan,

If you reverse engineered this database, it is probably missing the EO_PK_TABLE. EOF uses this to keep track of primary keys for databases that don't have sequence generators. Identify columns don't work (or not easily) with EOF as they are populated on the server side and thus EOF does not know the PK value.

You can manually create this table with:

CREATE TABLE EO_PK_TABLE (NAME CHAR(40) PRIMARY KEY, PK INT);


A couple of other SQL Server pointers:

- timestamps are only accurate to 3ms, Java SQL timestamps are accurate to 1. This can cause update failures if you attempt to lock on timestamp columns. I do want to lock on them, so I manually force all timestamps to have 0ms.

- SQL Server does not support deferred constraints (along with several other standard SQL things, but I won't get started on that). Thus, the EOF operations may need to be re-ordered before execution on the DB server to avoid spurious constraint failures. I will attach a custom plugin that handles this (correctly, AFAIK, bug reports welcome).


Chuck


<MicrosoftPlugIn.tgz>

<MicrosoftPlugIn_framework.tgz>



On Sep 26, 2008, at 10:27 AM, Daniel Beatty wrote:

Greetings Ladies, and Gentlemen,
I am having a bit of a difficulty with Wonder D2W project that I am using to test out an MS SQL Server model for a class and I am hoping to work out the details of our favorite technology, soon. The error occurs when trying to populate a table in the database, in this case the "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 database course (preferably using WO.) I could definately use some assistance from the gurus on this one.


In a nutshell, this is intended to be as "plain vanilla" of a D2W example as possible given that we are using a MS SQL Server 2005 database. The good news is that D2W/ Entity Modeler were/ are good for debugging such the database model. The down side, the error shown below is generated when trying to save a new entry in to the database 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 database generates a key when it otherwise does not display it? Or should it come from the database, and if so how do I set that property?

Thank you,
Dan


_______________________________________________ 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










Dan Beatty, M.S. CS (B.S. EECS) Ph.D. Student Texas Tech University email@hidden http://venus.cs.ttu.edu/~dabeatty







-- 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
References: 
 >WebObjects Error in Wonder D2W when populating MS SQL Server example (From: Daniel Beatty <email@hidden>)
 >Re: WebObjects Error in Wonder D2W when populating MS SQL Server example (From: Chuck Hill <email@hidden>)
 >Re: WebObjects Error in Wonder D2W when populating MS SQL Server example (From: Daniel Beatty <email@hidden>)

  • Prev by Date: Re: WebObjects Error in Wonder D2W when populating MS SQL Server example
  • Next by Date: caseInsensitiveLike unknown operator exception
  • Previous by thread: Re: WebObjects Error in Wonder D2W when populating MS SQL Server example
  • Next by thread: Re: WebObjects Error in Wonder D2W when populating MS SQL Server example
  • Index(es):
    • Date
    • Thread