[rules-users] Drools Flow Persistence Doubt

[Mauricio Salatino]

yes... the problem is that you don't need that query.
I don't know why I include it.. Do you need it for some reason?
I will test it asap and get back to you..

On Thu, Oct 8, 2009 at 11:46 AM, Jesper S. Knudsen <jsk at orwtech.dk> wrote:

> Hi Pardeep
>
> I think you are using the wrong syntax in your QL
> Should it not be:
>
> select object(v) from VariableInstanceInfo as v where
> v.processInstanceInfo.id = :processId
>
> like in ejbql?
>
> Best regards
>
> Jesper
>
>
> Pardeep.Ruhil at lntinfotech.com skrev:
> >
> > Hi Mauricio,
> > Thanks for your reply.
> > When I try to run the demo project with configuration  to work with
> Mysql, I got this exception when I uncommented the  the named-query in
> orm.xml
> > </query>
> > select
> >     v
> > from
> >     VariableInstanceInfo v
> > where
> >     v.processInstanceInfo.id = :processId
> >           </query>
> >
> > SEVERE: Error in named query: VariableInstancesInfoByProcessId
> > org.hibernate.QueryException: could not resolve property:
> processInstanceInfo of:
> org.drools.persistence.processinstance.variabletypes.VariableInstanceInfo
> [select v from
> org.drools.persistence.processinstance.variabletypes.VariableInstanceInfo
> v where v.processInstanceInfo.id = :processId]
> >         at
>
> org.hibernate.persister.entity.AbstractPropertyMapping.propertyException(AbstractPropertyMapping.java:67)
> >         at
>
> org.hibernate.persister.entity.AbstractPropertyMapping.toType(AbstractPropertyMapping.java:61)
> >         at
>
> org.hibernate.persister.entity.AbstractEntityPersister.toType(AbstractEntityPersister.java:1385)
> >         at
>
> org.hibernate.hql.ast.tree.FromElementType.getPropertyType(FromElementType.java:302)
> >
> > Please help me resolve to this exception.
> > Am i doing something wrong?
> >
> > Thanks & Regards
> >
> > Pardeep Ruhil
> >
> >
> >
> > if you take a look at this post:
> > http://blog.athico.com/2009/09/drools-flow-variable-persistence.html
> >
> > you will see that there is a demo project with the configuration to work
> > with MySQL.
> > Greetings.
> >
> > 2009/10/7 <Pardeep.Ruhil at lntinfotech.com>
> >
> > >
> > > Hi,
> > > I have doubt regarding persistence in Drools.
> > > I read the documentation of persistence in Drools Flow and got to know
> that
> > > it uses hibernate with H2 database as default.
> > > My doubt is if I want to use Mysql database, then I want to know which
> are
> > > the tables that I need to create in the database or
> > > Is their any code written which automatically creates the tables in the
> > > schema in Mysql database.
> > >
> > > Also is their any document present for configuring Mysql database.
> > > Please help me to get through the situation.
> > >
> > > Thanks & Regards
> > >
> > > Pardeep Ruhil
> > > _________________
> >
> >
> >
> > ______________________________________________________________________
> >
> >
> > _______________________________________________
> > 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
>



-- 
- http://salaboy.wordpress.com
- http://www.jbug.com.ar
- Salatino "Salaboy" Mauricio -
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/rules-users/attachments/20091008/9be1062a/attachment.html