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

[hansi007]

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&containerType=14&container=2034]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20120513/4308244d/attachment.html