[rules-users] Drools Flow Persistence Doubt

[Jesper S. Knudsen]

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