David Dupond
Posts: 1
Nickname: smix007
Registered: Nov, 2006
|
|
@JoinTable or @JoinColumn
|
Posted: Nov 7, 2006 1:17 AM
|
|
|
Advertisement
|
Hello.
as I still did not solve my problem, I will try to reformulate my question I want to make request EJB3 QL with joint.
here my tables:
code:
--------------------------------------------------------------- -----------------
CREATE TABLE `umlssnmi` (
`AUIS` varchar(20) NOT NULL default '',
`CUI` varchar(20) NOT NULL default '',
`CODE` varchar(20) NOT NULL default '',
`TTY` varchar(5) NOT NULL default '',
`STR` varchar(255) NOT NULL default '',
`HIER` varchar(255) NOT NULL default '',
`PROF` tinyint(2) NOT NULL default '0',
`AXE` char(1) NOT NULL default 'D',
PRIMARY KEY (`AUIS`),
KEY `CODE` (`CODE`),
KEY `TTY` (`TTY`),
KEY `CUI` (`CUI`),
KEY `AXE` (`AXE`))
TYPE=MyISAM;
code:
----------------------------------------------------------------------- ---------
CREATE TABLE `whoart` ( `AUIW` varchar(10) NOT NULL default '',
`CODE` varchar(10) NOT NULL default '',
`STR` varchar(255) NOT NULL default '',
`FSTR` varchar(255) NOT NULL default '',
`SOC` varchar(5) NOT NULL default '',
`SEMTYPE` varchar(5) NOT NULL default '',
`SRC` enum('WA','CIM') NOT NULL default 'WA',
PRIMARY KEY (`AUIW`),
KEY `SOC` (`SOC`),
KEY `CODE` (`CODE`))
TYPE=MyISAM;
---------------------------------------------------------------- ----------------
Knowing that I have the following table which has like clès primary both clès primary of the tables the preceding one.
code:
------------------------------------------------------------------ --------------
CREATE TABLE `wasnmi` (
`AUIW` varchar(20) NOT NULL default '',
`AUIS` varchar(20) NOT NULL default '',
`MODIF` varchar(10) default NULL,
`SRC` enum('S','MW','MS','MA') NOT NULL default 'S', PRIMARY KEY (`AUIW`,`AUIS`),
KEY `MOD` (`SRC`),
KEY `MODIF` (`MODIF`))
TYPE=MyISAM;
----------------------------------------------------------------------------- ---
knowing that cardinality between these tables and ManyToMany, my question and to know if so that I can make a join
between my tables I must create tables intermédiates which contain that the primary keys like umlssnmi_wasnmi kind
and whoart_wasnmi for example, and to make @JoinTable; or the table "wasnmi" will join the tables.
I thank you in advance
|
|
Previous Topic
