This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 244552 - MSSQL entity wizard
Summary: MSSQL entity wizard
Status: RESOLVED INCOMPLETE
Alias: None
Product: db
Classification: Unclassified
Component: Code (show other bugs)
Version: 8.0
Hardware: PC Windows 7
: P3 normal (vote)
Assignee: Libor Fischmeistr
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-05-16 15:33 UTC by stuartbrand
Modified: 2014-05-30 07:56 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description stuartbrand 2014-05-16 15:33:31 UTC
There have been many users complaining of the "Netbeans hangs when load entities from MS SQL Server"

I'v found what's doing it!

The problem is when a view contains(joins) another view. Netbeans is trying to retrieve the keys but it causes it to lock up. it happens on all version of netbeans, however it could be the SQL driver causing the problem?

below is an example of what locks and below that is the view removed that works

SELECT  *
FROM            dbo.TableTimetables INNER JOIN
                         dbo.ViewGroupsFull ON dbo.TableTimetables.groupId = dbo.ViewGroupsFull.id


SELECT *
FROM            dbo.TableTimetables


Product Version = NetBeans IDE 8.0 (Build 201403101706)
Operating System = Windows 7 version 6.1 running on amd64
Java; VM; Vendor = 1.7.0_51
Runtime = Java HotSpot(TM) 64-Bit Server VM 24.51-b03
Comment 1 matthias42 2014-05-21 19:20:06 UTC
Could you please provide a minimal schema, that reproduces the problem? From your description I understood your description as this (simplified):

----------------------------------------

drop view ViewGroupsFull;
drop view demo;
drop table TableGroupInfos;
drop table TableTimetables;
drop table TableGroups;
create table TableGroups (
    groupId int primary key, 
    title varchar(255)
);
create table TableGroupInfos (
    tableGroupInfoId int primary key, 
    groupId int references TableGroups(groupId), 
    info1 varchar(20), 
    info2 varchar(255)
); 
create table TableTimetables (
    timeTableId int primary key,
    title varchar(255), 
    groupId int references TableGroups(groupId)
);
create view ViewGroupsFull as 
    select tg.title as groupName, 
           tgi.info1 as info1,
           tgi.info2 as info2,
           tg.groupId as id
    from TableGroups tg
    left join TableGroupInfos tgi ON (tgi.groupId = tg.groupId);
create view demo as 
    SELECT  *
    FROM dbo.TableTimetables 
    INNER JOIN dbo.ViewGroupsFull ON dbo.TableTimetables.groupId = dbo.ViewGroupsFull.id;

----------------------------------------

This does not reproduce the problem (I can generate entities from this).

Could you please check, that the problem is still there in netbeans 8? There was a fix committed for netbeans 8 - please check bug #239181.