[
https://issues.apache.org/jira/browse/DERBY-6825?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14736825#comment-14736825
]
Bryan Pendleton commented on DERBY-6825:
----------------------------------------
I updated to the head of trunk and tried some more experiments; the
new arrayToClob function worked great for me! Thanks for incorporating
this last-minute suggestion.
> Add basic JSON support to Derby.
> --------------------------------
>
> Key: DERBY-6825
> URL: https://issues.apache.org/jira/browse/DERBY-6825
> Project: Derby
> Issue Type: Improvement
> Components: SQL
> Affects Versions: 10.12.0.0
> Reporter: Rick Hillegas
> Assignee: Rick Hillegas
> Fix For: 10.12.0.0
>
> Attachments: SimpleJsonVTI.java, derby-6825-01-aa-optionalTool.diff,
> derby-6825-01-ab-optionalTool.diff, derby-6825-02-aa-vti.diff,
> derby-6825-03-aa-datatypeTests.diff, derby-6825-04-aa-grantPrivileges.diff,
> derby-6825-05-aa-toClobFunction.diff
>
>
> Other database are adding support for the popular JSON data interchange
> format defined by https://www.ietf.org/rfc/rfc4627.txt. We could add a VTI to
> Derby which would unpack a JSON document into a set of rows. We could also
> add a reverse transformation, which turns a query result into a JSON document.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)