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

[Doc] sql-store examples should be updated

    XMLWordPrintable

Details

    Description

      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"
      

      Attachments

        Activity

          People

            dvagnero@redhat.com Dominika Borges
            gustavolira Gustavo Lira Silva
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: