yes... the problem is that you don't need that query. <br>I don't know why I include it.. Do you need it for some reason?<br>I will test it asap and get back to you..<br><br><div class="gmail_quote">On Thu, Oct 8, 2009 at 11:46 AM, Jesper S. Knudsen <span dir="ltr"><<a href="mailto:jsk@orwtech.dk">jsk@orwtech.dk</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Hi Pardeep<br>
<br>
I think you are using the wrong syntax in your QL<br>
Should it not be:<br>
<br>
select object(v) from VariableInstanceInfo as v where<br>
<a href="http://v.processInstanceInfo.id" target="_blank">v.processInstanceInfo.id</a> = :processId<br>
<br>
like in ejbql?<br>
<br>
Best regards<br>
<br>
Jesper<br>
<br>
<br>
<a href="mailto:Pardeep.Ruhil@lntinfotech.com">Pardeep.Ruhil@lntinfotech.com</a> skrev:<br>
<div><div></div><div class="h5">><br>
> Hi Mauricio,<br>
> Thanks for your reply.<br>
> When I try to run the demo project with configuration to work with<br>
Mysql, I got this exception when I uncommented the the named-query in<br>
orm.xml<br>
> </query><br>
> select<br>
> v<br>
> from<br>
> VariableInstanceInfo v<br>
> where<br>
> <a href="http://v.processInstanceInfo.id" target="_blank">v.processInstanceInfo.id</a> = :processId<br>
> </query><br>
><br>
> SEVERE: Error in named query: VariableInstancesInfoByProcessId<br>
> org.hibernate.QueryException: could not resolve property:<br>
processInstanceInfo of:<br>
org.drools.persistence.processinstance.variabletypes.VariableInstanceInfo<br>
[select v from<br>
org.drools.persistence.processinstance.variabletypes.VariableInstanceInfo<br>
v where <a href="http://v.processInstanceInfo.id" target="_blank">v.processInstanceInfo.id</a> = :processId]<br>
> at<br>
org.hibernate.persister.entity.AbstractPropertyMapping.propertyException(AbstractPropertyMapping.java:67)<br>
> at<br>
org.hibernate.persister.entity.AbstractPropertyMapping.toType(AbstractPropertyMapping.java:61)<br>
> at<br>
org.hibernate.persister.entity.AbstractEntityPersister.toType(AbstractEntityPersister.java:1385)<br>
> at<br>
org.hibernate.hql.ast.tree.FromElementType.getPropertyType(FromElementType.java:302)<br>
><br>
> Please help me resolve to this exception.<br>
> Am i doing something wrong?<br>
><br>
> Thanks & Regards<br>
><br>
> Pardeep Ruhil<br>
><br>
><br>
><br>
> if you take a look at this post:<br>
> <a href="http://blog.athico.com/2009/09/drools-flow-variable-persistence.html" target="_blank">http://blog.athico.com/2009/09/drools-flow-variable-persistence.html</a><br>
><br>
> you will see that there is a demo project with the configuration to work<br>
> with MySQL.<br>
> Greetings.<br>
><br>
> 2009/10/7 <<a href="mailto:Pardeep.Ruhil@lntinfotech.com">Pardeep.Ruhil@lntinfotech.com</a>><br>
><br>
> ><br>
> > Hi,<br>
> > I have doubt regarding persistence in Drools.<br>
> > I read the documentation of persistence in Drools Flow and got to know<br>
that<br>
> > it uses hibernate with H2 database as default.<br>
> > My doubt is if I want to use Mysql database, then I want to know which<br>
are<br>
> > the tables that I need to create in the database or<br>
> > Is their any code written which automatically creates the tables in the<br>
> > schema in Mysql database.<br>
> ><br>
> > Also is their any document present for configuring Mysql database.<br>
> > Please help me to get through the situation.<br>
> ><br>
> > Thanks & Regards<br>
> ><br>
> > Pardeep Ruhil<br>
> > _________________<br>
><br>
><br>
><br>
> ______________________________________________________________________<br>
><br>
><br>
</div></div><div><div></div><div class="h5">> _______________________________________________<br>
> rules-users mailing list<br>
> <a href="mailto:rules-users@lists.jboss.org">rules-users@lists.jboss.org</a><br>
> <a href="https://lists.jboss.org/mailman/listinfo/rules-users" target="_blank">https://lists.jboss.org/mailman/listinfo/rules-users</a><br>
<br>
<br>
_______________________________________________<br>
rules-users mailing list<br>
<a href="mailto:rules-users@lists.jboss.org">rules-users@lists.jboss.org</a><br>
<a href="https://lists.jboss.org/mailman/listinfo/rules-users" target="_blank">https://lists.jboss.org/mailman/listinfo/rules-users</a><br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br> - <a href="http://salaboy.wordpress.com">http://salaboy.wordpress.com</a><br> - <a href="http://www.jbug.com.ar">http://www.jbug.com.ar</a><br> - Salatino "Salaboy" Mauricio -<br>