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)