Re: [rules-users] Running into Persistence Issues

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(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: >>

>> 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 > > -- View this message in context:

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