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(a)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(a)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(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/rules-users