ProviderSqlSource#createSqlSource passed a wrong type to languageDriver#createSqlSource

[mindfn]

mybatis: latest

After I use mybaits-generator to generate dynamic-sql
so it will use ProviderSqlSource, the parameterObject will always be xxxProvider;

When parsing sql with RawSqlSource, the ParameterMapping#JavaType will always be java.lang.Object;

I'm wondering if there is any way to make sure the ParameterMapping to get the proper type;

Because in the current scenario; if I register a JsonTypeHanlder like the following; the clazz here will become Java.lang.Object

public class JsonTypeHandler<T> extends BaseTypeHandler<T> {
    
    private final Class<T> clazz;

    public JsonTypeHandler(Class<T> clazz) {
        // Java.lang.Object
        this.clazz = clazz;
    }

    @Override
    public void setNonNullParameter(PreparedStatement ps, int i, T parameter, JdbcType jdbcType) throws SQLException {    
    }
}

[jeffgbutler]

The type handler will be calculated based on the type of the object in the parameter map - it won't be xxxProvider. But this sometimes fails, so it is best to explicitly set the type handler. The generator allows you to do this, and it will carry into the generated code.

In the generator configuration, do something like this:

<table tableName="some_table">
  <columnOverride column="some_column" typeHandler="foo.JsonTypeHandler"/>
</tableName>

[mindfn]

thanks for your reply.

In fact, I am using org.mybatis.dynamic.sql.util.mybatis3#insert to save the data, So parameterObject is DefaultInsertStatementProvider;

Therefore, the MetaClass obtained by parsing parameterType (DefaultInsertStatementProvider) cannot find "row.xxx";
(SqlSourceBuilder#buildParameterMapping), then it will continue to try to get the JavaType by "originSql";
only if JavaType is missing from "original Sql", Object.class will be used;
So we need to add 'forceJavaTypeIntoMapping' in the generator configuration to avoid this situation

<table tableName="some_table">
  <columnOverride column="some_column" typeHandler="foo.JsonTypeHandler">
     <property name="forceJavaTypeIntoMapping" value="true"/>
  </columnOverride>
</tableName>

https://mybatis.org/generator/configreference/columnOverride.html

[jeffgbutler]

Glad you found the solution!