[jira] [Comment Edited] (CALCITE-1955) Cannot insert blob into Avatica-HSQLDB table because table is read only

["Francis Chuang (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CALCITE-1955?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16131725#comment-16131725 ] 

Francis Chuang edited comment on CALCITE-1955 at 8/18/17 5:05 AM:
------------------------------------------------------------------

[~elserj] No problem. I'll dig into the HSQLDB docs to see if there's anything relevant in there.

Possibly relevant: https://stackoverflow.com/questions/39443288/how-to-create-a-large-object-clob-in-a-hsqldb-resource-database


was (Author: francischuang):
[~elserj] No problem. I'll dig into the HSQLDB docs to see if there's anything relevant in there.

> Cannot insert blob into Avatica-HSQLDB table because table is read only
> -----------------------------------------------------------------------
>
>                 Key: CALCITE-1955
>                 URL: https://issues.apache.org/jira/browse/CALCITE-1955
>             Project: Calcite
>          Issue Type: Bug
>          Components: avatica
>            Reporter: Francis Chuang
>
> This might be more of a question as I am not able to find official information in the HSQLDB docs.
> I am porting a test to test the insertion of binary data into a table from Phoenix to HSQLDB. The test passes when using Phoenix with avatica.
> 1. I created this table:
> {code}
> CREATE TABLE some_table (
> 	int INTEGER PRIMARY KEY,
> 	bin BLOB
> )
> {code}
> 2. I attempt to insert the data using `INSERT INTO some_table (int, bin) VALUES (?, ?)`
> The binary is being sent as a `Rep_BYTE_STRING` and the data is placed in byte_values.
> This is the error I receive from HSQLDB:
> {code}
> RuntimeException: java.sql.SQLException: org.hsqldb.HsqlException: The table data is read only -> SQLException: org.hsqldb.HsqlException: The table data is read only -> HsqlException: org.hsqldb.HsqlException: The table data is read only -> HsqlException: The table data is read only
> {code}



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)