[JIRA] (JJDBC-10) Add column names to (default) CREATE state

[Rod Widdowson (Jira)]

Rod Widdowson ( https://shibboleth.atlassian.net/secure/ViewProfile.jspa?accountId=59fb32bbc24efb3c4ed3c977 ) *created* an issue

Plugin - JDBC StorageService ( https://shibboleth.atlassian.net/browse/JJDBC?atlOrigin=eyJpIjoiZWFkNjVmMGFiZjY0NDc5YzhhMWIwNDNmNjA3Yjc2NmUiLCJwIjoiaiJ9 ) / Improvement ( https://shibboleth.atlassian.net/browse/JJDBC-10?atlOrigin=eyJpIjoiZWFkNjVmMGFiZjY0NDc5YzhhMWIwNDNmNjA3Yjc2NmUiLCJwIjoiaiJ9 ) JJDBC-10 ( https://shibboleth.atlassian.net/browse/JJDBC-10?atlOrigin=eyJpIjoiZWFkNjVmMGFiZjY0NDc5YzhhMWIwNDNmNjA3Yjc2NmUiLCJwIjoiaiJ9 ) Add column names to (default) CREATE state ( https://shibboleth.atlassian.net/browse/JJDBC-10?atlOrigin=eyJpIjoiZWFkNjVmMGFiZjY0NDc5YzhhMWIwNDNmNjA3Yjc2NmUiLCJwIjoiaiJ9 )

Issue Type: Improvement Affects Versions: 1.0.0, 1.0.1, 1.0.2 Assignee: Rod Widdowson ( https://shibboleth.atlassian.net/secure/ViewProfile.jspa?accountId=59fb32bbc24efb3c4ed3c977 ) Created: 27/Jun/22 8:27 AM Fix Versions: 1.0.3 Priority: Trivial Reporter: Rod Widdowson ( https://shibboleth.atlassian.net/secure/ViewProfile.jspa?accountId=59fb32bbc24efb3c4ed3c977 )

As per https://shibboleth.atlassian.net/browse/JJDBC-5 the the table has a mismatched number of columns the create fails, which is needless.

so we need to say something like

INSERT INTO StorageRecords ('context', 'id, 'expires', 'value', 'version' ) VALUES (?, ?, ?, ?, 1)

( https://shibboleth.atlassian.net/browse/JJDBC-10#add-comment?atlOrigin=eyJpIjoiZWFkNjVmMGFiZjY0NDc5YzhhMWIwNDNmNjA3Yjc2NmUiLCJwIjoiaiJ9 ) Add Comment ( https://shibboleth.atlassian.net/browse/JJDBC-10#add-comment?atlOrigin=eyJpIjoiZWFkNjVmMGFiZjY0NDc5YzhhMWIwNDNmNjA3Yjc2NmUiLCJwIjoiaiJ9 )

Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.core&referrer=utm_source%3DNotificationLink%26utm_medium%3DEmail ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailNotificationLink&mt=8 ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100201- sha1:10a069b )
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://shibboleth.net/pipermail/commits/attachments/20220627/023cb8ca/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: jira-generated-image-static-comment-icon-e3c95d8f-2158-41e1-be28-4b59e5ffc718
Type: image/png
Size: 1084 bytes
Desc: not available
URL: <http://shibboleth.net/pipermail/commits/attachments/20220627/023cb8ca/attachment-0004.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: jira-generated-image-avatar-64d4286d-ba6e-4723-ad23-b82fbed50c20
Type: image/png
Size: 457 bytes
Desc: not available
URL: <http://shibboleth.net/pipermail/commits/attachments/20220627/023cb8ca/attachment-0005.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: jira-generated-image-static-trivial-5f86cf86-6e55-4a35-83c9-0f7af5df35aa
Type: image/png
Size: 563 bytes
Desc: not available
URL: <http://shibboleth.net/pipermail/commits/attachments/20220627/023cb8ca/attachment-0006.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: jira-generated-image-static-footer-desktop-logo-be96baa9-b218-427f-a399-b447425389b9
Type: image/png
Size: 10805 bytes
Desc: not available
URL: <http://shibboleth.net/pipermail/commits/attachments/20220627/023cb8ca/attachment-0007.png>