[jira] Commented: (DERBY-2247) provide set methods for blob in embeded driver

["Anurag Shekhar (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/DERBY-2247?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12497347 ] 

Anurag Shekhar commented on DERBY-2247:
---------------------------------------

Sorry I had missed suresh's query and comment.

1) LOBStreamControl.java : isValidPostion()
   if (pos > tmpFile.length())
         throw Util.generateCsSQLException(
           SQLState.BLOB_POSITION_TOO_LARGE, new Long(pos + 1));


isValidPosition() is called on most of the read/write. I think calling
a file length call can be expensive for each read/write call.

I will check how can I reduce it. Probably having a length variable in the control class itself will help.

 
2) Are blobs written to temp files for some special cases ?
I was just using BaseJdbcTestCase.java: assertEquals(Blob b1, Blob b2)
method in my test. It was triggering the writes to temp 

Yes if blob size exceeds 4k its written into the file and subsequent blob operations are operated on file. 

> provide set methods for blob in embeded driver
> ----------------------------------------------
>
>                 Key: DERBY-2247
>                 URL: https://issues.apache.org/jira/browse/DERBY-2247
>             Project: Derby
>          Issue Type: Sub-task
>          Components: JDBC
>         Environment: all
>            Reporter: Anurag Shekhar
>         Assigned To: Anurag Shekhar
>            Priority: Minor
>         Attachments: derby-2247-followup.diff, derby-2247-v3-usingStoreFactory.diff, derby-2247-v4-usingStoreFactory.diff, derby-2247.diff, derby-2247v2-using_StoreFactory.diff
>
>


-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.