Skip to main content



      Home
Home » Eclipse Projects » DTP » generate entities problem with sql server
generate entities problem with sql server [message #55739] Fri, 17 April 2009 11:12 Go to next message
Eclipse UserFriend
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
Re: generate entities problem with sql server [message #55798 is a reply to message #55739] Fri, 17 April 2009 19: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
>
Re: generate entities problem with sql server [message #55853 is a reply to message #55798] Mon, 20 April 2009 10:59 Go to previous message
Eclipse UserFriend
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
Re: generate entities problem with sql server [message #595582 is a reply to message #55739] Fri, 17 April 2009 19:00 Go to previous message
Eclipse UserFriend
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
>
Re: generate entities problem with sql server [message #595594 is a reply to message #55798] Mon, 20 April 2009 10:59 Go to previous message
Eclipse UserFriend
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
Previous Topic:MySql connection through unix socket
Next Topic:Map files for milestone releases
Goto Forum:
  


Current Time: Mon May 05 18:01:23 EDT 2025

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

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

Back to the top