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

JDBC cache store should quote generated table name

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

XMLWordPrintable

      The jdbc cache stores auto-generate the table name used to store cache contents by prefixing the cache name with some specified/default prefix. However, if the cache name contains characters other than a letter, number, underscore, or period; the table creation fails.
      In AS7, the cache name of a typical cache used for web sessions looks like: //default-host/mycontext This obviously generates a invalid table name.
      If the table name were instead to be quoted (if supported by the DBMS (see java.sql.DatabaseMetaData#getIdentifierQuoteString()), then the table name generated using the above cache name would be valid.
      If we don't want to always quote the table name, then perhaps this could be enabled via a quoteTableName flag?

              ttarrant@redhat.com Tristan Tarrant
              pferraro@redhat.com Paul Ferraro
              Archiver:
              rhn-support-adongare Amol Dongare

                Created:
                Updated:
                Resolved:
                Archived: