Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.
Bug 334250 - Dali can not find table relations for MS SQL Server 2008
Summary: Dali can not find table relations for MS SQL Server 2008
Status: NEW
Alias: None
Product: Dali JPA Tools
Classification: WebTools
Component: JPA (show other bugs)
Version: unspecified   Edit
Hardware: PC Windows 7
: P3 normal with 1 vote (vote)
Target Milestone: ---   Edit
Assignee: Neil Hauge CLA
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on: 335158
Blocks:
  Show dependency tree
 
Reported: 2011-01-13 06:59 EST by Gursel Koca CLA
Modified: 2011-07-01 16:23 EDT (History)
1 user (show)

See Also:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Gursel Koca CLA 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 CLA 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 CLA 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 CLA 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 CLA 2011-01-21 16:04:02 EST 
Also, please comment here with the the bug number filed against DTP.
Comment 5 Gursel Koca CLA 2011-01-24 03:54:23 EST 
Bug number against DTP is 335158.
Comment 6 Neil Hauge CLA 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 CLA 2011-07-01 16:23:12 EDT 
Moving JPA specific bugs to new JPA component in bugzilla.