<br><font size=2 face="Trebuchet MS">Hi Mauricio,</font>
<br><font size=2 face="Trebuchet MS">Thanks for your reply. </font>
<br><font size=2 face="Trebuchet MS">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</font>
<br><font size=2 color=#008080 face="Courier New"></</font><font size=2 color=#3f8080 face="Courier New">query</font><font size=2 color=#008080 face="Courier New">></font>
<br><font size=2 face="Courier New">select</font>
<br><font size=2 face="Courier New"> v</font>
<br><font size=2 face="Courier New">from</font>
<br><font size=2 face="Courier New"> VariableInstanceInfo
v</font>
<br><font size=2 face="Courier New">where</font>
<br><font size=2 face="Courier New"> v.processInstanceInfo.id
= :processId</font>
<br><font size=2 face="Courier New">
</font><font size=2 color=#008080 face="Courier New"></</font><font size=2 color=#3f8080 face="Courier New">query</font><font size=2 color=#008080 face="Courier New">></font>
<br>
<br><font size=2 color=red face="Courier New">SEVERE: Error in named query:
VariableInstancesInfoByProcessId</font>
<br><font size=2 color=#000080 face="Courier New"><u>org.hibernate.QueryException</u></font><font size=2 color=red face="Courier New">:
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]</font>
<br><font size=2 color=red face="Courier New">
at org.hibernate.persister.entity.AbstractPropertyMapping.propertyException(</font><font size=2 color=#000080 face="Courier New"><u>AbstractPropertyMapping.java:67</u></font><font size=2 color=red face="Courier New">)</font>
<br><font size=2 color=red face="Courier New">
at org.hibernate.persister.entity.AbstractPropertyMapping.toType(</font><font size=2 color=#000080 face="Courier New"><u>AbstractPropertyMapping.java:61</u></font><font size=2 color=red face="Courier New">)</font>
<br><font size=2 color=red face="Courier New">
at org.hibernate.persister.entity.AbstractEntityPersister.toType(</font><font size=2 color=#000080 face="Courier New"><u>AbstractEntityPersister.java:1385</u></font><font size=2 color=red face="Courier New">)</font>
<br><font size=2 color=red face="Courier New">
at org.hibernate.hql.ast.tree.FromElementType.getPropertyType(</font><font size=2 color=#000080 face="Courier New"><u>FromElementType.java:302</u></font><font size=2 color=red face="Courier New">)</font>
<br>
<br><font size=2 face="Trebuchet MS">Please help me resolve to this exception.</font>
<br><font size=2 face="Trebuchet MS">Am i doing something wrong?</font>
<br>
<br><font size=2 face="Trebuchet MS">Thanks & Regards<br>
<br>
Pardeep Ruhil</font>
<br>
<br>
<br><tt><font size=2><br>
if you take a look at this post:<br>
http://blog.athico.com/2009/09/drools-flow-variable-persistence.html<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 <Pardeep.Ruhil@lntinfotech.com><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 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
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>
> _________________</font></tt>
<br>
<br><font size=2 face="Trebuchet MS"><br>
</font>
<BR>
______________________________________________________________________<BR>