Re: [rules-users] Error When changing persistence from H2 to Oracle forTaskService

Hi Kris, This is the list of errors that I have when trying to persist the TaskService to Oracle. I applied mapping to them but if the column names and table names are fixed it would be great. Please can you notify me once the changes are applied so that I can run a test on them. -- size column name -- create table Attachment (id number(19,0) not null, name varchar2(255), accessType number(10,0), contentType varchar2(255), attachedAt date, size number(10,0) not null, attachmentContentId number(19,0) not null, attachedBy_id varchar2(255), TaskData_Attachments_Id number(19,0), primary key (id)) -- table name reserved in oracle -- create table Comment (id number(19,0) not null, text clob, addedAt date, addedBy_id varchar2(255), TaskData_Comments_Id number(19,0), primary key (id)) -- date column name problem -- create table Deadline (id number(19,0) not null, date date, escalated number(1,0) not null, Deadlines_EndDeadLine_Id number(19,0), Deadlines_StartDeadLine_Id number(19,0), primary key (id)) -- date problem -- name is long -- create table Notification_BusinessAdministrators (task_id number(19,0) not null, entity_id varchar2(255) not null) create table Notification_EmailNotificationHeader (Notification_id number(19,0) not null, emailHeaders_id number(19,0) not null, mapkey varchar2(255), primary key (Notification_id, mapkey), unique (emailHeaders_id)) create table PeopleAssignments_BusinessAdministrators (task_id number(19,0) not null, entity_id varchar2(255) not null) create table PeopleAssignments_ExcludedOwners (task_id number(19,0) not null, entity_id varchar2(255) not null) create table PeopleAssignments_PotentialOwners (task_id number(19,0) not null, entity_id varchar2(255) not null) create table PeopleAssignments_TaskStakeholders (task_id number(19,0) not null, entity_id varchar2(255) not null) Regards, Ram