My jbpm processes are made persistent with mysql. That works fine until i want to restore a session. That always fails although the session was stored correctly in the mysql database.
That is caused by a query that wasn't created rightly by hybernate:
Hibernate: select sessioninf0_.id as id39_0_, sessioninf0_.lastModificationDate as lastModi2_39_0_, sessioninf0_.rulesByteArray as rulesByt3_39_0_, sessioninf0_.startDate as startDate39_0_, sessioninf0_.OPTLOCK as OPTLOCK39_0_ from SessionInfo sessioninf0_ where sessioninf0_.id=?
As hibernate mysql dialect i use:
<property name="hibernate.dialect" value="org.hibernate.dialect.MySQL5InnoDBDialect" />
Thanks for your help.