ode-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Toha Bakanovsky <im-scoo...@yandex.ru>
Subject 1.-SNAPSHOT Hibernate mapping
Date Fri, 13 Apr 2012 19:51:13 GMT

Module hibernate-dao-db generates invlid Oracle DDL script.

create table BPEL_XML_DATA (ID number(19,0) not null, DATA blob(2G),
NAME varchar2(255 char) not null, SIMPLE_VALUE varchar2(255 char),
SCOPE_ID number(19,0), PIID number(19,0), IS_SIMPLE_TYPE number(1,0),
INSERT_TIME timestamp, MLOCK number(10,0) not null, primary key (ID));

Oracle doesn't support blob(2G) syntax. To avoid this error it is
necessary to fix type declarations in hibernate annotations from
sql-type="blob(2G)" to type=materialized_blob(2147483647).
Also, there is invalid script
create table BPEL_MEX_PROPS (MEX number(19,0) not null, VALUE long, NAME
varchar2(255 char) not null, primary key (MEX, NAME));
In mapping column VALUE is a part of composite-id and has type "string" (!)

Best regards.

View raw message