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

SQL Cache store initiation fails on Sql type CHAR

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Minor
    • 15.0.0.Dev01, 14.0.7.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

    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

       

      Attachments

        Activity

          People

            wburns@redhat.com Will Burns
            tdahlen@redhat.com Torbjörn Dahlén (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: