Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 334250

Summary:	Dali can not find table relations for MS SQL Server 2008
Product:	[WebTools] Dali JPA Tools	Reporter:	Gursel Koca <gurselkoca>
Component:	JPA	Assignee:	Neil Hauge <neil.hauge>
Status:	NEW ---	QA Contact:
Severity:	normal
Priority:	P3	CC:	neil.hauge
Version:	unspecified
Target Milestone:	---
Hardware:	PC
OS:	Windows 7
Whiteboard:
Bug Depends on:	335158
Bug Blocks:

Description Gursel Koca

2011-01-13 06:59:40 EST

Build Identifier:  20100617-1415

I am trying to generate entities from tables.. But Dali could not find all foreign key relations for MS SQL Server. I have changed jdbc driver, I have used inetd jdbc driver instead of Microsoft jdbc driver. Dali could find some of the relations not all off them.. 


Reproducible: Always

Steps to Reproduce:
1. Using SQL Server Connection 
2. Using JPA-Tools -> Generate Entities from Tables
3. Select tables that have relations
4.

Comment 1 Neil Hauge

2011-01-19 10:52:16 EST

Gursel,

When browsing the schema in the Data Source Explorer view, do you see all of the foreign keys that you are expecting in the tree?  Also, is there any visible pattern to the FK relationships that are being left out, or does it seem to be random?

Also, it would be great if you could attach a test schema that demonstrates the problem, but getting answers to the questions above would be a good start.

Thanks.

Comment 2 Gursel Koca

2011-01-21 04:07:58 EST

Well, it seems that the problem is not related to dali.. It looks like the problem originates from eclipse data tools component.  I have checked FK relations by using Data Source Explorer view, there is only one FK relations per table, and this relation is the first one .. 

If there is more than FK relations in the table, Eclipse Data Tools component brings only the first one.

Comment 3 Neil Hauge

2011-01-21 11:22:41 EST

Gursel...can you please enter a bug against the Data Tools project for this issue.  I will leave this bug open as I tracking bug against Dali.

Comment 4 Neil Hauge

2011-01-21 16:04:02 EST

Also, please comment here with the the bug number filed against DTP.

Comment 5 Gursel Koca

2011-01-24 03:54:23 EST

Bug number against DTP is 335158.

Comment 6 Neil Hauge

2011-01-24 14:19:04 EST

Please see bug 335158 for workaround information.  DTP is unable to fix this problem currently, but leaving this Dali bug open for tracking purposes.

Comment 7 Neil Hauge

2011-07-01 16:23:12 EDT

Moving JPA specific bugs to new JPA component in bugzilla.