Need help with configuring custom SQL. Getting error for MapperRegistry

navonodt — Fri, 11 Aug 2017 16:19:16 GMT

I am trying to configure a custom mybatis query and missing something. I created my interface package com.activiti.mappers;import org.apache.ibatis.annotations.Select;import java.util.List;public interface CustomMybatisMapper {@Select("SELECT ID_ FROM ACT_RE_PROCDEF WHERE KEY_ = #{key}") String loa

Re: Need help with configuring custom SQL. Getting error for MapperRegistry

navonodt — Fri, 11 Aug 2017 19:45:36 GMT

Ok after much banging my head agains the desk I have figured it out and will post here to help the next guy. The documentation I read only gets you so far or assumes you know something which I definitely didn't

I am running in a spring boot configuration in tomcat

In the pom.xml I added

<groupId>com.activiti</groupId>

<artifactId>activiti-spring-boot-starter-basic</artifactId>

<version>${activiti.version}</version>

</dependency>

To setup a custom sql query you first create you mapping interface ( i chose com.activiti.mappers as my namespace)

I just used a dummy query for this to see if it worked

package com.activiti.mappers;

import org.apache.ibatis.annotations.Select;

public interface CustomMybatisMapper {

@Select("SELECT ID_ FROM ACT_RE_PROCDEF WHERE KEY_ = #{key}")
String loadProcessDefinitionIdByKey(String key);
}

under com.activiti.extension.conf namespace I created a configurer and a configuration (the configuration class was the final key for me)

package com.activiti.extension.conf;

import java.util.HashSet;
import java.util.Set;
import org.activiti.spring.SpringProcessEngineConfiguration;
import com.activiti.api.engine.ProcessEngineConfigurationConfigurer;
import org.springframework.context.annotation.Configuration;

import com.activiti.mappers.CustomMybatisMapper;

@Configuration
public class FooCustomMybatisConfigurer implements ProcessEngineConfigurationConfigurer {

@Override
public void processEngineConfigurationInitialized(
SpringProcessEngineConfiguration springProcessEngineConfiguration) {

Set<Class<?>> batisMappers = new HashSet<>();

batisMappers.add(CustomMybatisMapper.class);
springProcessEngineConfiguration.setCustomMybatisMappers(batisMappers);
System.out.println("Mapper added");

}

}

and then the bean creation in the configuration

package com.activiti.extension.conf;

import org.springframework.context.annotation.Bean;

import org.springframework.context.annotation.Configuration;

import com.activiti.api.engine.ProcessEngineConfigurationConfigurer;

@Configuration

public class FooProcessEngineConfig {

@Bean

public ProcessEngineConfigurationConfigurer processEngineConfigurationConfigurer(){

return new FooCustomMybatisConfigurer();

}

And the code to call the query

String processDefinitionId = managementService.executeCustomSql(new AbstractCustomSqlExecution<CustomMybatisMapper, String>(CustomMybatisMapper.class) {

@Override

public String execute(CustomMybatisMapper customMybatisMapper) {

return customMybatisMapper.loadProcessDefinitionIdByKey("<your process here>");

}

});

No xml configuration needed or properties files tho I am sure you can and maybe should do it that way but this is working.

topic Re: Need help with configuring custom SQL. Getting error for MapperRegistry in Alfresco Forum

Need help with configuring custom SQL. Getting error for MapperRegistry

Re: Need help with configuring custom SQL. Getting error for MapperRegistry