[jboss-user] [jBPM] - Strange behavior with jbpm and mysql

hansi007 [https://community.jboss.org/people/hansi007] created the discussion "Strange behavior with jbpm and mysql" To view the discussion, visit: https://community.jboss.org/message/735230#735230 -------------------------------------------------------------- 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.* * -------------------------------------------------------------- Reply to this message by going to Community [https://community.jboss.org/message/735230#735230] Start a new discussion in jBPM at Community [https://community.jboss.org/choose-container!input.jspa?contentType=1&...]