[java-plugin-storage-jdbc] branch main updated: JJDBC-10 Add column names to (default) CREATE statement

[Rod Widdowson]

This is an automated email from the git hooks/post-receive script.

rdw pushed a commit to branch main
in repository java-plugin-storage-jdbc.

View the commit online:
http://git.shibboleth.net/view/?p=java-plugin-storage-jdbc.git;a=commit;h=cd519ac86c3e24b25559fb509b63307c746a5b5e

The following commit(s) were added to refs/heads/main by this push:
     new cd519ac  JJDBC-10 Add column names to (default) CREATE statement
cd519ac is described below

commit cd519ac86c3e24b25559fb509b63307c746a5b5e
Author: Rod Widdowson <rdw at steadingsoftware.com>
AuthorDate: Mon Jun 27 13:33:19 2022 +0100

    JJDBC-10 Add column names to (default) CREATE statement
    
    https://shibboleth.atlassian.net/browse/JJDBC-10
---
 .../net/shibboleth/plugin/storage/jdbc/impl/JDBCStorageService.java     | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/jdbc-storage-impl/src/main/java/net/shibboleth/plugin/storage/jdbc/impl/JDBCStorageService.java b/jdbc-storage-impl/src/main/java/net/shibboleth/plugin/storage/jdbc/impl/JDBCStorageService.java
index 67f3a27..aa10644 100644
--- a/jdbc-storage-impl/src/main/java/net/shibboleth/plugin/storage/jdbc/impl/JDBCStorageService.java
+++ b/jdbc-storage-impl/src/main/java/net/shibboleth/plugin/storage/jdbc/impl/JDBCStorageService.java
@@ -80,7 +80,7 @@ public final class JDBCStorageService extends AbstractStorageService implements
     static final String DEFAULT_PRE_CREATE_QUERY_SQL = "SELECT expires FROM StorageRecords WHERE context =? AND id=?";
 
     /** The SQL to create a new record. */
-    static final String DEFAULT_CREATE_CREATE_RECORD_SQL = "INSERT INTO StorageRecords VALUES (?, ?, ?, ?, 1)";
+    static final String DEFAULT_CREATE_CREATE_RECORD_SQL = "INSERT INTO StorageRecords(context, id, expires, value, version) VALUES (?, ?, ?, ?, 1)";
 
     /** The SQL to update an expired record as part of a create. */
     static final String DEFAULT_CREATE_UPDATE_RECORD_SQL =

-- 
To stop receiving notification emails like this one, please contact
the administrator of this repository.