Re: Foreign Keys On SQLServer
Re: Foreign Keys On SQLServer
- Subject: Re: Foreign Keys On SQLServer
- From: Art Isbell <email@hidden>
- Date: Mon, 24 Feb 2003 16:27:26 -1000
On Monday, February 24, 2003, at 03:23 PM, Riaz Lalehzari wrote:
Error from JDBC adaptor: EvaluateExpression failed:
<MicrosoftPlugIn$MicrosoftExpression: "ALTER TABLE
dbo.ApplicationFunctionSecurityGroup ADD CONSTRAINT
dbo.ApplicationFunctionSecurityGroup_securityGroup_FK FOREIGN KEY
(SecurityGroupID) REFERENCES dbo.SecurityGroup (ID)">:
Next exception:SQL State:HY000 -- error code: 170 -- msg:
[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Line 1:
Incorrect syntax near '.'.......
Databases typically have an identifier length limit. I suspect that
SQL Server's identifier length limit is 31 or 32 - check the docs.
"ApplicationFunctionSecurityGroup_securityGroup_FK" exceeds this
identifier length limit.
The fix is to rename these overlong identifiers. You will need to
execute this SQL in the database's SQL interpreter, isql, instead of in
EOModeler.
I've seen other people having the same problem on the mailing list but
there were no answers posted that I could find.
Spread the word :-)
Art
http://homepage.mac.com/aisbell/
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.