Configuring JDBC Cache Loader via CLI

[mashama]

I am trying to configure a string/binary keyed JDBC cache store via JBoss CLI.  I seem to be running into issues when trying to specify the [string/binary]-keyed-table.  How do I construct the "object" type for the keyed-table attribute? I can't find any documentation on this.

[standalone@localhost:9999 /] /subsystem=infinispan/cache-container=foo/local-cache=bar/binary-keyed-jdbc-store=BINARY_KEYED_JDBC_STORE:add(datasource=foobarDS, binary-keyed-table=[ {"dropOnExit" => "true", "createOnStart" => "true", "idColumn" => [ {"name" =>"ID_COLUMN", type => "VARCHAR(255)"}], "dataColumn" => [{"name" => "DATA_COLUMN", "type" => "BINARY"}] , "timestampColumn" => [{"name" => "TIMESTAMP_COLUMN", "type" => "BIGINT"}]}]

{

    "outcome" => "failed",

    "failure-description" => "JBAS014688: Wrong type for binary-keyed-table. Expected [OBJECT] but was STRING",

    "rolled-back" => true,

    "response-headers" => {"process-state" => "reload-required"}

}

[cyron]

you can try this

/subsystem=infinispan/cache-container=foo/local-cache=bar/

binary-keyed-jdbc-store=BINARY_KEYED_JDBC_STORE:add(datasource=foobarDS, binary-keyed-table={"id-column" => {"name" => "ID_COLUMN","type" => "VARCHAR(255)"},"data-column" => {"name" => "DATA_COLUMN","type" => "BINARY"},"timestamp-column" => {"name" => "TIMESTAMP_COLUMN","type" => "BIGINT"})