topic Re: Activit without Spring in Alfresco Archive

Activit without Spring

omni_ok — Wed, 26 Feb 2014 07:07:54 GMT

Can someone help me on following points?1. I need to implement Activiti without Spring. I want to use simple Servet-JSP code. However, I could not find much help on this.2. Using simple Servlet-JSP code, I am getting the following exception related to slf4jFailed to instantiate SLF4J LoggerFactoryRe

Re: Activit without Spring

martin_grofcik — Wed, 26 Feb 2014 07:22:29 GMT

1. I need to implement Activiti without Spring. I want to use simple Servet-JSP code. However, I could not find much help on this.

Activiti engine does not depend on spring (only spring beans as you can see).


[INFO] [dependency:tree {execution: default-cli}]
[INFO] org.activiti:activiti-engine:jar:5.15-SNAPSHOT
[INFO] +- org.activiti:activiti-bpmn-converter:jar:5.15-SNAPSHOT:compile
[INFO] |  \- org.activiti:activiti-bpmn-model:jar:5.15-SNAPSHOT:compile
[INFO] |     \- org.codehaus.jackson:jackson-core-asl:jar:1.9.9:compile
[INFO] +- org.apache.commons:commons-email:jar:1.2:compile
[INFO] |  +- javax.mail:mail:jar:1.4.1:compile
[INFO] |  \- javax.activation:activation:jar:1.1:compile
[INFO] +- org.apache.commons:commons-lang3:jar:3.1:compile
[INFO] +- org.mybatis:mybatis:jar:3.2.2:compile
[INFO] +- org.springframework:spring-beans:jar:3.2.7.RELEASE:compile
[INFO] |  \- org.springframework:spring-core:jar:3.2.7.RELEASE:compile
[INFO] +- junit:junit:jar:4.11:smileytongue:rovided
[INFO] |  \- org.hamcrest:hamcrest-core:jar:1.3:smileytongue:rovided
[INFO] +- org.codehaus.groovy:groovy-all:jar:2.1.3:smileytongue:rovided
[INFO] +- org.drools:drools-core:jar:5.5.0.Final:smileytongue:rovided
[INFO] |  +- org.mvel:mvel2:jar:2.1.3.Final:smileytongue:rovided
[INFO] |  +- org.drools:knowledge-api:jar:5.5.0.Final:smileytongue:rovided
[INFO] |  \- org.drools:knowledge-internal-api:jar:5.5.0.Final:smileytongue:rovided
[INFO] +- org.drools:drools-compiler:jar:5.5.0.Final:smileytongue:rovided
[INFO] |  +- org.antlr:antlr-runtime:jar:3.3:smileytongue:rovided
[INFO] |  +- org.antlr:antlr:jar:3.3:smileytongue:rovided
[INFO] |  +- org.antlr:stringtemplate:jar:3.2.1:smileytongue:rovided
[INFO] |  +- antlr:antlr:jar:2.7.7:smileytongue:rovided
[INFO] |  +- org.eclipse.jdt.core.compiler:ecj:jar:3.5.1:smileytongue:rovided
[INFO] |  \- com.thoughtworks.xstream:xstream:jar:1.4.1:smileytongue:rovided
[INFO] |     +- xmlpull:xmlpull:jar:1.1.3.1:smileytongue:rovided
[INFO] |     \- xpp3:xpp3_min:jar:1.1.4c:smileytongue:rovided
[INFO] +- javax.persistence:smileytongue:ersistence-api:jar:1.0:smileytongue:rovided
[INFO] +- org.apache.geronimo.specs:geronimo-jta_1.1_spec:jar:1.1.1:smileytongue:rovided
[INFO] +- com.h2database:h2:jar:1.3.170:test
[INFO] +- org.mockito:mockito-core:jar:1.8.2:test
[INFO] |  \- org.objenesis:smileysurprised:bjenesis:jar:1.0:test
[INFO] +- org.apache.openjpa:smileysurprised:penjpa:jar:1.2.2:test
[INFO] |  +- net.sourceforge.serp:serp:jar:1.13.1:test
[INFO] |  +- commons-lang:commons-lang:jar:2.1:test
[INFO] |  +- commons-collections:commons-collections:jar:3.2:test
[INFO] |  +- commons-pool:commons-pool:jar:1.3:test
[INFO] |  +- org.apache.geronimo.specs:geronimo-jms_1.1_spec:jar:1.0.1:test
[INFO] |  \- org.apache.geronimo.specs:geronimo-jpa_3.0_spec:jar:1.0:test
[INFO] +- org.subethamail:subethasmtp-wiser:jar:1.2:test
[INFO] |  \- org.subethamail:subethasmtp-smtp:jar:1.2:test
[INFO] +- mysql:mysql-connector-java:jar:5.1.27:test
[INFO] +- postgresql:smileytongue:ostgresql:jar:9.0-801.jdbc4:test
[INFO] +- net.sourceforge.jtds:jtds:jar:1.3.0:test
[INFO] +- com.fasterxml.uuid:java-uuid-generator:jar:3.1.3:smileytongue:rovided
[INFO] |  \- log4j:log4j:jar:1.2.13:smileytongue:rovided
[INFO] +- commons-io:commons-io:jar:2.0.1:test
[INFO] +- joda-time:joda-time:jar:2.1:compile
[INFO] +- org.slf4j:slf4j-api:jar:1.7.2:compile
[INFO] +- org.slf4j:jcl-over-slf4j:jar:1.7.2:compile
[INFO] +- org.slf4j:slf4j-log4j12:jar:1.7.2:test
[INFO] \- org.codehaus.btm:btm:jar:2.1.3:test
[INFO]    \- javax.transaction:jta:jar:1.1:test

How to get it running: Create ProcessEngineConfiguration and build process engine from it.

2. Using simple Servlet-JSP code, I am getting the following exception related to slf4j

libraries in the classpath are missing


[INFO] +- org.slf4j:slf4j-api:jar:1.7.2:compile
[INFO] +- org.slf4j:jcl-over-slf4j:jar:1.7.2:compile

3. Last point :

try and post exception.

Regards
Martin

Re: Activit without Spring

omni_ok — Wed, 26 Feb 2014 07:39:28 GMT

Thanks we could proceed with your suggestion.
I use "ibatis-sqlmap-3.0-beta-10.jar" and get the following exception:
java.lang.ClassCastException: org.apache.ibatis.logging.slf4j.Slf4jImpl cannot be cast to org.apache.ibatis.logging.Log

I also tried using "mybatis-3.0.4.jar", but had some other exception.

Re: Activit without Spring

martin_grofcik — Wed, 26 Feb 2014 07:41:38 GMT

activiti-egine dependency is org.mybatis:mybatis:jar:3.2.2:compile. Did you try this one?

Re: Activit without Spring

omni_ok — Wed, 26 Feb 2014 10:06:41 GMT

Yes Thanks Martin. It worked. However, the MYSQL exception still persists.
I have mentioned the following code:

ProcessEngine processEngine = ProcessEngineConfiguration.createStandaloneProcessEngineConfiguration() .setDatabaseSchemaUpdate(ProcessEngineConfiguration.DB_SCHEMA_UPDATE_FALSE) .setJdbcUrl("jdbc:mysql://localhost:3306/activiti?autoReconnect=true&user=root&password=root") .setJobExecutorActivate(true) .buildProcessEngine();

The exception here is :
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied for user ''@'localhost' to database 'activiti'

However, when I write the same jdbc connection URL in a standalone Java program, it works!
The db.properties file (placed in "apache-tomcat-6.0.26\webapps\activiti-explorer.war\WEB-INF\classes") is alsoconfigured to MYSQL database.

Re: Activit without Spring

martin_grofcik — Wed, 26 Feb 2014 10:09:15 GMT

Hi,

Access denied for user

for me it seems like my SQL configuration issue.

Regards
Martin

Re: Activit without Spring

omni_ok — Wed, 26 Feb 2014 13:42:31 GMT

I have done with with MYSQL connection now. I just changed the above code to the following:

ProcessEngine processEngine = ProcessEngineConfiguration.createStandaloneProcessEngineConfiguration()                             .setDatabaseSchemaUpdate(ProcessEngineConfiguration.DB_SCHEMA_UPDATE_FALSE)                             .setJdbcUrl("jdbc:mysql://localhost:3306/activiti").setJdbcPassword("root").setJdbcUsername("root")                             .setJobExecutorActivate(true).buildProcessEngine();

However, I am getting a new exception.
The code written is:

RepositoryService repositoryService =processEngine.getRepositoryService();
RuntimeService runtimeService =processEngine.getRuntimeService();
ProcessInstance processInstance = runtimeService.startProcessInstanceByKey("vacationRequest");

For this code the exception is:
org.activiti.engine.ActivitiIllegalArgumentException: unknown type 'user' approver
       at org.activiti.engine.impl.form.FormTypes.parseFormPropertyType(FormTypes.java:55)
       at org.activiti.engine.impl.form.DefaultFormHandler.parseConfiguration(DefaultFormHandler.java:61)
       at org.activiti.engine.impl.form.DefaultStartFormHandler.parseConfiguration(DefaultStartFormHandler.java:34)
       at org.activiti.engine.impl.bpmn.parser.handler.StartEventParseHandler.createStartFormHandlers(StartEventParseHandler.java:79)
       at org.activiti.engine.impl.bpmn.parser.handler.StartEventParseHandler.executeParse(StartEventParseHandler.java:53)
       at org.activiti.engine.impl.bpmn.parser.handler.StartEventParseHandler.executeParse(StartEventParseHandler.java:35)
       at org.activiti.engine.impl.bpmn.parser.handler.AbstractBpmnParseHandler.parse(AbstractBpmnParseHandler.java:79)
       at org.activiti.engine.impl.bpmn.parser.handler.AbstractFlowNodeBpmnParseHandler.parse(AbstractFlowNodeBpmnParseHandler.java:27)
       at org.activiti.engine.impl.bpmn.parser.handler.AbstractActivityBpmnParseHandler.parse(AbstractActivityBpmnParseHandler.java:35)
       at org.activiti.engine.impl.bpmn.parser.BpmnParseHandlers.parseElement(BpmnParseHandlers.java:73)
       at org.activiti.engine.impl.bpmn.parser.BpmnParse.processFlowElements(BpmnParse.java:407)
       at org.activiti.engine.impl.bpmn.parser.handler.ProcessParseHandler.transformProcess(ProcessParseHandler.java:82)
       at org.activiti.engine.impl.bpmn.parser.handler.ProcessParseHandler.executeParse(ProcessParseHandler.java:44)
       at org.activiti.engine.impl.bpmn.parser.handler.ProcessParseHandler.executeParse(ProcessParseHandler.java:30)
       at org.activiti.engine.impl.bpmn.parser.handler.AbstractBpmnParseHandler.parse(AbstractBpmnParseHandler.java:79)
       at org.activiti.engine.impl.bpmn.parser.BpmnParseHandlers.parseElement(BpmnParseHandlers.java:73)
       at org.activiti.engine.impl.bpmn.parser.BpmnParse.transformProcessDefinitions(BpmnParse.java:367)
       at org.activiti.engine.impl.bpmn.parser.BpmnParse.execute(BpmnParse.java:190)
       at org.activiti.engine.impl.bpmn.deployer.BpmnDeployer.deploy(BpmnDeployer.java:86)
       at org.activiti.engine.impl.persistence.deploy.DeploymentManager.deploy(DeploymentManager.java:42)
       at org.activiti.engine.impl.persistence.deploy.DeploymentManager.resolveProcessDefinition(DeploymentManager.java:95)
       at org.activiti.engine.impl.persistence.deploy.DeploymentManager.findDeployedLatestProcessDefinitionByKey(DeploymentManager.java:69)
       at org.activiti.engine.impl.cmd.StartProcessInstanceCmd.execute(StartProcessInstanceCmd.java:64)
       at org.activiti.engine.impl.cmd.StartProcessInstanceCmd.execute(StartProcessInstanceCmd.java:36)
       at org.activiti.engine.impl.interceptor.CommandInvoker.execute(CommandInvoker.java:24)
       at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:57)
       at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:31)
       at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:40)
       at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:35)
       at org.activiti.engine.impl.RuntimeServiceImpl.startProcessInstanceByKey(RuntimeServiceImpl.java:56)
       at com.activiti.Servlet1.doPost(Servlet1.java:96)
       at com.activiti.Servlet1.doGet(Servlet1.java:32)
       at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
       at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
       at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
       at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
       at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
       at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
       at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
       at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
       at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
       at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)
       at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
       at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
       at java.lang.Thread.run(Unknown Source)

Please help on this!

Re: Activit without Spring

martin_grofcik — Wed, 26 Feb 2014 13:50:37 GMT

the issue is on your process definition. (form property type user is not supported)

Re: Activit without Spring

omni_ok — Wed, 26 Feb 2014 13:54:41 GMT

The process definition is "vacationRequest" which is provided in Activiti 5.14 by default. I have not created this process definition. I want to check, how can we invoke a process from a simple Servlet-JSP application.

Re: Activit without Spring

martin_grofcik — Wed, 26 Feb 2014 13:57:37 GMT

vacationRequest uses form types which are configured in activiti-explorer. Your configuration does not support these form types.
Try simple process start->userTask->end

Re: Activit without Spring

omni_ok — Thu, 27 Feb 2014 09:22:34 GMT

I have proceeded to initiate a new process of my own. This is working fine.
When I write the below code, I get the exception which ins mentioned following the code:

TaskService taskService = processEngine.getTaskService();
List<Task> tasks = taskService.createTaskQuery().taskAssignee("kermit").list();
for (Task task : tasks) {
   System.out.println("id "+task.getId()+" name "+task.getName());
}

Exception:
org.apache.ibatis.exceptions.PersistenceException:
### Error querying database. Cause: org.apache.ibatis.reflection.ReflectionException: There is no getter for property named 'limitBefore' in 'class org.activiti.engine.impl.TaskQueryImpl'
### Cause: org.apache.ibatis.reflection.ReflectionException: There is no getter for property named 'limitBefore' in 'class org.activiti.engine.impl.TaskQueryImpl'
       at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23)
       at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:107)
       at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:98)
       at org.activiti.engine.impl.db.DbSqlSession.selectListWithRawParameter(DbSqlSession.java:286)
       at org.activiti.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:277)
       at org.activiti.engine.impl.persistence.entity.TaskEntityManager.findTasksByQueryCriteria(TaskEntityManager.java:113)
       at org.activiti.engine.impl.TaskQueryImpl.executeList(TaskQueryImpl.java:551)
       at org.activiti.engine.impl.AbstractQuery.execute(AbstractQuery.java:139)
       at org.activiti.engine.impl.interceptor.CommandInvoker.execute(CommandInvoker.java:24)
       at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:57)
       at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:31)
       at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:40)
       at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:35)
       at org.activiti.engine.impl.AbstractQuery.list(AbstractQuery.java:113)
       at com.activiti.ApprovalServlet.doGet(ApprovalServlet.java:44)
       at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
       at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
       at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
       at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
       at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
       at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
       at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
       at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
       at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
       at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)
       at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
       at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
       at java.lang.Thread.run(Unknown Source)
Caused by: org.apache.ibatis.reflection.ReflectionException: There is no getter for property named 'limitBefore' in 'class org.activiti.engine.impl.TaskQueryImpl'
       at org.apache.ibatis.reflection.Reflector.getGetInvoker(Reflector.java:377)
       at org.apache.ibatis.reflection.MetaClass.getGetInvoker(MetaClass.java:167)
       at org.apache.ibatis.reflection.wrapper.BeanWrapper.getBeanProperty(BeanWrapper.java:149)
       at org.apache.ibatis.reflection.wrapper.BeanWrapper.get(BeanWrapper.java:45)
       at org.apache.ibatis.reflection.MetaObject.getValue(MetaObject.java:113)
       at org.apache.ibatis.scripting.xmltags.DynamicContext$ContextMap.get(DynamicContext.java:89)
       at org.apache.ibatis.scripting.xmltags.DynamicContext$ContextAccessor.getProperty(DynamicContext.java:107)
       at org.apache.ibatis.ognl.OgnlRuntime.getProperty(OgnlRuntime.java:1657)
       at org.apache.ibatis.ognl.ASTProperty.getValueBody(ASTProperty.java:92)
       at org.apache.ibatis.ognl.SimpleNode.evaluateGetValueBody(SimpleNode.java:170)
       at org.apache.ibatis.ognl.SimpleNode.getValue(SimpleNode.java:210)
       at org.apache.ibatis.ognl.Ognl.getValue(Ognl.java:333)
       at org.apache.ibatis.ognl.Ognl.getValue(Ognl.java:413)
       at org.apache.ibatis.ognl.Ognl.getValue(Ognl.java:395)
       at org.apache.ibatis.scripting.xmltags.OgnlCache.getValue(OgnlCache.java:45)
       at org.apache.ibatis.scripting.xmltags.TextSqlNode$BindingTokenParser.handleToken(TextSqlNode.java:50)
       at org.apache.ibatis.parsing.GenericTokenParser.parse(GenericTokenParser.java:50)
       at org.apache.ibatis.scripting.xmltags.TextSqlNode.apply(TextSqlNode.java:31)
       at org.apache.ibatis.scripting.xmltags.MixedSqlNode.apply(MixedSqlNode.java:29)
       at org.apache.ibatis.scripting.xmltags.DynamicSqlSource.getBoundSql(DynamicSqlSource.java:37)
       at org.apache.ibatis.mapping.MappedStatement.getBoundSql(MappedStatement.java:265)
       at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:79)
       at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:104)
       … 27 more

Please help me in this !!!

Re: Activit without Spring

martin_grofcik — Thu, 27 Feb 2014 09:30:05 GMT

mapping file is not in synch with code.
Did you upgrade code or database? Were upgrades synchronized?

Re: Activit without Spring

omni_ok — Thu, 27 Feb 2014 10:23:50 GMT

Which mapping file?
I have not upgraded anything explicitly. I am using MYSQL5.5.9 and Activiti 5.14 right from the start of this application!

Re: Activit without Spring

omni_ok — Thu, 27 Feb 2014 10:23:51 GMT

Which mapping file?
I have not upgraded anything explicitly. I am using MYSQL5.5.9 and Activiti 5.14 right from the start of this application!

Re: Activit without Spring

martin_grofcik — Thu, 27 Feb 2014 10:54:24 GMT

org/activiti/db/mapping/entity/Task.xml