I am trying to generate an identifier generator class that provides the primary key for this table, and provide an <id ...> entry in .hbm.xml
for this table. Could someone please help?
create table iv_prs
( protocol_id varchar2(255),
CONSTRAINT iv_prs_pk PRIMARY KEY (protocol_id, version, protocol_id_num),
protocol_id_num varchar2(100),
protocol_name varchar2(255) CONSTRAINT iprs_protocolname_nn NOT NULL,
base_protocol varchar2(255),
description clob,
version varchar2(20),
xmlRep blob,
digest varchar2(100),
isActive varchar2(10),
release_version varchar2(10),
compilation_priority number(10),
TS date DEFAULT sysdate);
As the primary key spans 3 cols, I am wondering how to go about.
I appreciate any help that I can get.
Thanks,
Naga
|