Re: WebObjects Error in Wonder D2W when populating MS SQL Server example
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