[jbosstools-issues] [JBoss JIRA] (JBIDE-26156) "forein key name ([name]) mapped to different tables!" reading schema to import the entities from db tables.

[Matt B (JIRA)]

    [ https://issues.jboss.org/browse/JBIDE-26156?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13600174#comment-13600174 ] 

Matt B commented on JBIDE-26156:
--------------------------------

CREATE TABLE "dbm"."TableA" (
	"Id" INTEGER NOT NULL,
	"Name" CHAR(20) NULL,
	PRIMARY KEY ( "Id" ASC )
) IN "system";
CREATE TABLE "dbm"."TableB" (
	"Id" INTEGER NOT NULL,
	"name" CHAR(20) NULL,
	"tableA" INTEGER NULL,
	PRIMARY KEY ( "Id" ASC )
) IN "system";
CREATE TABLE "dbm"."TableC" (
	"Id" INTEGER NOT NULL,
	"name" CHAR(20) NULL,
	"tableA" INTEGER NULL,
	PRIMARY KEY ( "Id" ASC )
) IN "system";
ALTER TABLE "dbm"."TableB" ADD CONSTRAINT "TableA" FOREIGN KEY ( "tableA" ASC ) REFERENCES "dbm"."TableA" ( "Id" ) ON UPDATE CASCADE;
ALTER TABLE "dbm"."TableC" ADD CONSTRAINT "TableA" FOREIGN KEY ( "tableA" ASC ) REFERENCES "dbm"."TableA" ( "Id" ) ON UPDATE CASCADE;

> "forein key name ([name]) mapped to different tables!" reading schema to import the entities from db tables.
> ------------------------------------------------------------------------------------------------------------
>
>                 Key: JBIDE-26156
>                 URL: https://issues.jboss.org/browse/JBIDE-26156
>             Project: Tools (JBoss Tools)
>          Issue Type: Bug
>          Components: hibernate
>    Affects Versions: 4.5.3.Final
>         Environment: Windows 8.1
> Eclipse  version: Oxygen.3a Release (4.7.3a)
> Jboss Tools 4.5.3.Final
> SAP Sql Anywhere v.17.0.8.4103
>            Reporter: Matt B
>            Assignee: Koen Aers
>            Priority: Critical
>
> Default name of sql anywhere's foreign key is the name of the destination table.
> If more tables link to same table, can be present di default more foreign key with same name.
> importing the entities from db tables do the error in subject
> Please manage this case.



--
This message was sent by Atlassian JIRA
(v7.5.0#75005)