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

SQL Cache store initiation fails on Sql type CHAR

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
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: