[
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)
