[rules-users] Drools Flow Persistence Doubt

[Pardeep.Ruhil at lntinfotech.com]

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
> _________________




______________________________________________________________________
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/rules-users/attachments/20091008/c89ad504/attachment.html