Description of problem: Every time jbpm-human-task.war is deployed it reads LoadGroups.mvel and LoadUsers.mvel files and add the users and groups to the task service session. This is no problem as long as hbm2ddl.auto=create and schema is re-created during deployment. However, when hbm2ddl.auto=update or hbm2ddl is turned off, the attempt to add the set of groups and users results in SQL exception (unique constraint broken). Currently those two files cannot be removed, because task service servlet requires they are present on classpath. My workaround is that they "return [:]", it should be possible to remove them completely. Version-Release number of selected component (if applicable): ER5 How reproducible: Steps to Reproduce: 1. 2. 3. Actual results: When task service is deployed (not for the first time and hbm2ddl is off), it fails with SQL exception, because it tries to add duplicate users and groups. The users and groups files cannot be simply removed. Expected results: Task service should start if the users and groups files are not present Additional info:
Pull request ready to allow clean management of user/group creation. https://github.com/droolsjbpm/jbpm/pull/77
Update status to ON_QA. Please verify them against ER6.
Verified in ER6. Due to this fix users and groups read from the users/groups files are no longer added to the task session if they already exist (warning is logged in that case). Additionally, the change introduced when fixing bug 800508 allows to use different users/groups files or to omit them completely by using empty init parameters load.users and load.groups. These two changes allow the task service to continue working with already populated database, e.g. after server restart. Thank you!