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...@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 <rajeshr...@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 -
_______________________________________________ rules-users mailing list rules-users@lists.jboss.org https://lists.jboss.org/mailman/listinfo/rules-users
