Begin forwarded message:
From: Daniel Beatty <[EMAIL PROTECTED]>
Date: September 26, 2008 4:02:59 PM CDT
To: Chuck Hill <[EMAIL PROTECTED]>
Cc: Daniel Beatty <[EMAIL PROTECTED]>
Subject: Re: WebObjects Error in Wonder D2W when populating MS SQL
Server example
Greetings Chuck,
The hint you gave about the schema is giving me a clue, and I might
be hitting on some weird difference between the so called Window
Authentication and SQL Server authentication. My university has a
REALLY WEIRD set up accessing this MS SQL Server. They enforce a
criteria that the creator of the table must be logged in on a AD
bound machine using the appropriate tools such as MS SQL Server
Management Studio Express (if there is anything appropriate about
MS). This user is logged in via Windows Authentication. There
is another user who name mirrors the AD name, and is used through
SQL Server authentication who is allowed read/write access and it is
apparently able to access the db through JDBC.
The EO_PK_TABLE is owned by dbo and is in the dbo scheme. It seems
as though Windows authenticated user and the SQL Server user do not
necessarily see eye to eye as being dbo. In fact, I can see the
EO_PK_TABLE under the dbo scheme through programs like iSQL when it
is told to use the dbo scheme as opposed to a scheme with my SQL
Server auth name, but otherwise not. It there a special instruction
that I can include in the URL or something that will force JDBC to
use the dbo scheme?
On Sep 26, 2008, at 3:12 PM, Chuck Hill wrote:
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.
I double checked, the source project I imported MicrosoftPlugin did
have ERExtensions turned on, thus I have a bigger mystery about my
Europa setup. Fortunately, you also included a frameworks jar which
appears to be the already compiled version. It looks like it is
supposed to be a JDBC plugin for Entity Modeler, but I am not sure
how to make the canned Entity Modeler see it.
Thanks,
Dan
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 protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/chill%40global-village.net
This email sent to [EMAIL PROTECTED]
--
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 PROTECTED]
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 protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [EMAIL PROTECTED]
