[rules-users] Running into Persistence Issues

[SBalakrishnan]

Hi,

Pasted below are the problems, the whole list is in the attached file
DroolsTableCreationErrorLog..txt (with my intial post).

Thanks again.

-Sanjay

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))
Aug 25, 2009 3:21:40 PM org.hibernate.tool.hbm2ddl.SchemaExport create
SEVERE: ORA-00904: : invalid identifier

Aug 25, 2009 3:21:40 PM org.hibernate.tool.hbm2ddl.SchemaExport create
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))
Aug 25, 2009 3:21:40 PM org.hibernate.tool.hbm2ddl.SchemaExport create
SEVERE: ORA-00903: invalid table name

Aug 25, 2009 3:21:41 PM org.hibernate.tool.hbm2ddl.SchemaExport create
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))
Aug 25, 2009 3:21:41 PM org.hibernate.tool.hbm2ddl.SchemaExport create
SEVERE: ORA-00904: : invalid identifier

Aug 25, 2009 3:21:41 PM org.hibernate.tool.hbm2ddl.SchemaExport create
SEVERE: Unsuccessful: create table Notification_BusinessAdministrators
(task_id number(19,0) not null, entity_id varchar2(255 char) not null)
Aug 25, 2009 3:21:41 PM org.hibernate.tool.hbm2ddl.SchemaExport create
SEVERE: ORA-00972: identifier is too long

Aug 25, 2009 3:21:41 PM org.hibernate.tool.hbm2ddl.SchemaExport create
SEVERE: Unsuccessful: create table Notification_EmailNotificationHeader
(Notification_id number(19,0) not null, emailHeaders_id number(19,0) not
null, mapkey varchar2(255 char), primary key (Notification_id, mapkey),
unique (emailHeaders_id))
Aug 25, 2009 3:21:41 PM org.hibernate.tool.hbm2ddl.SchemaExport create
SEVERE: ORA-00972: identifier is too long

Aug 25, 2009 3:21:42 PM org.hibernate.tool.hbm2ddl.SchemaExport create
SEVERE: Unsuccessful: create table PeopleAssignments_BusinessAdministrators
(task_id number(19,0) not null, entity_id varchar2(255 char) not null)
Aug 25, 2009 3:21:42 PM org.hibernate.tool.hbm2ddl.SchemaExport create
SEVERE: ORA-00972: identifier is too long

Aug 25, 2009 3:21:42 PM org.hibernate.tool.hbm2ddl.SchemaExport create
SEVERE: Unsuccessful: create table PeopleAssignments_ExcludedOwners (task_id
number(19,0) not null, entity_id varchar2(255 char) not null)
Aug 25, 2009 3:21:42 PM org.hibernate.tool.hbm2ddl.SchemaExport create
SEVERE: ORA-00972: identifier is too long

Aug 25, 2009 3:21:43 PM org.hibernate.tool.hbm2ddl.SchemaExport create
SEVERE: Unsuccessful: create table PeopleAssignments_PotentialOwners
(task_id number(19,0) not null, entity_id varchar2(255 char) not null)
Aug 25, 2009 3:21:43 PM org.hibernate.tool.hbm2ddl.SchemaExport create
SEVERE: ORA-00972: identifier is too long

Aug 25, 2009 3:21:43 PM org.hibernate.tool.hbm2ddl.SchemaExport create
SEVERE: Unsuccessful: create table PeopleAssignments_TaskStakeholders
(task_id number(19,0) not null, entity_id varchar2(255 char) not null)
Aug 25, 2009 3:21:43 PM org.hibernate.tool.hbm2ddl.SchemaExport create
SEVERE: ORA-00972: identifier is too long




Mauricio Salatino wrote:
> 
> 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 at 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.html
>> Sent from the drools - user mailing list archive at Nabble.com.
>>
>> _______________________________________________
>> rules-users mailing list
>> rules-users at 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 at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/rules-users
> 
> 

-- 
View this message in context: http://www.nabble.com/Running-into-Persistence-Issues-tp25144010p25151160.html
Sent from the drools - user mailing list archive at Nabble.com.