Hi list,<br><br>I've finished to port ORM annotations to xml mapping files. And the Oracle is supported too. But all of these are not under full featured test, so this is the only snapshot for you.<br><br>I've changed rule flow related, task related and BAM related annotations. I can make sure that the creating table procedure is OK under MySQL 5.1 and Oracle 10g, but not for others.<br>
<br>According to some hibernate problems, the mapping files have some disadvantages:<br><br>1. When parsing the files, some warning logs will be printed. This is because hibernate is trying to make sure that all of these mapping attributes are public fields or methods. But some fields of the entities are not, for example version, env and so on. But this seems no harm.<br>
<br>2. According to some hibernate processing bugs (I guess), some table or field name cannot map correctly. One is in the class org.drools.task.EmailNotification, the one-to-many relationship to org.drools.task.EmailNotificationHeader cannot map correctly (There is a field named emailHeaders_KEY in table DRL5_NOTIFICATION_EMAILHEADERS). Another one is the org.drools.persistence.processinstance.ProcessInstanceInfo's eventTypes field (There is a table named ProcessInstanceInfo_eventTypes) . All of these names are set in mapping files but not reflected in database. I don't know how to resolve these, so leave it alone. But these should only impact the names not the functions.<br>
<br>The naming convention is straight. All of the tables are starting with DRL5_ and all fields are with F_.<br>
<br><div class="gmail_quote">On Fri, Nov 19, 2010 at 1:31 AM, drooRam <span dir="ltr"><<a href="mailto:rajeshram7@yahoo.com" target="_blank">rajeshram7@yahoo.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<br>
wait a minute, is it like no one ever tried persisting human task in oracle<br>
before?<br>
<br>
so far the support is only for H2 in memory db? i wonder how this made into<br>
production system then?<br>
<br>
honestly, its not criticism, just wanted to know how others are doing<br>
without persistence of task, of course DB is not only oracle, they might<br>
have used other DB as well.<br>
<br>
But it doesn't ring me a bell how custom status be implemented and how the<br>
named queries in org.drools.task be executed, lacking of proper docs and<br>
examples ..creating lot of chaos :-(<br>
<br>
So, you can't do persistence with oracle unless u have to override, if not<br>
oracle, what is the best bet DB (please don't say H2 :-) )<br>
<br>
-drooRam<br>
<font color="#888888"><br>
--<br>
View this message in context: <a href="http://drools-java-rules-engine.46999.n3.nabble.com/Drools-Human-Task-Service-Persistence-tp1868778p1925280.html" target="_blank">http://drools-java-rules-engine.46999.n3.nabble.com/Drools-Human-Task-Service-Persistence-tp1868778p1925280.html</a><br>
</font><div><div></div><div>Sent from the Drools - User mailing list archive at Nabble.com.<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>
</div></div></blockquote></div><br><br clear="all"><br>-- <br>唐睿<br>