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

[RH Bugzilla Integration (JIRA)]

    [ https://issues.jboss.org/browse/ISPN-2155?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12708059#comment-12708059 ] 

RH Bugzilla Integration commented on ISPN-2155:
-----------------------------------------------

Martin Gencur <mgencur at redhat.com> made a comment on [bug 841896|https://bugzilla.redhat.com/show_bug.cgi?id=841896]

This does not work fully correctly yet. I changed one of our tests to have TABLE_NAME_PREFIX = "edg/bin". With 5.1.5.FINAL-redhat-1  the test failed on creating the table. With 5.1.6.FINAL-redhat.-1 it fails on storing the data into the table. Attaching stacktraces for both 5.1.5 and 5.1.6.
                
> 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.6.FINAL (JDG), 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?

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira