db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rick Hillegas (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DERBY-6825) Add basic JSON support to Derby.
Date Tue, 08 Sep 2015 03:27:45 GMT

     [ https://issues.apache.org/jira/browse/DERBY-6825?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel

Rick Hillegas updated DERBY-6825:
    Attachment: derby-6825-05-aa-toClobFunction.diff

Attaching derby-6825-05-aa-toClobFunction.diff. This patch adds a arrayToClob() function to
the simpleJson optional tool. The arrayToClob() function converts a JSONArray into a Clob.
Tests passed cleanly for me on this patch.

Touches the following files:


M       java/optional/org/apache/derby/optional/api/SimpleJsonUtils.java
M       java/optional/org/apache/derby/optional/json/SimpleJsonTool.java

Makes the simpleJson tool create a method with this signature:

create function arrayToClob( jsonDocument JSONArray ) returns clob
language java parameter style java no sql
external name 'org.apache.derby.optional.api.SimpleJsonUtils.arrayToClob'


M       java/testing/org/apache/derbyTesting/functionTests/tests/lang/SimpleJsonTest.java

Regression test for the new function.

> 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:
>            Reporter: Rick Hillegas
>            Assignee: Rick Hillegas
>             Fix For:
>         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,
> 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

View raw message