1 Reply Latest reply on Mar 26, 2013 10:28 PM by cyron

    Configuring JDBC Cache Loader via CLI

    Mashama McFarlane Novice

      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"}

      }

        • 1. Re: Configuring JDBC Cache Loader via CLI
          cyron Newbie

          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"})