For this error<br><br><pre>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))<br>
</pre>The column <i>size </i>is not a valid name. Size is a reserved word in oracle.<br><br><pre>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))<br>
</pre>The column <i>date</i> is not a valid name. Date is a resereved word in oracle.<br><br><pre>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))<br>
<br></pre>Comment is a reserved word in oracle. The table name will need to be changed.<br><br><pre>SEVERE: Unsuccessful: create table Notification_BusinessAdministrators (task_id number(19,0) not null, entity_id varchar2(255 char) not null)<br>
</pre>The table named Notification_BusinessAdministrators is too long. Needs to be at most 30 chars. <br><br>Same thing for the following tables<br><ul><li>Notification_EmailNotificationHeader</li><li>PeopleAssignments_BusinessAdministrators</li>
<li>PeopleAssignments_ExcludedOwners</li><li>PeopleAssignments_PotentialOwners</li><li>PeopleAssignments_TaskStakeholders</li></ul>Fixing these should resolve the problem.<br><br><div class="gmail_quote">2009/8/25 Mauricio Salatino <span dir="ltr"><<a href="mailto:salaboy@gmail.com">salaboy@gmail.com</a>></span><br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Yes, I run it with postgreSQL and MySQL without problems..<br>Can you post the problems here?<div>
<div></div><div class="h5"><br><br><div class="gmail_quote">On Tue, Aug 25, 2009 at 4:29 PM, SBalakrishnan <span dir="ltr"><<a href="mailto:Sanjay.Balakrishnan@fnis.com" target="_blank">Sanjay.Balakrishnan@fnis.com</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;"><br>
Hi,<br>
<br>
Eventually we plan to use oracle for persistence,<br>
hence I pointed my persistence.xml (Human Task component) to an Oracle<br>
Database 10g instance<br>
and immediately ran into<br>
a number of critical issues (invalid identifiers,reserved names , and<br>
identifier is too long etc.).<br>
<br>
<br>
The logs are attached. Am I missing something ? Have others used other<br>
databases apart from the default (H2) ?<br>
<br>
<br>
Thanks in advance<br>
<br>
Sanjay<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>
<font color="#888888">--<br>
View this message in context: <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" target="_blank">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>
</font></blockquote></div><br><br clear="all"><br></div></div><font color="#888888">-- <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>
</font><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></blockquote></div><br>