Enriching the original mybatis-spring configuration properties

The work is great! thanks.
I just found that if there is a tag collection in resultMap, it will return empty.

I found there is only 1 record, the code return null.

By using the project sample, after run the following sql:

delete from emp where dept_no in (2,3,4);
delete from dept where dept_no in (2,3,4);

The test case will failed.

    @Test
    public void testGetDeptWithEmpCount() throws Exception {
        this.reactiveSqlSessionOperator.executeMany(
                this.deptMapper.selectDeptWithEmpList())
                .as(StepVerifier::create)
                .expectNextCount(1)
                .verifyComplete();
    }

I guess the problem is in the mybatis-r2dbc\src\main\java\pro\chenggang\project\reactive\mybatis\support\r2dbc\executor\result\handler\DefaultReactiveResultHandler.java
the totalCount is 0 in this case.

    private List<Object> handleRowValuesForNestedResultMap(RowResultWrapper rowResultWrapper, ResultMap resultMap) throws SQLException {
        // ...
        this.resultHolder.addAll(resultHandler.getResultList());
        if (totalCount.intValue() != 0 && null == partialObject) {
            List<Object> holdResultList = new ArrayList<>(this.resultHolder);
            this.resultHolder.clear();
            return holdResultList;
        }
        return Collections.singletonList(DEFERRED);
}

The following content worked when use mybatis, but failed when use mybatis_r2dbc,

<insert id="insert" parameterType="SysUser" useGeneratedKeys="true" keyProperty="userId">

To get the mybatis_r2dbc working, I have to provide values for keyColumn elements

<insert id="insert" parameterType="SysUser" useGeneratedKeys="true" keyProperty="userId" keyColumn="user_id">

refactor sql dialect placeholder with cache

有完整的demo可以看看吗

1. Check R2DBC-1.0.0 change log
2. Adapted to version 1.0.0 of R2DBC if necessary

@MapperScan is not work!

@SpringBootApplication
@MapperScan({"xx.mapper"})
public class Application {
   ...
}

throw exception:

Caused by: java.lang.IllegalArgumentException: Property 'sqlSessionFactory' or 'sqlSessionTemplate' are required
	at org.springframework.util.Assert.notNull(Assert.java:201)
	at org.mybatis.spring.support.SqlSessionDaoSupport.checkDaoConfig(SqlSessionDaoSupport.java:122)
	at org.mybatis.spring.mapper.MapperFactoryBean.checkDaoConfig(MapperFactoryBean.java:73)
	at org.springframework.dao.support.DaoSupport.afterPropertiesSet(DaoSupport.java:44)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1863)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1800)
	... 101 more

Change to @Mapper is worked!

我看源码发现DefaultReactiveSqlSession.openSession()返回的ReactiveSqlSession不是新创建的，而是一个全局变量。这样导致所有线程设置的事务等参数都是在同一个ReactiveSqlSession上进行的，会相互覆盖。另外，我发现并发的时候由于用的是同一个sqlSession，所有跟数据库的通讯都是串行执行的，无论并发量多大，数据库查到都只有一个连接。不知道能否优化？难道要动态创建新的DefaultReactiveSqlSession吗？

Introduce Spring's AliasFor declaration in MapperScan #462

Not support springboot3.0

Mybatis Default EnumTypeHandler is Not be auto register,
I Got a ClassCastException by Enum.
Need I Register it by manual ?
Or
Need I implement a R2dbcTypeHandlerAdapter?

@R2dbcMapperScan include a @repository throws exception:

Caused by: java.lang.ClassNotFoundException: net.bytebuddy.renamed.java.lang.Object$ByteBuddy$hogupVqa at java.base/jdk.internal.loader.BuiltinClassLoader.loadClass(BuiltinClassLoader.java:606) at java.base/jdk.internal.loader.ClassLoaders$AppClassLoader.loadClass(ClassLoaders.java:168) at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:522)

@R2dbcMapperScan("xxx.r2dbc.mapper")
public class WorkerIdAutoConfigure {
//...
}

@Repository
public interface R2dbcWorkerNodeMapper {
//...
}

Just remove @repository, It's worked!

link dependency upgrade #64

When using AbstractRoutingConnectionFactory(From spring-data-r2dbc) with multi database. The way PlaceholderFormatter gets the database type in purpose of formatting sql with different dialect is through ConnectionFactory.getMetadata(), the way currently used that does not work with different types of databases.this should be changed to Connection.getMetadata() in order to work properly with multiple types of databases.

我想问一下就是如何用这个reactive-mybatis-support如何连接达梦数据库并操作呢，目前有没有这样的计划或者有什么解决办法，我看项目分支都没有这个，因此问一下，感谢您的回答。

Recent version of spring boot 3.0 does not recognise and autostart R2dbcMybatisAutoConfiguration from mybatis-r2dbc-spring.
Class must be annotated with @AutoConfiguration instead of @Configuration. spring.factories still work but is deprecated too. Found some explanation here https://stackoverflow.com/a/75708952/1194528

Remove usage of NestedIOException #663

follow up mybatis PR #2627

我在maven中配置后无法下载jar包，

Like spring-data-r2dbc mentioned：

As #53 mentioned , When using useGeneratedKeys="true" in insert sql, there should be a check for keyColumn="xxxx"

Following Mybatis - 3.5.10's new feature:

• Argument name based constructor auto-mapping

• 1. Use resultOrdered to reduce the cache generated when nested-result-map processing
• 2. Make ReactiveResultHandler's handleResult method return single value

Exception with useGeneratedKeys set to false. same code set to true will be worked!

Suppressed: java.lang.ClassCastException: class java.lang.Long cannot be cast to class java.lang.Integer (java.lang.Long and java.lang.Integer are in module java.base of loader 'bootstrap')

...
        <dependency>
            <groupId>org.mariadb</groupId>
            <artifactId>r2dbc-mariadb</artifactId>
            <version>1.1.3</version>
        </dependency>
...

This is my test code in mapper:

//  create table TEST1(ID bigint NOT NULL AUTO_INCREMENT , NAME VARCHAR(10) NULL, PRIMARY KEY(ID));
  @Insert("INSERT INTO TEST1(NAME)" +
      " VALUES(#{name})")
  @Options(useGeneratedKeys = true, keyProperty = "id", keyColumn = "ID")
  Mono<Integer> addTest1(Tmod mod);  // **This is Worked.**

  @Insert("INSERT INTO TEST1(NAME)" +
      " VALUES(#{name})")
  @Options(useGeneratedKeys =false)
  Mono<Integer> addTest1( @Param("name")String name); // **This throws  Exception**

//  create table TEST2(ID bigint NOT NULL  , NAME VARCHAR(10) NULL, PRIMARY KEY(ID));
  @Insert("INSERT INTO TEST2(ID,NAME)" +
      " VALUES(#{id},#{name})")
  Mono<Integer> addTest2(@Param("id") long id, @Param("name")String name);// **This throws  Exception too**

Return type change to Mono<Long> is same exception.

Even if mapperLocations were not specified (= null), library still shows warning:
Property 'mapperLocations' was specified but matching resources are not found.
That's because resolveMapperLocations() method never returns null. The fix should be as follows: resolveMapperLocations() should return null if mapperLocations==null.

Hi, i am reading your project and i am interested in this, but i have a question, why do you use R2DBC instead of other non blocking IO like Hibernate Reactive or others... can you tell me your purpose, the pros and cons of R2DBC, thank you so much

If Query return null , current is return Mono.emty can't map or other operation like this:

Mono<Tmod> getSomething(@Param("id") long id);
getSomething(1l).map(obj -> {
      if (obj == null) 
         ...
         can't work
});

So if return Optional is best , but is not support in this version.

Optional is work fine in mabatis jdbc.

Mono<Optional<Tmod>> getSomething(@Param("id") long id);

getSomething(1l).map(obj -> obj.orElse(...));

Refactor PlaceholderFormatter

Subj exception thrown when using @insert or @update annotations. DefaultReactiveMybatisExecutor.doUpdateWithConnection contains bug: result.getRowsUpdated() returns Long but later collected as Integer: Collectors.summingInt(Integer::intValue)

提供的例子reactive-mybatis-support-examples，驱动换成postgresql 连接postgreql 无法启动