GitHub user jmesnil opened a pull request:
https://github.com/apache/activemq-artemis/pull/1756
[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
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/jmesnil/activemq-artemis
ARTEMIS-1590_JDBC_PropertySQLProvider
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/activemq-artemis/pull/1756.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 #1756
----
commit 69e352015f5e33bc833976acea7e2edabafe1273
Author: Jeff Mesnil <jmesnil@...>
Date: 2018-01-05T10:54:48Z
[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
----
---
