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 <[email protected]> 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 > > > [email protected] 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 <[email protected]> > > > > > > > > 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 > > [email protected] > > https://lists.jboss.org/mailman/listinfo/rules-users > > > _______________________________________________ > rules-users mailing list > [email protected] > https://lists.jboss.org/mailman/listinfo/rules-users > -- - http://salaboy.wordpress.com - http://www.jbug.com.ar - Salatino "Salaboy" Mauricio -
_______________________________________________ rules-users mailing list [email protected] https://lists.jboss.org/mailman/listinfo/rules-users
