[rules-users] Drools Human Task Service Persistence

[Mauricio Salatino]

Great Job!
@Kris: can we include this in drools-persistence-jpa? as an external bundle?
would be nice to have a place to store all the community contribution about
mappings for different databases.


2010/11/24 Rui Tang <tangrui.cn at gmail.com>

> Hi list,
>
> 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.
>
> 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.
>
> According to some hibernate problems, the mapping files have some
> disadvantages:
>
> 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.
>
> 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.
>
> The naming convention is straight. All of the tables are starting with
> DRL5_ and all fields are with F_.
>
>
> On Fri, Nov 19, 2010 at 1:31 AM, drooRam <rajeshram7 at yahoo.com> wrote:
>
>>
>> wait a minute, is it like no one ever tried persisting human task in
>> oracle
>> before?
>>
>> so far the support is only for H2 in memory db? i wonder how this made
>> into
>> production system then?
>>
>> honestly, its not criticism, just wanted to know how others are doing
>> without persistence of task, of course DB is not only oracle, they might
>> have used other DB as well.
>>
>> But it doesn't ring me a bell how custom status be implemented and how the
>> named queries in org.drools.task be executed, lacking of proper docs and
>> examples ..creating lot of chaos :-(
>>
>> So, you can't do persistence with oracle unless u have to override, if not
>> oracle, what is the best bet DB (please don't say H2 :-) )
>>
>> -drooRam
>>
>> --
>> View this message in context:
>> http://drools-java-rules-engine.46999.n3.nabble.com/Drools-Human-Task-Service-Persistence-tp1868778p1925280.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
>>
>
>
>
> --
> 唐睿
>
> _______________________________________________
> rules-users mailing list
> rules-users at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/rules-users
>
>


-- 
 - CTO @ http://www.plugtree.com
 - MyJourney @ http://salaboy.wordpress.com
 - Co-Founder @ http://www.jbug.com.ar

 - Salatino "Salaboy" Mauricio -
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/rules-users/attachments/20101124/b74ddee5/attachment.html