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

SQL Cache store initiation fails on Sql type CHAR

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

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Minor Minor
    • 14.0.7.Final, 15.0.0.Final
    • 14.0.2.Final
    • None
    • None
    • Hide
      1. Deploy Postgresql 10.23 in Openshift
      2. Create the DB rpi-store
      3. Create the table model according to the above description
      4. Deploy Inifinispan Cluster in Openshift using the 8.4.1 Data Grid Operator
      5. Create the cache according to the above description
      Show
      Deploy Postgresql 10.23 in Openshift Create the DB rpi-store Create the table model according to the above description Deploy Inifinispan Cluster in Openshift using the 8.4.1 Data Grid Operator Create the cache according to the above description

      When creating a cache as follows:

      {
          "distributed-cache": {
            "mode": "SYNC",
            "encoding": {
              "key":

      {           "media-type": "application/x-protostream"         }

      ,
              "value":

      {           "media-type": "application/x-protostream"         }

            },
            "persistence": {
              "table-jdbc-store": {
                "shared": true,
                "segmented": false,
                "dialect": "POSTGRES",
                "table-name": "model",
                "connection-pool":

      {             "connection-url": "jdbc:postgresql://postgresql:5432/rpi-store",             "driver": "org.postgresql.Driver",             "username": "user",             "password": "secret"           }

              }
            }
          }
        }

       

      With the table:

      create table model (

         id integer primary key,

         name char(20),

         model char(20),

         soc char(20),

         memory_mb integer,

         ethernet boolean,

         release_year integer

      );

       

      The cache creation fails with the error

      Caused by: java.lang.IllegalArgumentException: SqlType not supported: 1

       

              wburns@redhat.com Will Burns
              tdahlen@redhat.com Torbjörn Dahlén
              Archiver:
              rhn-support-adongare Amol Dongare

                Created:
                Updated:
                Resolved:
                Archived: