[rules-users] Drools Human Task Service Persistence

[Rui Tang]

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
>



-- 
唐睿
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/rules-users/attachments/20101124/87d65c04/attachment.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: orm-mapping-files.zip
Type: application/zip
Size: 20168 bytes
Desc: not available
Url : http://lists.jboss.org/pipermail/rules-users/attachments/20101124/87d65c04/attachment.zip