For this error
SEVERE: Unsuccessful: create table Attachment (id number(19,0) not
null, accessType number(10,0), attachedAt timestamp,
attachmentContentId number(19,0) not null, contentType varchar2(255
char), name varchar2(255 char), size number(10,0) not null,
attachedBy_id varchar2(255 char), TaskData_Attachments_Id
number(19,0), primary key (id))
The column *size *is not a valid name. Size is a reserved word in oracle.
SEVERE: Unsuccessful: create table Deadline (id number(19,0) not null,
date timestamp, escalated number(1,0) not null,
Deadlines_StartDeadLine_Id number(19,0), Deadlines_EndDeadLine_Id
number(19,0), primary key (id))
The column *date* is not a valid name. Date is a resereved word in oracle.
SEVERE: Unsuccessful: create table Comment (id number(19,0) not null,
addedAt timestamp, text clob, addedBy_id varchar2(255 char),
TaskData_Comments_Id number(19,0), primary key (id))
Comment is a reserved word in oracle. The table name will need to be
changed.
SEVERE: Unsuccessful: create table Notification_BusinessAdministrators
(task_id number(19,0) not null, entity_id varchar2(255 char) not null)
The table named Notification_BusinessAdministrators is too long. Needs to be
at most 30 chars.
Same thing for the following tables
- Notification_EmailNotificationHeader
- PeopleAssignments_BusinessAdministrators
- PeopleAssignments_ExcludedOwners
- PeopleAssignments_PotentialOwners
- PeopleAssignments_TaskStakeholders
Fixing these should resolve the problem.
2009/8/25 Mauricio Salatino <salaboy(a)gmail.com>
Yes, I run it with postgreSQL and MySQL without problems..
Can you post the problems here?
On Tue, Aug 25, 2009 at 4:29 PM, SBalakrishnan <
Sanjay.Balakrishnan(a)fnis.com> wrote:
>
> Hi,
>
> Eventually we plan to use oracle for persistence,
> hence I pointed my persistence.xml (Human Task component) to an Oracle
> Database 10g instance
> and immediately ran into
> a number of critical issues (invalid identifiers,reserved names , and
> identifier is too long etc.).
>
>
> The logs are attached. Am I missing something ? Have others used other
> databases apart from the default (H2) ?
>
>
> Thanks in advance
>
> Sanjay
>
http://www.nabble.com/file/p25144010/DroolsTableCreationErrorLog..txt
> DroolsTableCreationErrorLog..txt
> --
> View this message in context:
>
http://www.nabble.com/Running-into-Persistence-Issues-tp25144010p25144010...
> Sent from the drools - user mailing list archive at
Nabble.com.
>
> _______________________________________________
> rules-users mailing list
> rules-users(a)lists.jboss.org
>
https://lists.jboss.org/mailman/listinfo/rules-users
>
--
-
http://salaboy.wordpress.com
-
http://www.jbug.com.ar
- Salatino "Salaboy" Mauricio -
_______________________________________________
rules-users mailing list
rules-users(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/rules-users