常連

myBatisで、SQLのIN句の中に複数の値を渡したいSQLがあります。

```lang-SQL
SELECT * FROM tblA WHERE colhoge IN(1,2,5);
```

のような形のSQLを書きたいです。
どのようにすればいいのでしょうか？
分かる人、教えて下さい。

myBatisで、IN句を用いたい

### Spring Boot + mybatisでDB接続したい

- [ ] DBのCRUDを実行する

### 前提
「Spring Boot」「MyBatis」初心者です
以下のサイトを参考にプロジェクトを作成し、実行したところエラーが発生しました
参考サイト：https://medium-company.com/mybatis-spring/

### 発生している問題・エラーメッセージ

```
Description:

Field userInfoMapper in com.example.demo.service.UserInfoService required a bean of type 'com.example.demo.dao.UserInfoMapper' that could not be found.

The injection point has the following annotations:
	- @org.springframework.beans.factory.annotation.Autowired(required=true)


Action:

Consider defining a bean of type 'com.example.demo.dao.UserInfoMapper' in your configuration.
```

### 該当のソースコード
基本的に参考サイトのコピペなのと、文字数制限のため一部ソースのみ記載します
※必要に応じて追加します
![イメージ説明](https://ddjkaamml8q8x.cloudfront.net/questions/2023-04-26/465f8582-97ed-4d65-91cf-5b504da3c2e7.png)

```pom.xml
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
	<modelVersion>4.0.0</modelVersion>
	<parent>
		<groupId>org.springframework.boot</groupId>
		<artifactId>spring-boot-starter-parent</artifactId>
		<version>3.0.6</version>
		<relativePath/> 
	</parent>
	<groupId>com.example</groupId>
	<artifactId>SpringMybatis</artifactId>
	<version>0.0.1-SNAPSHOT</version>
	<packaging>war</packaging>
	<name>SpringMybatis</name>
	<description>Demo project for Spring Boot</description>
	<properties>
		<java.version>17</java.version>
	</properties>
	<dependencies>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-data-jpa</artifactId>
		</dependency>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-thymeleaf</artifactId>
		</dependency>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-validation</artifactId>
		</dependency>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-web</artifactId>
		</dependency>

		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-devtools</artifactId>
			<scope>runtime</scope>
			<optional>true</optional>
		</dependency>
		<dependency>
			<groupId>org.postgresql</groupId>
			<artifactId>postgresql</artifactId>
			<scope>runtime</scope>
		</dependency>
		<dependency>
			<groupId>org.projectlombok</groupId>
			<artifactId>lombok</artifactId>
			<optional>true</optional>
		</dependency>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-tomcat</artifactId>
			<scope>provided</scope>
		</dependency>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-test</artifactId>
			<scope>test</scope>
		</dependency>
		<dependency>
        	<groupId>org.mybatis.spring.boot</groupId>
        	<artifactId>mybatis-spring-boot-starter</artifactId>
        	<version>2.2.2</version>
    	</dependency>
	</dependencies>

	<build>
		<plugins>
			<plugin>
				<groupId>org.springframework.boot</groupId>
				<artifactId>spring-boot-maven-plugin</artifactId>
				<configuration>
					<excludes>
						<exclude>
							<groupId>org.projectlombok</groupId>
							<artifactId>lombok</artifactId>
						</exclude>
					</excludes>
				</configuration>
			</plugin>
		</plugins>
	</build>

</project>

```

### 試したこと

・application.propertiesに「mybatis.mapper-locations」の記載を追加 → 変化なし
```application.properties
mybatis.mapper-locations=classpath*:com/example/demo/dao/*.xml
```

### 補足情報（FW/ツールのバージョンなど）

・eclipse 2023-03
・PostgresSQL 15.2.2

Spring Boot + MyBatisでMapperクラスが見つからないとエラーが出る

### 実現したいこと

postgreSQLのデータベースを使ってユーザー登録、ログインができるwebアプリを作りたい

### 前提

spring boot ,spring security ,flyway ,mybatis ,postgresqlを使ってログイン機能付きのwebアプリを作っています。メモリでの認証までは上手くいったのですがDBを使用しての認証方法が全く分からず、手探りでやっては見たのですが、全くうまくいきませんでした。MVCを使わないドキュメントはいくつか見つかったのですが他の部分との関係でどうしてもMVCで完成させたいです。ご教授いただければ幸いです。

### 発生している問題・エラーメッセージ

```
Caused by: org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): Nsystem.sougaku.Mappars.userDataMapper.login

```

### 該当のソースコード

```java
@Controller
@RequestMapping("/")
public class loginController {
    @GetMapping
    public String getLoginPage(){
        return "login";
    }
}
```
```java
package Nsystem.sougaku.Domains;

import lombok.Data;
import org.springframework.security.core.GrantedAuthority;
import org.springframework.security.core.userdetails.UserDetails;

import java.io.Serial;
import java.util.Collection;

@Data
public class userData implements UserDetails {
    @Serial
    private int id;
    private String username;
    private int studentNumber;
    private String password;
    private Collection<GrantedAuthority> authorities;
    private int HorS;

    public userData(String username, int studentNumber, String password, Collection<GrantedAuthority> authorities, int HorS) {
        this.username = username;
        this.studentNumber = studentNumber;
        this.password = password;
        this.authorities = authorities;
        this.HorS = HorS;
    }

    @Override
    public Collection<? extends GrantedAuthority> getAuthorities() {
        return authorities;
    }
    @Override
    public String getPassword() {
        return password;
    }
    @Override
    public String getUsername() {
        return username;
    }
    @Override
    public boolean isAccountNonExpired() {
        return true;
    }
    @Override
    public boolean isAccountNonLocked() {
        return true;
    }
    @Override
    public boolean isCredentialsNonExpired() {
        return true;
    }
    @Override
    public boolean isEnabled() {
        return true;
    }
}
```
```java
package Nsystem.sougaku.Mappars;

import Nsystem.sougaku.Domains.userData;
import org.apache.ibatis.annotations.Mapper;

@Mapper
public interface userDataMapper {
    userData login(String userName);
    void addUser(userData user);
}
```
```java
package Nsystem.sougaku.Security;

import org.springframework.boot.autoconfigure.security.servlet.PathRequest;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.security.config.annotation.web.builders.HttpSecurity;
import org.springframework.security.config.annotation.web.configuration.EnableWebSecurity;
import org.springframework.security.crypto.bcrypt.BCryptPasswordEncoder;
import org.springframework.security.crypto.password.PasswordEncoder;
import org.springframework.security.web.SecurityFilterChain;

@EnableWebSecurity
@Configuration
public class SecurityConfig {

    @Bean
    public PasswordEncoder passwordEncoder(){
        return new BCryptPasswordEncoder();
    }

    @Bean
    public SecurityFilterChain securityFilterChain(HttpSecurity http) throws Exception{
        http.formLogin(login -> login
                .loginProcessingUrl("/login")
                .loginPage("/")
                .defaultSuccessUrl("/home")
                .failureUrl("/login?error")
                .permitAll()
        ).logout(logout -> logout
                .logoutUrl("/logout")
                .logoutSuccessUrl("/")
        ).authorizeHttpRequests(authz -> authz
                .requestMatchers(PathRequest.toStaticResources().atCommonLocations()).permitAll()
                .requestMatchers("/").permitAll()
                .requestMatchers("/general").hasRole("GENERAL")
                .requestMatchers("/admin").hasRole("ADMIN")
                .anyRequest().authenticated()
        );
        return http.build();
    }
 }
```java
import Nsystem.sougaku.Domains.userData;
import Nsystem.sougaku.Mappars.userDataMapper;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.security.core.userdetails.User;
import org.springframework.security.core.userdetails.UserDetails;
import org.springframework.security.core.userdetails.UserDetailsService;
import org.springframework.security.core.userdetails.UsernameNotFoundException;
import org.springframework.stereotype.Service;

import java.util.Collections;

@Service
public class UserService implements UserDetailsService {
    private final userDataMapper userDataMapper;

    @Autowired
    public UserService(userDataMapper userDataMapper) {
        this.userDataMapper = userDataMapper;
    }

    @Override
    public UserDetails loadUserByUsername(String userName) throws UsernameNotFoundException {
        userData userdata = userDataMapper.login(userName);
        return new User(userdata.getUsername(), userdata.getPassword(), Collections.emptyList());
    }
}
```
```Mapper.xml
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="Nsystem.sougaku.Mappars.userDataMapper">
    <resultMap id="userDataResultMap" type="Nsystem.sougaku.Domains.userData">
        <result property="id" column="id"/>
        <result property="username" column="userName"/>
        <result property="studentNumber" column="studentNumber"/>
        <result property="password" column="password"/>
        <result property="authorities" column="authority"/>
        <result property="HorS" column="HorS"/>
    </resultMap>
    <select id="login" resultMap="userDataResultMap" parameterType="String">
        SELECT * FROM userData WHERE userName = #{userName};
    </select>
</mapper>
```





MVCモデルを使ったspring securityのDBでの認証方法について

### 前提・実現したいこと

spring boot で mybatisを利用しています。
@Mapperをクラスに定義しているのですが、「org.apache.ibatis.binding.BindingException: Invalid bound statement (not found)」のエラーが出てしまうのでこのエラーが出ないようにしたいです。


### 発生している問題・エラーメッセージ

```
org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): net.dcp.questionnaire.mapper.ISampleMapper.select
	at org.apache.ibatis.binding.MapperMethod$SqlCommand.<init>(MapperMethod.java:227) ~[mybatis-3.4.6.jar:3.4.6]
	at org.apache.ibatis.binding.MapperMethod.<init>(MapperMethod.java:49) ~[mybatis-3.4.6.jar:3.4.6]
	at org.apache.ibatis.binding.MapperProxy.cachedMapperMethod(MapperProxy.java:65) ~[mybatis-3.4.6.jar:3.4.6]
	at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:58) ~[mybatis-3.4.6.jar:3.4.6]
	at com.sun.proxy.$Proxy61.select(Unknown Source) ~[na:na]
	at net.dcp.questionnaire.service.SampleService.selectById(SampleService.java:16) ~[main/:na]
	at net.dcp.questionnaire.controller.SampleController.index(SampleController.java:22) ~[main/:na]
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_121]
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_121]
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_121]
	at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_121]
	at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:189) ~[spring-web-5.1.4.RELEASE.jar:5.1.4.RELEASE]
	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138) ~[spring-web-5.1.4.RELEASE.jar:5.1.4.RELEASE]
	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102) ~[spring-webmvc-5.1.4.RELEASE.jar:5.1.4.RELEASE]
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895) ~[spring-webmvc-5.1.4.RELEASE.jar:5.1.4.RELEASE]
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:800) ~[spring-webmvc-5.1.4.RELEASE.jar:5.1.4.RELEASE]
	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) ~[spring-webmvc-5.1.4.RELEASE.jar:5.1.4.RELEASE]
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1038) ~[spring-webmvc-5.1.4.RELEASE.jar:5.1.4.RELEASE]
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:942) ~[spring-webmvc-5.1.4.RELEASE.jar:5.1.4.RELEASE]
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1005) ~[spring-webmvc-5.1.4.RELEASE.jar:5.1.4.RELEASE]
	at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:897) ~[spring-webmvc-5.1.4.RELEASE.jar:5.1.4.RELEASE]
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:634) ~[tomcat-embed-core-9.0.14.jar:9.0.14]
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:882) ~[spring-webmvc-5.1.4.RELEASE.jar:5.1.4.RELEASE]
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) ~[tomcat-embed-core-9.0.14.jar:9.0.14]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) ~[tomcat-embed-core-9.0.14.jar:9.0.14]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.14.jar:9.0.14]
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) ~[tomcat-embed-websocket-9.0.14.jar:9.0.14]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.14.jar:9.0.14]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.14.jar:9.0.14]
	at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99) ~[spring-web-5.1.4.RELEASE.jar:5.1.4.RELEASE]
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) ~[spring-web-5.1.4.RELEASE.jar:5.1.4.RELEASE]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.14.jar:9.0.14]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.14.jar:9.0.14]
	at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:92) ~[spring-web-5.1.4.RELEASE.jar:5.1.4.RELEASE]
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) ~[spring-web-5.1.4.RELEASE.jar:5.1.4.RELEASE]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.14.jar:9.0.14]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.14.jar:9.0.14]
	at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93) ~[spring-web-5.1.4.RELEASE.jar:5.1.4.RELEASE]
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) ~[spring-web-5.1.4.RELEASE.jar:5.1.4.RELEASE]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.14.jar:9.0.14]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.14.jar:9.0.14]
	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200) ~[spring-web-5.1.4.RELEASE.jar:5.1.4.RELEASE]
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) ~[spring-web-5.1.4.RELEASE.jar:5.1.4.RELEASE]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.14.jar:9.0.14]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.14.jar:9.0.14]
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) ~[tomcat-embed-core-9.0.14.jar:9.0.14]
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [tomcat-embed-core-9.0.14.jar:9.0.14]
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490) [tomcat-embed-core-9.0.14.jar:9.0.14]
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) [tomcat-embed-core-9.0.14.jar:9.0.14]
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [tomcat-embed-core-9.0.14.jar:9.0.14]
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) [tomcat-embed-core-9.0.14.jar:9.0.14]
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [tomcat-embed-core-9.0.14.jar:9.0.14]
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408) [tomcat-embed-core-9.0.14.jar:9.0.14]
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) [tomcat-embed-core-9.0.14.jar:9.0.14]
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:834) [tomcat-embed-core-9.0.14.jar:9.0.14]
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1417) [tomcat-embed-core-9.0.14.jar:9.0.14]
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-embed-core-9.0.14.jar:9.0.14]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [na:1.8.0_121]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [na:1.8.0_121]
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-embed-core-9.0.14.jar:9.0.14]
	at java.lang.Thread.run(Thread.java:745) [na:1.8.0_121]
```

### 該当のソースコード

```Java
package xxx.xxxxxx.questionnaire.mapper;

import xxx.xxxxxx.questionnaire.entity.SampleEntity;
import org.apache.ibatis.annotations.Mapper;

@Mapper
public interface ISampleMapper {

    void insert(SampleEntity sample);

    SampleEntity select(int id);

}
```

```
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="net.dcp.questionnaire.mapper.ISampleMapper">
    <insert id="insert" useGeneratedKeys="true" keyProperty="id">
        INSERT INTO sample (title, details, finished) VALUES (#{title}, #{details}, #{finished})
    </insert>
    <select id="select" resultType="net.dcp.questionnaire.entity.SampleEntity">
        SELECT id, title, details, finished FROM sample WHERE id = #{id}
    </select>
</mapper>
```

### 試したこと

下記リンクを参考に@Mapperを外し@MapperScanを試してみましたが同様のエラーが起きました。
https://qiita.com/kazuki43zoo/items/ea79e206d7c2e990e478#mapper%E3%82%A4%E3%83%B3%E3%82%BF%E3%83%95%E3%82%A7%E3%83%BC%E3%82%B9%E3%81%AE%E3%82%B9%E3%82%AD%E3%83%A3%E3%83%B3%E3%81%AE%E4%BB%95%E7%B5%84%E3%81%BF

また、下記リンクを参考に同様のクラスを作成して@Configrationの次の行に@MapperScanを入れて試してみましたが同様のエラーが起きました。
https://qiita.com/kazuki43zoo/items/ea79e206d7c2e990e478#configurationcustomizer%E3%82%92%E4%BD%BF%E7%94%A8%E3%81%97%E3%81%9F%E3%82%AB%E3%82%B9%E3%82%BF%E3%83%9E%E3%82%A4%E3%82%BA%E4%BE%8B

パッケージの名前空間が合っていることも確認済みです。

### 補足情報（FW/ツールのバージョンなど）

言語: Java8
FW: Spring boot 2.1.2 RELEASE
ORM: mybatis-spring-boot-starter 1.3.2

Springで@Mapperを定義しているのに「Invalid bound statement (not found)」のエラーが出る。

初めまして。閲覧ありがとうございます。

MybatisとSpringを使用しています。
そこで発生したエラーの対処法がわからないので、質問させていただきます。
初めての質問なので、不備等ございましたら、ご指摘のほどよろしくお願いいたします。
### エラー内容
```
 ERROR 16136 --- [nio-8081-exec-2] o.a.c.c.C.[.[.[.[dispatcherServlet]      : Servlet.service() for servlet [dispatcherServlet] in context with path [/learner5] threw exception [Request processing failed; nested exception is org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): curriculum.mapper.OwnerMapper.findAll] with root cause
```
下記が書いたコードになります。
```Main.java
@SpringBootApplication
@MapperScan(basePackages = {"curriculum.mapper"})
public class Main {
     public static void main(String[] args) {
          SpringApplication.run(Main.class, args);
     }
}
```
```Owners.java
@Data
@Table(name="owners")
@AllArgsConstructor
@NoArgsConstructor
public class Owners{
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Integer id;
    @Column(nullable = false)
    private String name;
}
```
```OwnerMapper.java
@Mapper
public interface OwnerMapper{
            
    List<Owners> findAll();
}
```
```OwnerMapper.xml
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="curriculum.mapper.OwnerMapper">
    <select id="findAll" resultMap="BaseResultMap">
        SELECT * FROM owners
    </select>
    <resultMap id="BaseResultMap" type="Owners" >
        <id property="id" column="id" ></id>
        <result property="name" column="name"></result>
    </resultMap>
</mapper>
```
```OwnersService.java
@Service
public class OwnersService{
    
    @Autowired
    private OwnerMapper ownerMapper;
     @Transactional
    public List<Owners> findAll() {
        return ownerMapper.findAll();
  }
}
```
```OwnersController.java
@Controller
public class OwnersController{
    @Autowired
    private OwnersService ownersService;
    
    @RequestMapping("/")
     public String index(Model model) {
         
        model.addAttribute("owners", ownersService.findAll());
        return "index";
    }
```
```application.yml
spring:
  jpa:
     open-in-view: false
  main:
    banner-mode: off
    log-startup-info: false
  datasource:
    driver-class-name: org.postgresql.Driver
    url: jdbc:postgresql://localhost:5432/testdb
    username: postgres
    password: postgres
mybatis:
  mapper-locations: classpath*:java/curriculum/mapper/*Mapper.xml
```

### 試したこと
- Mapperファイルは同じフォルダ
- 誤字脱字は何回も確認した。
- Main.javaには@MapperScanを書いてみた(MapperScanを書いた場合は@Mapperを外したりもした)
- ymlファイルにはlocationでxmlファイルを指定した
- @Paramを書いてみた
- xmlファイルのresultTypeをresultMapに変えてみた
- build.gradleにはimplementation 'org.mybatis.spring.boot:mybatis-spring-boot-starter:2.2.1'と書いてある。

何時間もこのエラーに悩んでいます。
お忙しいところ恐縮ですが、ご回答のほどよろしくお願いいたします。


MyBatis Error:Invalid bound statement (not found)の原因

MyBatisとpostgresを使ってjavaのwebアプリケーションを作成しています。
下記のようにinsertのクエリを実行するとエラーが発生してしまいます。

■MyBatisのxmlファイル
```xml
   <insert id="insertRace">	
        insert into t_race( race_id, obstacle_flg, race_name, grade, race_number, field_type, distance, rotate_type, weather, field_condition, host_id, post_time, host_date, host_times, host_days, horse_type, age_condition, product_condition, appointed_condition, sex_condition, weight_condition, insert_date, insert_user, update_date, update_user) 
        values ('${raceId}', ${obstacleFlg}, '${raceName}', '${grade}', ${raceNumber}, '${fieldType}', ${distance}, '${rotateType}', '${weather}', '${fieldCondition}', '${hostId}', ${postTime}, ${hostDate}, ${hostTimes}, ${hostDays}, ${horseType}, '${ageCondition}', ${productCondition}, ${appointedCondition}, ${sexCondition}, ${weightCondition}, CURRENT_TIMESTAMP, 'SYSTEM', CURRENT_TIMESTAMP, 'SYSTEM')
    </insert>
```


■postgresで出力されるエラー
```postgreSQL
ERROR:  syntax error at or near ":" at character 433
STATEMENT:  insert into t_race( race_id, obstacle_flg, race_name, grade, race_number, field_type, distance, rotate_type, weather, field_condition, host_id, post_time, host_date, host_times, host_days, horse_type, age_condition, product_condition, appointed_condition, sex_condition, weight_condition, insert_date, insert_user, update_date, update_user)
	        values ('201606020302', 0, '3歳未勝利', '未勝利', 2, 'ダート', 1200, '右', '曇', '良', '06', 10:40:00, 2016-03-05, 2, 3, 1, '3歳', 1, 2, 999, 4, CURRENT_TIMESTAMP, 'SYSTEM', CURRENT_TIMESTAMP, 'SYSTEM')
```

■javaのコンソール例外
```java
### Error updating database.  Cause: org.postgresql.util.PSQLException: ERROR: syntax error at or near ":"
  ポジション: 433
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: insert into t_race( race_id, obstacle_flg, race_name, grade, race_number, field_type, distance, rotate_type, weather, field_condition, host_id, post_time, host_date, host_times, host_days, horse_type, age_condition, product_condition, appointed_condition, sex_condition, weight_condition, insert_date, insert_user, update_date, update_user)          values ('201606020302', 0, '3歳未勝利', '未勝利', 2, 'ダート', 1200, '右', '曇', '良', '06', 10:40:00, 2016-03-05, 2, 3, 1, '3歳', 1, 2, 999, 4, CURRENT_TIMESTAMP, 'SYSTEM', CURRENT_TIMESTAMP, 'SYSTEM')
### Cause: org.postgresql.util.PSQLException: ERROR: syntax error at or near ":"
  ポジション: 433
; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: syntax error at or near ":"
  ポジション: 433] with root cause
org.postgresql.util.PSQLException: ERROR: syntax error at or near ":"
  ポジション: 433
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
	at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
	at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:381)
	at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:45)
	at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:73)
	at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:49)
	at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:115)
	at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:75)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:170)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:157)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:483)
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:358)
	at com.sun.proxy.$Proxy12.insert(Unknown Source)
	at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:240)
	at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:52)
	at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:53)
	at com.sun.proxy.$Proxy24.insertRace(Unknown Source)
	at jp.keiba.analitics.service.ScrapingDataService.insertRace(ScrapingDataService.java:169)
	at jp.keiba.analitics.service.ScrapingDataService.insertAll(ScrapingDataService.java:45)
	at jp.keiba.analitics.controller.scraping.UrlRaceScrpController.raceComplete(UrlRaceScrpController.java:90)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:483)
	at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221)
	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:136)
	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:110)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:817)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:731)
	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:959)
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:893)
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:968)
	at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:859)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:624)
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:844)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:121)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:423)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1079)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:745)
```

クエリに":"は使用しておらず、なぜエラーメッセージに「ERROR:  syntax error at or near ":" 」が出力されるのか、解決方法がわからず困っております。
お手数をおかけしますがお力添えをいただけると大変幸いです。
よろしくお願いいたします。

postgresでsyntax error at or near ":"が発生

#やりたいこと
Spring + MyBatisでテーブル結合を実現したい。

#問題点
SQLのSELECT結果がnullで返却されること。


#ソース

```schema
DROP TABLE IF EXISTS detail CASCADE;
DROP TABLE IF EXISTS player CASCADE;


CREATE TABLE player
(
  id character NOT NULL ,
  name character varying(256),
  age character varying(256),
  detail_id character varying(256),
  CONSTRAINT pkey PRIMARY KEY (id)
);


CREATE TABLE detail
(
  detail_id character NOT NULL ,
  work character varying(256),
  CONSTRAINT ppkey PRIMARY KEY (detail_id)
);
```

```MyBatisMapper
<select id="selectItem" resultMap="PlayerDetailMap">
  	 SELECT
	  p.id
	  ,p.name
	  ,d.work
  	 FROM
  	  player p
  	 INNER JOIN
  	  detail d
  	 ON
  	  p.detail_id=d.detail_id
  	 WHERE
  	  p.id=#{id}
  	</select>

	
    <resultMap id="PlayerDetailMap" type="com.mybatis.test.domain.PlayerEntity">
	 <id property="id" column="id" />
	 <result property="name" column="name" />
	 <collection  property="detailEntity" ofType="com.mybatis.test.domain.DetailEntity">
	  <result property="work" column="work" />
	 </collection>
	</resultMap>
```

結合する2つの元となるエンティティクラスは以下。

```PlayerEntity
@Entity
public class PlayerEntity {

	@Id
	private String id;

	private String name;
	private String age;
	private String detail_id;
	@Transient
	private List<DetailEntity> detailEntity;
```

```DetailEntity
@Entity
public class DetailEntity {

	@Id
	private String detail_id;
	private String work;
```

```Controller
@GetMapping()
	public String index(Model model) {
		PlayerDetailEntity playerDetailEntity = new PlayerDetailEntity();
		playerDetailEntity = myBatisService.selectItem("001");
		model.addAttribute("playerDetailEntity", playerDetailEntity);
		return "index";
```
```index
<div th:object="${playerDetailEntity}">
		<div>
			<label><b>名前</b></label>
			<p th:text="*{name}">
		</div>
		<div>
			<label><b>仕事</b></label>
			<p th:text="*{detailEntity.work}">
		</div>
	</div>
```

MyBatisMapper.xmlの記述が問題だと思われるのですが、
どこがイケナイのかわかりません。
ご教示お願い致します。

Spring + MyBatisでテーブル結合を実現する方法を知りたいです。

設定ファイルにXMLを使うことはままあることと思いますが、XMLは二重コメントが出来ないのでいまいち不便だと思っています。

以下のようなXMLがあった時に一時的に４～７行目をコメントアウトしたい場合に、５行目と７行目を個別にコメントアウトするのではなく、４～７行目までのまとまりでコメントアウトしたいと思っています。(もっと大きいXMLを想定しておりますので一行ずつだとやっていられない)

このようなケースで皆様がどのように運用しているのか教えて下さい。

```xml
1: <welcome-file-list>
2:     
3:     <welcome-file>index.html</welcome-file>
4:     
5:     <welcome-file>index.htm</welcome-file>
6:     
7:     <welcome-file>index.jsp</welcome-file>
8: </welcome-file-list>
```


複数ファイルを用意するとか、Gitで差分比較するとかやっていますが、不便この上無いもので。
プロパティファイルだと階層を表現できないし。。
めったに触るものでもないのですが、いじるときは毎回もどかしいです。