[rules-users] Running into Persistence Issues

Wed Aug 26 10:06:24 EDT 2009

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 <
kris.verlaenen at cs.kuleuven.be> 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 <Sanjay.Balakrishnan at fnis.com>:
>
> >
> > 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.
> >
> > _______________________________________________
> > rules-users mailing list
> > rules-users at lists.jboss.org
> > https://lists.jboss.org/mailman/listinfo/rules-users
> >
>
>
>
>
> Disclaimer: http://www.kuleuven.be/cwis/email_disclaimer.htm
> _______________________________________________
> rules-users mailing list
> rules-users at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/rules-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/rules-users/attachments/20090826/115c0d47/attachment.html 