Greetings Mike, Chuck, and the rest of the gang,
Well I successfully included Chuck's MSSQL plugin, which looked pretty
nice. Of course the key-size issue and the scheme is still causing
some difficulty. Thus, I will try a simpler version of the database,
switching the keys for something a little more manageable, like the
prototyped id. I shall let you know what I find.
Later,
Dan
Begin forwarded message:
From: Daniel Beatty <[EMAIL PROTECTED]>
Date: September 26, 2008 5:18:18 PM CDT
To: Mike Schrag <[EMAIL PROTECTED]>
Cc: Daniel Beatty <[EMAIL PROTECTED]>, WebObjects-Dev List <[email protected]
>
Subject: Re: WebObjects Error in Wonder D2W when populating MS SQL
Server example
Greetings Mike,
Oh my. So I should have probably insisted that the prof allow the
key to be something a little more manageable, whatever that may
be. That is good to know.
Of course, I still need to check the special "dbo" schema issue
that is imposed due to my university's wacky user scheme. Also, I
need to ensure that I install Chuck's magic EOMSSQL prototype
mechanism. I assume that it goes in Eclipses' plugin section or
some other class-path acknowledged by Eclipse.
In any case, I do owe a lot of thanks for the help to both you and
Chuck. While it may literally be an academic issue, producing good
documentation, knowledge, and asking lots of questions is what
students are supposed to do.
That being said, what is a size of key can be accommodated by EOF?
Obviously, it probably would have been better for Entity Modeler to
generate the SQL, but there the darn authentication mechanism comes
into play. Is there a mechanism to force WO-JDBC to satisfy
"Windows Authentication" or Kerberized connections?
Thanks Mike,
Dan
On Sep 26, 2008, at 4:36 PM, Mike Schrag wrote:
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.
Your PK is an nvarchar(10)? EOF isn't going to be able to generate
a PK for that ... byte[12] (I think 12?) and numeric values only.
What value would you expect it to generate in a string? You can
write a custom plugin to do this, of course (or maybe in one of the
db delegates).
ms
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/danielbeatty%40mac.com
This email sent to [EMAIL PROTECTED]
Dan Beatty, M.S. CS (B.S. EECS)
Ph.D. Student
Texas Tech University
[EMAIL PROTECTED]
http://venus.cs.ttu.edu/~dabeatty
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [EMAIL PROTECTED]
