Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Date: Fri, 18 Nov 2011 15:52:51 +0000 (UTC)
From: "Dag H. Wanvik (Updated) (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Message-ID: 
 <1216850510.43919.1321631571660.JavaMail.tomcat@hel.zones.apache.org>
In-Reply-To: 
 <1385789185.40385.1321567551601.JavaMail.tomcat@hel.zones.apache.org>
Subject: [jira] [Updated] (DERBY-5505) BLOB and CLOB Reference Manual topics
 could use some fixes
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


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

Dag H. Wanvik updated DERBY-5505:
---------------------------------

    Attachment: blobex.java
                clobex.java

Hi Kim! Looks good! Uploading my slightly modified version of the examples.

In the Clob example I change the test while reading to be "!= -1" instead of "> 0" (0 is not EOF actually, so ">= 0" would be correct, I chose to test on -1 since the Javadoc says -1 signal EOF).

In the Blob case I change the reading out of the Blob to use a stream rather then getBytes (limit memory usage with large data). I also removed the commit statements and the comment about the autoloading. Feel free to use what you think is appropriate for your example!

                
> BLOB and CLOB Reference Manual topics could use some fixes
> ----------------------------------------------------------
>
>                 Key: DERBY-5505
>                 URL: https://issues.apache.org/jira/browse/DERBY-5505
>             Project: Derby
>          Issue Type: Improvement
>          Components: Documentation
>    Affects Versions: 10.8.2.2
>            Reporter: Kim Haase
>            Assignee: Kim Haase
>            Priority: Minor
>         Attachments: blobex.java, blobex.java, clobex.java, clobex.java
>
>
> The Reference Manual documentation on BLOBs and CLOBs has some gaps that I would like to fill as a result of my efforts to insert a BLOB into a table column. This should affect the following topics:
> CAST function (rrefsqlj33562.dita)
> CLOB data type (rrefclob.dita)
> BLOB data type (rrefblob.dita)
> A comment will provide further details.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira