db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Anurag Shekhar (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-2247) provide set methods for blob in embeded driver
Date Mon, 21 May 2007 04:16:16 GMT

    [ 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.

View raw message