need to add that I'm using programatic configuration…
e.g.
org.apache.commons.dbcp.BasicDataSource bds = new org.apache.commons.dbcp.BasicDataSource();
bds.setDefaultAutoCommit(false); //FIXME: make me configurable
bds.setUsername(ApplicationConfig.getEncryptedConfigParamDecrypted("activiti.username"));
bds.setPassword(ApplicationConfig.getEncryptedConfigParamDecrypted("activiti.password"));
bds.setDriverClassName(ApplicationConfig.getConfigParam("activiti.driverClassName"));
bds.setUrl(ApplicationConfig.getConfigParam("activiti.url"));
ProcessEngine processEngine = ProcessEngineConfiguration
.createStandaloneProcessEngineConfiguration()
.setDataSource(bds) .setJdbcMaxActiveConnections(Integer.parseInt(ApplicationConfig.getConfigParam("activiti.jdbcMaxActiveConnections")))
.setJdbcMaxIdleConnections(Integer.parseInt(ApplicationConfig.getConfigParam("activiti.jdbcMaxIdleConnections")))
.setDatabaseType(ApplicationConfig.getConfigParam("activiti.databaseType"))
.setDatabaseSchemaUpdate(ApplicationConfig.getConfigParam("activiti.databaseSchemaUpdate"))
.setHistory(ApplicationConfig.getConfigParam("activiti.history"))
.setProcessEngineName(ACTIVITI_ENGINE_NAME)
.setJobExecutorActivate(false) //FIXME: make me configurable
.buildProcessEngine();
ProcessEngines.registerProcessEngine(processEngine);
Trying to figure out what is happening in your code:
public void dbSchemaUpdate() {
String dbVersion = null;
boolean isUpgradeNeeded = false;
if (isEngineTablePresent()) {
// the next piece assumes both DB version and library versions are formatted 5.x
PropertyEntity dbVersionProperty = selectById(PropertyEntity.class, "schema.version");
dbVersion = dbVersionProperty.getValue();
isUpgradeNeeded = !ProcessEngine.VERSION.equals(dbVersion);
if (isUpgradeNeeded) {
dbVersionProperty.setValue(ProcessEngine.VERSION);
PropertyEntity dbHistoryProperty;
if ("5.0".equals(dbVersion)) {
dbHistoryProperty = new PropertyEntity("schema.history", "create(5.0)");
insert(dbHistoryProperty);
} else {
dbHistoryProperty = selectById(PropertyEntity.class, "schema.history");
}
String dbHistoryValue = dbHistoryProperty.getValue()+" upgrade("+dbVersion+"->"+ProcessEngine.VERSION+")";
dbHistoryProperty.setValue(dbHistoryValue);
dbSchemaUpgrade("engine", dbVersion);
}
} else {
dbSchemaCreateEngine();
}
if (isHistoryTablePresent()) {
if (isUpgradeNeeded) {
dbSchemaUpgrade("history", dbVersion);
}
} else if (dbSqlSessionFactory.isDbHistoryUsed()) {
dbSchemaCreateHistory();
}
if (isIdentityTablePresent()) {
if (isUpgradeNeeded) {
dbSchemaUpgrade("identity", dbVersion);
}
} else if (dbSqlSessionFactory.isDbIdentityUsed()) {
dbSchemaCreateIdentity();
}
if (isCycleTablePresent()) {
if (isUpgradeNeeded) {
dbSchemaUpgrade("cycle", dbVersion);
}
} else if (dbSqlSessionFactory.isDbCycleUsed()) {
dbSchemaCreateCycle();
}
}
