Thanks for the responses.
Is there a way we could achieve the same (Java class annotations),
with changes to the JPA mapping file only(orm.xml),without code changes.
Thanks
Sanjay
Kris Verlaenen 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(a)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(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
> >
> >
>
> --
> View this message in context:
>
http://www.nabble.com/Running-into-Persistence-Issues-tp25144010p25151160...
> 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
>
Disclaimer:
http://www.kuleuven.be/cwis/email_disclaimer.htm
_______________________________________________
rules-users mailing list
rules-users(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/rules-users