Uploaded image for project: 'Infinispan'
  1. Infinispan
  2. ISPN-14278

[Doc] sql-store examples should be updated

This issue belongs to an archived project. You can view it, but you can't modify it. Learn more

XMLWordPrintable

      The section https://infinispan.org/docs/14.0.x/titles/configuring/configuring.html#sql-store-query-configuration_persistence has some wrong configurations:

      The following query

       

      CREATE TABLE Person (
        name VARCHAR(255) NOT NULL,
        picture VARBINARY(255),
        sex VARCHAR(255),
        birthdate TIMESTAMP,
        accepted_tos BOOLEAN,
        notused VARCHAR(255),
        PRIMARY KEY (name)
      );
      

      picture VARBINARY(255) should be   picture BYTEA. Also let make it more explicit that this example is for postgres

      Missing ; after Protobuff package

      It's missing connection-pool connection-url="" on the cache configuration

      Schema on cache configuration is wrong:

      Schema is wrong

       

      <query-jdbc-store xmlns="urn:infinispan:config:store:jdbc:14.0"

       Should be
      Schema is wrong

      <query-jdbc-store xmlns="urn:infinispan:config:store:sql:14.0"
      

              dvagnero@redhat.com Dominika Borges
              gustavolira Gustavo Lira Silva
              Archiver:
              rhn-support-adongare Amol Dongare

                Created:
                Updated:
                Resolved:
                Archived: