Spring使用过程中出现org.apache.ibatis.binding.BindingException: Invalid bound statement (not found):

[ffch]

如题，Spring使用过程中出现org.apache.ibatis.binding.BindingException: Invalid bound statement (not found):

[ffch]

Spring使用JpaMapper，需要配置JpaMapper的Mapper处理。

如果已经配置，可能是bean的生成顺序问题。

可以使用@dependsOn或者@order注解调整JpaMapper配置的生成顺序

如：

package cn.pomit.jpa.mapper;

import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import org.apache.ibatis.binding.MapperRegistry;
import org.apache.ibatis.session.SqlSessionFactory;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.core.annotation.Order;

import cn.pomit.jpamapper.core.MapperScanner;
import cn.pomit.jpamapper.core.mapper.register.MappedStatementRegister;

/**
 * Mapper 配置
 *
 */
@Configuration
public class JpaMapperConfig {

	@Bean
	@Order
	public MapperScanner mapperScanner(List<SqlSessionFactory> sqlSessionFactoryList) throws SQLException {

		MapperScanner mapperScanner = new MapperScanner();
		for (SqlSessionFactory sqlSessionFactory : sqlSessionFactoryList) {
			org.apache.ibatis.session.Configuration configuration = sqlSessionFactory.getConfiguration();
			MapperRegistry mapperRegistry = configuration.getMapperRegistry();
			List<Class<?>> mappers = new ArrayList<>(mapperRegistry.getMappers());
			MappedStatementRegister mappedStatementRegister = new MappedStatementRegister(configuration);
			mappedStatementRegister.addMappers(mappers);
			mapperScanner.addMappedStatementRegister(mappedStatementRegister);
		}
		mapperScanner.scanAndRegisterJpaMethod();

		return mapperScanner;

	}
}

或者

package cn.pomit.jpa.mapper;

import java.util.ArrayList;
import java.util.List;

import javax.annotation.PostConstruct;

import org.apache.ibatis.binding.MapperRegistry;
import org.apache.ibatis.session.SqlSessionFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.context.annotation.DependsOn;
import org.springframework.stereotype.Component;

import cn.pomit.jpamapper.core.MapperScanner;
import cn.pomit.jpamapper.core.mapper.register.MappedStatementRegister;

/**
 * Mapper 配置
 *
 * @author cff
 */
@Component
@DependsOn("userInfoService")
public class JpaMapperConfig {
	
	@Autowired
    private List<SqlSessionFactory> sqlSessionFactoryList;
    
    @PostConstruct
    public void addPageInterceptor() {
    	try{
	        MapperScanner mapperScanner = new MapperScanner();
	        for (SqlSessionFactory sqlSessionFactory : sqlSessionFactoryList) {
	        	org.apache.ibatis.session.Configuration configuration = sqlSessionFactory.getConfiguration();
	        	MapperRegistry mapperRegistry = configuration.getMapperRegistry();
	        	List<Class<?>> mappers = new ArrayList<>(mapperRegistry.getMappers());
	        	MappedStatementRegister mappedStatementRegister = new MappedStatementRegister(configuration);
	        	mappedStatementRegister.addMappers(mappers);
	        	mapperScanner.addMappedStatementRegister(mappedStatementRegister);
	        }
	        
	        mapperScanner.scanAndRegisterJpaMethod();
    	}catch(Exception e){
    		e.printStackTrace();
    	}
    }
}