Hi! 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.
