Need better documentation on complex parameters in stored procedure calls

[rwf-hcl]

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?

[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?

[artemik]

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

[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.