Named parameters support
JDB API requires indexed parameter setting. i.e. statement.setXXX(int, value). But in the DAS client
it may be helpful to provide named parameters setting on the command. This is particularly convenient
when the table involves many columns during insert/update.
Below are config schema portion supporting this.
User can do Command.setParameter(String name, Object value), getParameter(String name). Indexed set/getParameter() is available as before. Also <create>, <update>, <delete> from Config support named parameters.
example config:
if +ve index is specified in Parameter, it is used, else auto-increment is used. As List is an ordered collection, the sequence(index value) appearing in the cofig file will be maintained. Partially specifying indexes is not supported (i.e. give index for 2 out of 3 params and leave one without it, is not supported)
Also, if indexes are specified, the ordering in config is flexible, i.e. below is valid.
Note Convention over config is followed, if Parameters are not defined in config, the sequence
should match the table columns convention,else user should specify params on command in config and specify index attributes in them config