Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » generate entities problem with sql server
generate entities problem with sql server [message #55739] Fri, 17 April 2009 15:12 Go to next message
ted beckett is currently offline ted beckettFriend
Messages: 4
Registered: July 2009
Junior Member
Hi, when I generate entities against a SQL Server 2005 database, entity
relationships are not being generated. Foreign key constraints are defined
for the database.

I've shown a constraint definition below which I got from Microsoft SQL
Server Management Studio. Any help is appreciated - Ted

ALTER TABLE [dbo].[ALL_EQUIPMENT] WITH NOCHECK ADD CONSTRAINT
[FK_EQUIPMENT_SUM_AFFILIATION] FOREIGN KEY([AFFILIATION])
REFERENCES [dbo].[L_AFFILIATION] ([AFFILIATION_CODE])
NOT FOR REPLICATION

Report message to a moderator

Re: generate entities problem with sql server [message #55798 is a reply to message #55739] Fri, 17 April 2009 23:00 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: brianf.sybase.com

What version of DTP are you using? The MSSQL support has improved in our
Galileo (1.7) work that's due out in June 2009. That may solve the issue.
--Fitz

"ted beckett" <work.beckett@gmail.com> wrote in message
news:9ddd69bc09a6796cf87835c317f97191$1@www.eclipse.org...
> Hi, when I generate entities against a SQL Server 2005 database, entity
> relationships are not being generated. Foreign key constraints are defined
> for the database.
> I've shown a constraint definition below which I got from Microsoft SQL
> Server Management Studio. Any help is appreciated - Ted
>
> ALTER TABLE [dbo].[ALL_EQUIPMENT] WITH NOCHECK ADD CONSTRAINT
> [FK_EQUIPMENT_SUM_AFFILIATION] FOREIGN KEY([AFFILIATION])
> REFERENCES [dbo].[L_AFFILIATION] ([AFFILIATION_CODE])
> NOT FOR REPLICATION
>

Report message to a moderator

Re: generate entities problem with sql server [message #55853 is a reply to message #55798] Mon, 20 April 2009 14:59 Go to previous message
ted beckett is currently offline ted beckettFriend
Messages: 4
Registered: July 2009
Junior Member
I'm using version 1.6.2.

I've learned more since my first post. Originally I only selected a single
table in the Generate Entity dialog and expected it to generate classes
for each related table. Now I think that is not how it works (my mistake).
If you want to generate classes that are related you must select the
related tables in the entity generation wizard.

When I select a set of related tables I get the error below. I've seen
postings/bug reports on this so I have more investigation on my own to do.
Thanks very much for your response.

An internal error occurred during: "Generating Entities".
ALL_FACILITY.FK_ALL_FACILITY_SUM - mismatched sizes: 0 vs. 1

Report message to a moderator

Re: generate entities problem with sql server [message #595582 is a reply to message #55739] Fri, 17 April 2009 23:00 Go to previous message
Brian Fitzpatrick is currently offline Brian FitzpatrickFriend
Messages: 500
Registered: July 2009
Senior Member
What version of DTP are you using? The MSSQL support has improved in our
Galileo (1.7) work that's due out in June 2009. That may solve the issue.
--Fitz

"ted beckett" <work.beckett@gmail.com> wrote in message
news:9ddd69bc09a6796cf87835c317f97191$1@www.eclipse.org...
> Hi, when I generate entities against a SQL Server 2005 database, entity
> relationships are not being generated. Foreign key constraints are defined
> for the database.
> I've shown a constraint definition below which I got from Microsoft SQL
> Server Management Studio. Any help is appreciated - Ted
>
> ALTER TABLE [dbo].[ALL_EQUIPMENT] WITH NOCHECK ADD CONSTRAINT
> [FK_EQUIPMENT_SUM_AFFILIATION] FOREIGN KEY([AFFILIATION])
> REFERENCES [dbo].[L_AFFILIATION] ([AFFILIATION_CODE])
> NOT FOR REPLICATION
>

Report message to a moderator

Re: generate entities problem with sql server [message #595594 is a reply to message #55798] Mon, 20 April 2009 14:59 Go to previous message
ted beckett is currently offline ted beckettFriend
Messages: 4
Registered: July 2009
Junior Member
I'm using version 1.6.2.

I've learned more since my first post. Originally I only selected a single
table in the Generate Entity dialog and expected it to generate classes
for each related table. Now I think that is not how it works (my mistake).
If you want to generate classes that are related you must select the
related tables in the entity generation wizard.

When I select a set of related tables I get the error below. I've seen
postings/bug reports on this so I have more investigation on my own to do.
Thanks very much for your response.

An internal error occurred during: "Generating Entities".
ALL_FACILITY.FK_ALL_FACILITY_SUM - mismatched sizes: 0 vs. 1

Report message to a moderator

Previous Topic:MySql connection through unix socket
Next Topic:Map files for milestone releases
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 18 08:53:46 GMT 2024

Powered by FUDForum. Page generated in 0.23780 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top

Sign up to our Newsletter

A fresh new issue delivered monthly