[ 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 <nigro.fra@...> 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)