This is an automated email from the ASF dual-hosted git repository.
jbertram pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/activemq-artemis.git
The following commit(s) were added to refs/heads/main by this push:
new 3b0064a3e0 ARTEMIS-5789 fix capitalization for SQL queries
3b0064a3e0 is described below
commit 3b0064a3e07e08123014d923bc28efadffff62c4
Author: Justin Bertram <[email protected]>
AuthorDate: Wed Dec 3 08:14:41 2025 -0600
ARTEMIS-5789 fix capitalization for SQL queries
---
artemis-jdbc-store/src/main/resources/journal-sql.properties | 4 ++--
1 file changed, 2 insertions(+), 2 deletions(-)
diff --git a/artemis-jdbc-store/src/main/resources/journal-sql.properties
b/artemis-jdbc-store/src/main/resources/journal-sql.properties
index fe0b113e7d..a0958e3bb8 100644
--- a/artemis-jdbc-store/src/main/resources/journal-sql.properties
+++ b/artemis-jdbc-store/src/main/resources/journal-sql.properties
@@ -18,10 +18,10 @@
# Generic SQL statements
create-file-table=CREATE TABLE %s (ID BIGINT AUTO_INCREMENT, FILENAME
VARCHAR(255), EXTENSION VARCHAR(10), DATA BLOB, PRIMARY KEY(ID))
-create-file-index=CREATE INDEX %1$s_IDX ON %1$s (fileName)
+create-file-index=CREATE INDEX %1$s_IDX ON %1$s (FILENAME)
insert-file=INSERT INTO %s (FILENAME, EXTENSION, DATA) VALUES (?,?,?)
select-filenames-by-extension=SELECT FILENAME, ID FROM %s WHERE EXTENSION=?
-select-file-by-filename=SELECT ID, FILENAME, EXTENSION FROM %s WHERE fileName=?
+select-file-by-filename=SELECT ID, FILENAME, EXTENSION FROM %s WHERE FILENAME=?
append-to-file=SELECT DATA FROM %s WHERE ID=? FOR UPDATE
read-large-object=SELECT DATA FROM %s WHERE ID=?
delete-file=DELETE FROM %s WHERE ID=?
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
For further information, visit: https://activemq.apache.org/contact
