activemq-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF subversion and git services (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (ARTEMIS-1590) Use properties to configure JDBC store SQLProvider
Date Fri, 12 Jan 2018 14:32:00 GMT

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

ASF subversion and git services commented on ARTEMIS-1590:
----------------------------------------------------------

Commit 938fbd81cbe242504ff6563aa7301e681f80a61c in activemq-artemis's branch refs/heads/master
from [~jmesnil]
[ https://git-wip-us.apache.org/repos/asf?p=activemq-artemis.git;h=938fbd8 ]

[ARTEMIS-1590] Properties-based SQLProvider

Replace GenericSQLProvider and other implementation by a single
PropertySQLProvider that uses properties to define SQL queries.

SQL queries are loaded from the journal-sql.properties file.
Queries specific to a DB dialect can be specified by adding a suffix to
the key of the generic property.
For example, the generic property to create a file Table is:

create-file-table = CREATE TABLE %s (ID BIGINT AUTO_INCREMENT, ...)

This property can be customized for Derby by using the
create-file-table.derby  property:

create-file-table.derby=CREATE TABLE %s (ID BIGINT NOT NULL GENERATED ALWAYS AS IDENTITY (START
WITH 1, INCREMENT BY 1),...

JIRA: https://issues.apache.org/jira/browse/ARTEMIS-1590


> Use properties to configure JDBC store SQLProvider
> --------------------------------------------------
>
>                 Key: ARTEMIS-1590
>                 URL: https://issues.apache.org/jira/browse/ARTEMIS-1590
>             Project: ActiveMQ Artemis
>          Issue Type: Improvement
>          Components: Broker
>    Affects Versions: 2.4.0
>            Reporter: Jeff Mesnil
>
> This follow up the conversation started on activemq-dev mailing list[1] to use a properties-based
implementation for Artemis SQLProvider to ease maintenance and support of different databases
and their dialects.
> [1] http://mail-archives.apache.org/mod_mbox/activemq-dev/201711.mbox/%3cCAAEH2wf_aJyvZfagLczFwpDMcWLpyDsRNio_4+k+MThdZphC6Q@mail.gmail.com%3e



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Mime
View raw message