[使用问题]: sharding使用示例

pom

```
<dependency>
     <groupId>com.mybatis-flex</groupId>
     <artifactId>mybatis-flex-spring-boot3-starter</artifactId>
     <version>1.9.2</version>
</dependency>
<dependency>
  <groupId>org.apache.shardingsphere</groupId>
  <artifactId>shardingsphere-jdbc-core-spring-boot-starter</artifactId>
   <version>5.2.1</version>
</dependency>
```

yml 配置

```
spring:
  shardingsphere:
    datasource:
      names: master
      master:
        username: root
        password: xxxxx
        url: jdbc:mysql://127.0.0.1:3306/game
        type: com.zaxxer.hikari.HikariDataSource
        driver-class-name: com.mysql.cj.jdbc.Driver

mybatis-flex:
  datasource:
    newDs:
      username: root
      password: 12345
      url: jdbc:mysql://127.0.0.1:3306/game_new
  configuration:
    map-underscore-to-camel-case: true
```

实体类

```
import com.mybatisflex.annotation.Id;
import com.mybatisflex.annotation.KeyType;
import com.mybatisflex.annotation.Table;
import lombok.Data;

import java.io.Serial;
import java.io.Serializable;
import java.time.LocalDateTime;

@Data
@Table("client_show")
public class ClientShow implements Serializable {
    @Serial
    private static final long serialVersionUID = 1L;

@Id(keyType = KeyType.Auto)
    private Long id;

private String interfaceName;

private Long userId;

private String data;

private LocalDateTime requestTime;
}
```

Mapper

```
import bt.game.entity.ClientShow;
import com.mybatisflex.annotation.UseDataSource;
import com.mybatisflex.core.BaseMapper;

@UseDataSource("master")
public interface ClientShowMapper extends BaseMapper<ClientShow> {

}
```

Service

```
import bt.game.entity.ClientShow;
import bt.game.mapper.ClientShowMapper;
import jakarta.annotation.Resource;
import lombok.extern.slf4j.Slf4j;
import org.springframework.stereotype.Service;

import java.time.LocalDateTime;

@Service
@Slf4j
public class ClientShowService {

@Resource
    private ClientShowMapper clientShowMapper;

public void save(Long userId) {
        ClientShow clientShow = new ClientShow();
        clientShow.setUserId(userId);
        clientShow.setInterfaceName("interfaceName");
        clientShow.setData("data");
        clientShow.setRequestTime(LocalDateTime.now());
        this.clientShowMapper.insert(clientShow);
    }
}
```

报错信息

```
org.mybatis.spring.MyBatisSystemException: null

------------------------------------------------

Caused by: org.apache.ibatis.exceptions.PersistenceException: 
### Error updating database.  Cause: java.lang.IllegalStateException: Cannot get target dataSource by key: "master"
### The error may exist in bt/game/mapper/ClientShowMapper.java (best guess)
### The error may involve bt.game.mapper.ClientShowMapper.insert
### The error occurred while executing an update
### Cause: java.lang.IllegalStateException: Cannot get target dataSource by key: "master"
	at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30) ~[mybatis-3.5.15.jar:3.5.15]
	at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:199) ~[mybatis-3.5.15.jar:3.5.15]
	at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:184) ~[mybatis-3.5.15.jar:3.5.15]
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103) ~[na:na]
	at java.base/java.lang.reflect.Method.invoke(Method.java:580) ~[na:na]
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java
```

MyBatis-Flex/MyBatis-Flex

内容风险标识

评论 (5)

MyBatis-Flex/MyBatis-Flex .gitee-modal { width: 500px !important; }

内容风险标识