Eclipse Community Forums: DTP » generate entities problem with sql server

Home » Eclipse Projects » DTP » generate entities problem with sql server

generate entities problem with sql server [message #55739]

Fri, 17 April 2009 11:12

Eclipse User

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

Eclipse User

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

Eclipse User

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

Eclipse User

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

Eclipse User

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

Goto Forum:

-=] Back to Top [=-

Current Time: Mon Jul 21 21:55:40 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter