I am trying to use drools to evaluate the following rule: Given a telephone number, if the telephone number already exists in database and has a balance > 0, set isAllowed = false. Looking at forum posts I understand that this can be achieved using hibernate and 'from' keyword. However, this is my current scenario - I create a package snapshot for my rules in Guvnor and use the URL in Drools execution server. Execution server runs only stateless sessions. Where and how do I use hibernate named queries?

Thx, Anu

Could you do the same thing with an entity manager?

Earnie! ------------------------------------------------------------------------ *From:* Mark Proctor <mproctor(a)codehaus.org&gt; *To:* Rules Users List <rules-users(a)lists.jboss.org&gt; *Sent:* Friday, March 27, 2009 2:09:19 PM *Subject:* Re: [rules-users] Guvnor and 'from' database Anu@work wrote: > I am trying to use drools to evaluate the following rule: > > Given a telephone number, if the telephone number already exists in database > and has a balance > 0, set isAllowed = false. > Looking at forum posts I understand that this can be achieved using > hibernate and 'from' keyword. However, this is my current scenario - I > create a package snapshot for my rules in Guvnor and use the URL in Drools > execution server. Execution server runs only stateless sessions. > Where and how do I use hibernate named queries? set the hibernate session as a global and then the 'from' can access it. > Thx, > Anu > > > _______________________________________________ rules-users mailing list rules-users(a)lists.jboss.org <mailto:rules-users@lists.jboss.org> https://lists.jboss.org/mailman/listinfo/rules-users ------------------------------------------------------------------------ _______________________________________________ rules-users mailing list rules-users(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/rules-users

Thx. Figured that part and I did that in the source code of the execution server on a particular XML value coming from client. I suppose now I have to put hibernate in Guvnor's classpath, declare a global variable in the package configuration and then use it in a rule. One thing I cannot figure out is where to put the hibernate xml config file in guvnor. Can you help? Thx Mark Proctor wrote: > > Anu@work wrote: >> I am trying to use drools to evaluate the following rule: >> >> Given a telephone number, if the telephone number already exists in >> database >> and has a balance > 0, set isAllowed = false. >> >> Looking at forum posts I understand that this can be achieved using >> hibernate and 'from' keyword. However, this is my current scenario - I >> create a package snapshot for my rules in Guvnor and use the URL in >> Drools >> execution server. Execution server runs only stateless sessions. >> >> Where and how do I use hibernate named queries? >> > set the hibernate session as a global and then the 'from' can access it. >> Thx, >> Anu >> >> >> > > > _______________________________________________ > rules-users mailing list > rules-users(a)lists.jboss.org > https://lists.jboss.org/mailman/listinfo/rules-users > > -- View this message in context: http://www.nabble.com/Guvnor-and-%27from%27-database-tp22745198p22747661.... Sent from the drools - user mailing list archive at Nabble.com. _______________________________________________ rules-users mailing list rules-users(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/rules-users