I already posted the solutions, I guess it is taking a while for it to show up :)<br><br><div class="gmail_quote">On Wed, Aug 26, 2009 at 9:54 AM, Kris Verlaenen <span dir="ltr"><<a href="mailto:kris.verlaenen@cs.kuleuven.be">kris.verlaenen@cs.kuleuven.be</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Sanjay,<br>
<br>
Didn't know Oracle still defines so much restrictions. Could you test<br>
which changes are required to make the mapping work in Oracle as well?<br>
You can easily change table and column names by adding the appropriate<br>
annotations in the corresponding Java classes:<br>
@Table(name = "xxx") for annotating the class<br>
@Column(name = "xxx") for annotating the getter<br>
<br>
If you would send me these changes, I will gladly check whether we could<br>
include them in the build so that it is possible to use Orable by<br>
default as well.<br>
<br>
Kris<br>
<div><div></div><div class="h5"><br>
Quoting SBalakrishnan <<a href="mailto:Sanjay.Balakrishnan@fnis.com">Sanjay.Balakrishnan@fnis.com</a>>:<br>
<br>
><br>
> Hi,<br>
><br>
> Pasted below are the problems, the whole list is in the attached<br>
> file<br>
> DroolsTableCreationErrorLog..txt (with my intial post).<br>
><br>
> Thanks again.<br>
><br>
> -Sanjay<br>
><br>
> SEVERE: Unsuccessful: create table Attachment (id number(19,0) not<br>
> null,<br>
> accessType number(10,0), attachedAt timestamp, attachmentContentId<br>
> number(19,0) not null, contentType varchar2(255 char), name<br>
> varchar2(255<br>
> char), size number(10,0) not null, attachedBy_id varchar2(255 char),<br>
> TaskData_Attachments_Id number(19,0), primary key (id))<br>
> Aug 25, 2009 3:21:40 PM org.hibernate.tool.hbm2ddl.SchemaExport<br>
> create<br>
> SEVERE: ORA-00904: : invalid identifier<br>
><br>
> Aug 25, 2009 3:21:40 PM org.hibernate.tool.hbm2ddl.SchemaExport<br>
> create<br>
> SEVERE: Unsuccessful: create table Comment (id number(19,0) not<br>
> null,<br>
> addedAt timestamp, text clob, addedBy_id varchar2(255 char),<br>
> TaskData_Comments_Id number(19,0), primary key (id))<br>
> Aug 25, 2009 3:21:40 PM org.hibernate.tool.hbm2ddl.SchemaExport<br>
> create<br>
> SEVERE: ORA-00903: invalid table name<br>
><br>
> Aug 25, 2009 3:21:41 PM org.hibernate.tool.hbm2ddl.SchemaExport<br>
> create<br>
> SEVERE: Unsuccessful: create table Deadline (id number(19,0) not<br>
> null, date<br>
> timestamp, escalated number(1,0) not null,<br>
> Deadlines_StartDeadLine_Id<br>
> number(19,0), Deadlines_EndDeadLine_Id number(19,0), primary key<br>
> (id))<br>
> Aug 25, 2009 3:21:41 PM org.hibernate.tool.hbm2ddl.SchemaExport<br>
> create<br>
> SEVERE: ORA-00904: : invalid identifier<br>
><br>
> Aug 25, 2009 3:21:41 PM org.hibernate.tool.hbm2ddl.SchemaExport<br>
> create<br>
> SEVERE: Unsuccessful: create table<br>
> Notification_BusinessAdministrators<br>
> (task_id number(19,0) not null, entity_id varchar2(255 char) not<br>
> null)<br>
> Aug 25, 2009 3:21:41 PM org.hibernate.tool.hbm2ddl.SchemaExport<br>
> create<br>
> SEVERE: ORA-00972: identifier is too long<br>
><br>
> Aug 25, 2009 3:21:41 PM org.hibernate.tool.hbm2ddl.SchemaExport<br>
> create<br>
> SEVERE: Unsuccessful: create table<br>
> Notification_EmailNotificationHeader<br>
> (Notification_id number(19,0) not null, emailHeaders_id number(19,0)<br>
> not<br>
> null, mapkey varchar2(255 char), primary key (Notification_id,<br>
> mapkey),<br>
> unique (emailHeaders_id))<br>
> Aug 25, 2009 3:21:41 PM org.hibernate.tool.hbm2ddl.SchemaExport<br>
> create<br>
> SEVERE: ORA-00972: identifier is too long<br>
><br>
> Aug 25, 2009 3:21:42 PM org.hibernate.tool.hbm2ddl.SchemaExport<br>
> create<br>
> SEVERE: Unsuccessful: create table<br>
> PeopleAssignments_BusinessAdministrators<br>
> (task_id number(19,0) not null, entity_id varchar2(255 char) not<br>
> null)<br>
> Aug 25, 2009 3:21:42 PM org.hibernate.tool.hbm2ddl.SchemaExport<br>
> create<br>
> SEVERE: ORA-00972: identifier is too long<br>
><br>
> Aug 25, 2009 3:21:42 PM org.hibernate.tool.hbm2ddl.SchemaExport<br>
> create<br>
> SEVERE: Unsuccessful: create table PeopleAssignments_ExcludedOwners<br>
> (task_id<br>
> number(19,0) not null, entity_id varchar2(255 char) not null)<br>
> Aug 25, 2009 3:21:42 PM org.hibernate.tool.hbm2ddl.SchemaExport<br>
> create<br>
> SEVERE: ORA-00972: identifier is too long<br>
><br>
> Aug 25, 2009 3:21:43 PM org.hibernate.tool.hbm2ddl.SchemaExport<br>
> create<br>
> SEVERE: Unsuccessful: create table PeopleAssignments_PotentialOwners<br>
> (task_id number(19,0) not null, entity_id varchar2(255 char) not<br>
> null)<br>
> Aug 25, 2009 3:21:43 PM org.hibernate.tool.hbm2ddl.SchemaExport<br>
> create<br>
> SEVERE: ORA-00972: identifier is too long<br>
><br>
> Aug 25, 2009 3:21:43 PM org.hibernate.tool.hbm2ddl.SchemaExport<br>
> create<br>
> SEVERE: Unsuccessful: create table<br>
> PeopleAssignments_TaskStakeholders<br>
> (task_id number(19,0) not null, entity_id varchar2(255 char) not<br>
> null)<br>
> Aug 25, 2009 3:21:43 PM org.hibernate.tool.hbm2ddl.SchemaExport<br>
> create<br>
> SEVERE: ORA-00972: identifier is too long<br>
><br>
><br>
><br>
><br>
> Mauricio Salatino wrote:<br>
> ><br>
> > Yes, I run it with postgreSQL and MySQL without problems..<br>
> > Can you post the problems here?<br>
> ><br>
> > On Tue, Aug 25, 2009 at 4:29 PM, SBalakrishnan<br>
> > <<a href="mailto:Sanjay.Balakrishnan@fnis.com">Sanjay.Balakrishnan@fnis.com</a><br>
> >> wrote:<br>
> ><br>
> >><br>
> >> Hi,<br>
> >><br>
> >> Eventually we plan to use oracle for persistence,<br>
> >> hence I pointed my persistence.xml (Human Task component) to an<br>
> Oracle<br>
> >> Database 10g instance<br>
> >> and immediately ran into<br>
> >> a number of critical issues (invalid identifiers,reserved names ,<br>
> and<br>
> >> identifier is too long etc.).<br>
> >><br>
> >><br>
> >> The logs are attached. Am I missing something ? Have others used<br>
> other<br>
> >> databases apart from the default (H2) ?<br>
> >><br>
> >><br>
> >> Thanks in advance<br>
> >><br>
> >> Sanjay<br>
> >><br>
> <a href="http://www.nabble.com/file/p25144010/DroolsTableCreationErrorLog..txt" target="_blank">http://www.nabble.com/file/p25144010/DroolsTableCreationErrorLog..txt</a><br>
> >> DroolsTableCreationErrorLog..txt<br>
> >> --<br>
> >> View this message in context:<br>
> >><br>
><br>
<a href="http://www.nabble.com/Running-into-Persistence-Issues-tp25144010p25144010.html" target="_blank">http://www.nabble.com/Running-into-Persistence-Issues-tp25144010p25144010.html</a><br>
> >> Sent from the drools - user mailing list archive at Nabble.com.<br>
> >><br>
> >> _______________________________________________<br>
> >> rules-users mailing list<br>
> >> <a href="mailto:rules-users@lists.jboss.org">rules-users@lists.jboss.org</a><br>
> >> <a href="https://lists.jboss.org/mailman/listinfo/rules-users" target="_blank">https://lists.jboss.org/mailman/listinfo/rules-users</a><br>
> >><br>
> ><br>
> ><br>
> ><br>
> > --<br>
> > - <a href="http://salaboy.wordpress.com" target="_blank">http://salaboy.wordpress.com</a><br>
> > - <a href="http://www.jbug.com.ar" target="_blank">http://www.jbug.com.ar</a><br>
> > - Salatino "Salaboy" Mauricio -<br>
> ><br>
> > _______________________________________________<br>
> > rules-users mailing list<br>
> > <a href="mailto:rules-users@lists.jboss.org">rules-users@lists.jboss.org</a><br>
> > <a href="https://lists.jboss.org/mailman/listinfo/rules-users" target="_blank">https://lists.jboss.org/mailman/listinfo/rules-users</a><br>
> ><br>
> ><br>
><br>
> --<br>
> View this message in context:<br>
><br>
<a href="http://www.nabble.com/Running-into-Persistence-Issues-tp25144010p25151160.html" target="_blank">http://www.nabble.com/Running-into-Persistence-Issues-tp25144010p25151160.html</a><br>
> Sent from the drools - user mailing list archive at Nabble.com.<br>
><br>
> _______________________________________________<br>
> rules-users mailing list<br>
> <a href="mailto:rules-users@lists.jboss.org">rules-users@lists.jboss.org</a><br>
> <a href="https://lists.jboss.org/mailman/listinfo/rules-users" target="_blank">https://lists.jboss.org/mailman/listinfo/rules-users</a><br>
><br>
<br>
<br>
<br>
<br>
</div></div>Disclaimer: <a href="http://www.kuleuven.be/cwis/email_disclaimer.htm" target="_blank">http://www.kuleuven.be/cwis/email_disclaimer.htm</a><br>
<div><div></div><div class="h5">_______________________________________________<br>
rules-users mailing list<br>
<a href="mailto:rules-users@lists.jboss.org">rules-users@lists.jboss.org</a><br>
<a href="https://lists.jboss.org/mailman/listinfo/rules-users" target="_blank">https://lists.jboss.org/mailman/listinfo/rules-users</a><br>
</div></div></blockquote></div><br>