2010/11/24 Rui Tang <tangrui.cn@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@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@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/rules-users

--
唐睿

_______________________________________________
rules-users mailing list
rules-users@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 -