Database schema version mismatch with demo files

[nickvargish]

Greetings,

Sorry if this is a newbie issue that has already been answered, I tried to search on my own and couldn't find anything that really helped. I'm trying to work my way through the examples in the book. When I get to section 1.4.2, "Implementing a simple book order process" and try to run the JUnit test, I get this hard failure:

SEVERE: Error while closing command context
org.activiti.engine.ActivitiWrongDbException: version mismatch: activiti library version is '5.9', db version is 5.10 Hint: Set <property name="databaseSchemaUpdate" to value="true" or value="create-drop" (use create-drop for testing only!) in bean processEngineConfiguration in activiti.cfg.xml for automatic schema creation

In the bpmn-examples project I set the "databaseSchemaUpdate" property to "true" in the activiti.cfg.xml, but I am still seeing this error.

The only version I have ever downloaded is 5.10, so I'm not sure where the 5.9 library is coming from, unless the version was not updated in the source package?

Activiti explorer is running, and I can query the database and see that the schema version is set to 5.10. I do not know how to manually set it to 5.9 (just to see if it works), since I'm not familiar with the H2 database – is there a command-line interface that I can use to issue "UPDATE" commands?

Again, sorry for the newbie questions. I'm not only new to Activiti, but I'm learning my way around Eclipse and Java at the same time… Thanks for any pointers you can provide that will get me back on track.

Nick

[rublar]

Hello,

you should change the version of activiti in the pom.xml

from:
<activiti-version>5.9</activiti-version>

to:
<activiti-version>5.10</activiti-version>

Cheers

[nickvargish]

you should change the version of activiti in the pom.xml
to:
<activiti-version>5.10</activiti-version>

That took care of it.

Thank you!

Nick

[andzoff]

I've got the same problem, so I'm upping this old thread.
For me is:

org.activiti.engine.ActivitiWrongDbException: version mismatch: activiti library version is '5.13', db version is 5.12 Hint: Set In the bpmn-examples project I set the "databaseSchemaUpdate" property to "true" in the activiti.cfg.xml, but I am still seeing this error.

In the [font=courier]pom.xml[/font] of my eclipse-activiti project (let me know if this is the correct file) I tried to correct the activiti version.
Neither 5.12 and 5.13 works.

What am I missing?
Any help vould be appreciated.
hanks.

[martin_grofcik]

From my point of view changing version in pom file won't help.

It seems that DB structures have version 5.12. Libraries which want to work with DB have version 5.13. This to things have to be sync.
Possibilities:
1. use 5.12 activiti libraries
2. upgrade DB structures to 5.13 (set property databaseSchemaUpdate to true in the activiti.cfg.xml which should update database automatically)

[philallred]

I'm having this trouble as well.  The current version of Activiti DB is 5.17, but the book source code is still at 5.9.  I tried setting databaseSchemaUpdate to true and to create-drop.  Neither helps.  Do I really have to go back to the 5.9 libraries.  Can't someone update the book's source code? I've been struggling with this for two days.

[jbarrez]

The book is now pretty old, I don't think it will follow any new versions of Activiti.

What are you trying to do and how is it failing?