dbSchemaUpadate=true java.lang.NullPointerException [FIXED]

luisalves00 — Tue, 16 Aug 2011 11:02:10 GMT

Is there any reason for this to happen:16-08-2011 10:29:37 Bootstrap [FATAL] Couldn't initialize Activiti Engine java.lang.NullPointerException at org.activiti.engine.impl.db.DbSqlSession.dbSchemaUpdate(DbSqlSession.java:620) at org.activiti.engine.impl.db.DbSqlSession.performSchemaOperationsPro

Re: dbSchemaUpadate=true java.lang.NullPointerException [FIXED]

frederikherema1 — Tue, 16 Aug 2011 11:08:17 GMT

What version of activiti are you using?

Re: dbSchemaUpadate=true java.lang.NullPointerException [FIXED]

luisalves00 — Tue, 16 Aug 2011 11:16:13 GMT

5.6… damn you're quick…

Re: dbSchemaUpadate=true java.lang.NullPointerException [FIXED]

frederikherema1 — Tue, 16 Aug 2011 11:17:02 GMT

Hmm.. can you post your full activiti-config?

Re: dbSchemaUpadate=true java.lang.NullPointerException [FIXED]

luisalves00 — Tue, 16 Aug 2011 11:20:42 GMT

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();
    }
  }

Re: dbSchemaUpadate=true java.lang.NullPointerException [FIXED]

luisalves00 — Tue, 16 Aug 2011 12:04:54 GMT

Sorry for wasting your time…

the problem is fixed.

Was a communication issue with the DBA. He created the tables (with no data) on the fresh schema…
Is possible to remove the thread?

topic Re: dbSchemaUpadate=true java.lang.NullPointerException [FIXED] in Alfresco Archive

dbSchemaUpadate=true java.lang.NullPointerException [FIXED]

Re: dbSchemaUpadate=true java.lang.NullPointerException [FIXED]

Re: dbSchemaUpadate=true java.lang.NullPointerException [FIXED]

Re: dbSchemaUpadate=true java.lang.NullPointerException [FIXED]

Re: dbSchemaUpadate=true java.lang.NullPointerException [FIXED]

Re: dbSchemaUpadate=true java.lang.NullPointerException [FIXED]