[infinispan-issues] [JBoss JIRA] (ISPN-2155) JDBC cache store should quote generated table name

JDBC cache store should quote generated table name -------------------------------------------------- Key: ISPN-2155 URL: https://issues.jboss.org/browse/ISPN-2155 Project: Infinispan Issue Type: Bug Components: Loaders and Stores Affects Versions: 5.1.5.FINAL Reporter: Paul Ferraro Assignee: Tristan Tarrant Labels: jdg, jdg6 Fix For: 5.1.x, 5.2.0.ALPHA3, 5.2.0.FINAL Attachments: infinispan-cachestore-jdbc-5.1.4.FINAL-redhat-1.jar 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?