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

[ram ram]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/rules-users/attachments/20100409/df4c41eb/attachment.html