topic Re: Is the Activiti QuickStart example not working or out of date in Alfresco Forum

Is the Activiti QuickStart example not working or out of date

matykiewicz — Wed, 25 Jan 2017 22:44:43 GMT

I am working through the QuickStart guide (Quick Start Guide | Activiti.org )and I get a runtime error. I did not see any issue in Jira. I thought I'd ask if someone can spot the error or give me a better quickstart. Here most of the info:The error (more detail below):Exception in thread "main" org.

Re: Is the Activiti QuickStart example not working or out of date

thuynh — Thu, 26 Jan 2017 10:49:16 GMT

Hi James Matykiewicz ,

The Activiti quick start guide is up to date and should work. It works for me.

It seems like there is something wrong during the DB creation process when the engine is created in your case. Looking at your pom.xml, I see you included the ibatis dependencies. You don't really need to do that. But that should not create any problem as well. So strange. Maybe you want to take them out and try again?

Thanks,

Thong Huynh

‌

Re: Is the Activiti QuickStart example not working or out of date

matykiewicz — Thu, 26 Jan 2017 22:40:54 GMT

Thanks Thong Huynh,

Yes, removing the ibatis dependency fixed the error. Now, as I work through other problems, I am stuck on this one:

- If I use the default JDBC URL of "mem", no ACT_ tables are created, so I get an error like this:

[main] DEBUG org.activiti.engine.impl.persistence.entity.PropertyEntity.selectDbSchemaVersion - ==> Preparing: select VALUE_ from ACT_GE_PROPERTY where NAME_ = 'schema.version'

[main] ERROR org.activiti.engine.impl.interceptor.CommandContext - Error while closing command context
org.activiti.engine.ActivitiException: no activiti tables in db. 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

Do I have to add the activiti.h2.xxx.yyy.sql files somewhere in the classpath?

I tried adding a activiti.cfg.xml to src/main/resources, but this did not fix the problem

I tried adding a db.properties file to src/main/resources, but this did not fix the problem

I tried changing the StandaloneProcessEngineConfiguration.setDatabaseSchema() to DB_SCHEMA_UPDATE_CREATE_TRUE in both the Java code and the activiti.cfg.xml which did not work either.

To me it looks like the activiti database schema is not being loaded, so ...

I started an external H2 database, changes the JDBC URL to use tcp://localhost/~/activiti, and I manually added the engine schema to this DB, now when I run the QuickStart application, I get a different 'no tables' problem and see an error showing I did not get the table name correct:

[main] DEBUG org.activiti.engine.impl.interceptor.LogInterceptor - --- SchemaOperationsProcessEngineBuild finished --------------------------------------------------------
[main] DEBUG org.activiti.engine.impl.interceptor.LogInterceptor -

Exception in thread "main" org.activiti.engine.ActivitiException: Activiti database problem: Tables missing for component(s) engine, history, identity
at org.activiti.engine.impl.db.DbSqlSession.dbSchemaCheckVersion(DbSqlSession.java:935)
at org.activiti.engine.impl.db.DbSqlSession.performSchemaOperationsProcessEngineBuild(DbSqlSession.java:1419)
at org.activiti.engine.impl.SchemaOperationsProcessEngineBuild.execute(SchemaOperationsProcessEngineBuild.java:27)

Re: Is the Activiti QuickStart example not working or out of date

thuynh — Fri, 27 Jan 2017 02:19:46 GMT

Hi James,

There are many different ways to invoke the Activiti process engine. The one being used in the guideline uses the StandaloneConfigure which is an extension of the ProcessEngineConfiguration. This will create the database tables when the engine is invoked. Your error logs show that no tables were created then the engine is started. So double check again in your main class to see if you have followed the instruction correctly at step 3.

public class OnboardingRequest { public static void main(String[] args) { ProcessEngineConfiguration cfg = new StandaloneProcessEngineConfiguration() .setJdbcUrl("jdbc:h2:mem:activiti;DB_CLOSE_DELAY=1000") .setJdbcUsername("sa") .setJdbcPassword("") .setJdbcDriver("org.h2.Driver") .setDatabaseSchemaUpdate(ProcessEngineConfiguration.DB_SCHEMA_UPDATE_TRUE); ProcessEngine processEngine = cfg.buildProcessEngine(); String pName = processEngine.getName(); String ver = ProcessEngine.VERSION; System.out.println("ProcessEngine [" + pName + "] Version: [" + ver + "]"); } }

Thanks,

Thong

‌

Re: Is the Activiti QuickStart example not working or out of date

matykiewicz — Sun, 29 Jan 2017 22:42:28 GMT

Thanks again Thong.

I am moving forward with deploying the download and using the GIT repo for

code. I was only trying to fix documentation issues. I still believe

there's a Spring configuration file or something not mentioned to point at

the SQL files. I will likely determine how the DB is created/updated as I

work through a complete deployment.

James

Re: Is the Activiti QuickStart example not working or out of date

thuynh — Tue, 31 Jan 2017 16:00:05 GMT

Sure thing ,

Let me know if you needs anymore help

Thanks,

Thong Huynh

‌