Uploaded image for project: 'Red Hat Data Grid'
  1. Red Hat Data Grid
  2. JDG-5858

[Docs]Add a list of which column type we should use for the supported databases

XMLWordPrintable

      For jdbc and sql cache-store, would be good if we have a list of which column types we should use to be compatible with infinispan, for example:

      mysql and mariadb

      id column type = VARCHAR(255)
data column type = VARBINARY(1000)
timestamp column type = BIGINT
segment column type = BIGINT

      postgresql and postgresql plus

      id column type = VARCHAR(255)
data column type = BYTEA
timestamp column type = BIGINT
segment column type = BIGINT

      sql server

      id column type = NVARCHAR(255)
timestamp column type = BIGINT
data column type = VARBINARY(1000)
segment column type = BIGINT

      sybase

      id column type = VARCHAR(255)
data column type = IMAGE
timestamp column type = BIGINT
segment column type = BIGINT

      oracle

      id column type = VARCHAR2(255)
timestamp column type = NUMBER
data column type = RAW(1000)
segment column type = NUMBER

              dvagnero@redhat.com Dominika Borges
              rhn-support-wfink Wolf Fink
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: