I already posted the solutions, I guess it is taking a while for it to show up :)
On Wed, Aug 26, 2009 at 9:54 AM, Kris Verlaenen < [email protected]> wrote: > Sanjay, > > Didn't know Oracle still defines so much restrictions. Could you test > which changes are required to make the mapping work in Oracle as well? > You can easily change table and column names by adding the appropriate > annotations in the corresponding Java classes: > @Table(name = "xxx") for annotating the class > @Column(name = "xxx") for annotating the getter > > If you would send me these changes, I will gladly check whether we could > include them in the build so that it is possible to use Orable by > default as well. > > Kris > > Quoting SBalakrishnan <[email protected]>: > > > > > 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 > > > <[email protected] > > >> 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 > > >> [email protected] > > >> https://lists.jboss.org/mailman/listinfo/rules-users > > >> > > > > > > > > > > > > -- > > > - http://salaboy.wordpress.com > > > - http://www.jbug.com.ar > > > - Salatino "Salaboy" Mauricio - > > > > > > _______________________________________________ > > > rules-users mailing list > > > [email protected] > > > 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. > > > > _______________________________________________ > > rules-users mailing list > > [email protected] > > https://lists.jboss.org/mailman/listinfo/rules-users > > > > > > > Disclaimer: http://www.kuleuven.be/cwis/email_disclaimer.htm > _______________________________________________ > rules-users mailing list > [email protected] > https://lists.jboss.org/mailman/listinfo/rules-users >
_______________________________________________ rules-users mailing list [email protected] https://lists.jboss.org/mailman/listinfo/rules-users
