[jira] [Commented] (ARTEMIS-1979) Table names with DB2 should be upper-cases

["ASF GitHub Bot (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/ARTEMIS-1979?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16541577#comment-16541577 ] 

ASF GitHub Bot commented on ARTEMIS-1979:
-----------------------------------------

GitHub user franz1981 opened a pull request:

    https://github.com/apache/activemq-artemis/pull/2180

    ARTEMIS-1979 Table names with DB2 should be upper-cases

    DB2 JDBC driver fail to retrieve metadata information
    if table names are lower-cases: similarly to Oracle, better
    force any table name to be upper-cases to avoid broker being
    unable to restart when lower-cases table names are used

You can merge this pull request into a Git repository by running:

    $ git pull https://github.com/franz1981/activemq-artemis ARTEMIS-1979

Alternatively you can review and apply these changes as the patch at:

    https://github.com/apache/activemq-artemis/pull/2180.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

    This closes #2180
    
----
commit 79ff3432d599ec4cd10f6613bdb2beb428aac960
Author: Francesco Nigro <ni...@...>
Date:   2018-07-12T12:48:39Z

    ARTEMIS-1979 Table names with DB2 should be upper-cases
    
    DB2 JDBC driver fail to retrieve metadata information
    if table names are lower-cases: similarly to Oracle, better
    force any table name to be upper-cases to avoid broker being
    unable to restart when lower-cases table names are used

----


> Table names with DB2 should be upper-cases
> ------------------------------------------
>
>                 Key: ARTEMIS-1979
>                 URL: https://issues.apache.org/jira/browse/ARTEMIS-1979
>             Project: ActiveMQ Artemis
>          Issue Type: Bug
>          Components: Broker
>    Affects Versions: 2.6.2
>            Reporter: Francesco Nigro
>            Assignee: Francesco Nigro
>            Priority: Minor
>             Fix For: 2.7.0
>
>
> This issue is happening on Wildfly, but it affects Artemis as well.
> To reproduce it:
>  * Configure Artemis in Wildfly to use DB2 JDBC persistence store.
>  * Redefine name of a database table and use lower case letters.
>  * Restart Wildfly
> After the restart of Wildfly, boot of Artemis component fails. It seems that if table name is in lower case, Artemis is not able to detect that the particular table exists and tries to recreate it. The create operation fails and thus initialization of JDBC driver fails as well.
> The same scenario works with Oracle 12c database: the broker is turning Oracle table names to upper cases thanks to table-names-case property on journal-sql.properties configuration file.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)