Using data source

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

spark2

I am trying to have basic setup of Activiti in web project deployed on WebSphere 7

I have "jdbc/dbsource" configured as Oracle data source and below is code for Process engine.
Data source test connection is successful.

      ProcessEngineConfiguration config = ProcessEngineConfiguration.createStandaloneProcessEngineConfiguration();
      config.setDatabaseSchemaUpdate("false");
      config.setJobExecutorActivate(true);
      config.setDatabaseType("oracle");
                config.setDataSourceJndiName("jdbc/dbsource");
                ProcessEngine p = config.buildProcessEngine();

               ….

However after initiating, I see in log files that it is taking default h2 database.
I do not have activiti.cfg.xml (I believe it is not required as all configuration is static as above)

What i am missing? How to tell activiti to use datasource and not default h2 database.

Thanks

frederikherema1

By setting the DataSourceJndiName, you tell activiti to use that to lookup the schema (relevant source in ProcesEngineConfigurationImpl):

<br> protected void initDataSource() {<br>&nbsp;&nbsp;&nbsp; if (dataSource==null) {<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if (dataSourceJndiName!=null) {<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; try {<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; dataSource = (DataSource) new InitialContext().lookup(dataSourceJndiName);<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; } catch (Exception e) {<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; throw new ActivitiException("couldn't lookup datasource from "+dataSourceJndiName+": "+e.getMessage(), e);<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }<br>
It will throw a message if the JNDI-name does not resolve to a correct datasource. Are you sure you're using the ProcessEngine instance that you built yourself (and not using ProcessEngines.getDefault())?