The documentation on using complex parameters needs to be more detailed. Full examples, including type handlers would help a lot.

Some specifics to be clarified:

  • When using a map, should the type be map, hashmap, java.util.Map, java.util.HashMap, or anything else?
  • How to implement a type handler for a complex type (a custom type defined in the DB, ie. when using jdbcType=STRUCT and jdbcTypeName=MyDbTypeName).
  • How to handle complex OUT parameters.
  • In this particular example from the documentation, #{middleInitial, mode=OUT, jdbcType=STRUCT, jdbcTypeName=MY_TYPE, resultMap=departmentResultMap}, what does the resultMap have to do with the parameter?

Comment From: lliule

well,i have same question with you,and if I have a column ,that javaType is Struct,I cann't use Cache,will throw Exception.what can we do to detail?

Comment From: artemik

+1 The documentation doesn't even have a dedicated section for stored procedures. Google returns almost nothing. It must be improved.

Comment From: pshem

Thank you! The method specified in this issue allowed me to use Table Valued Parameters in SQL Server. This should definitely be added to the documentation.