[ https://issues.apache.org/jira/browse/DERBY-2247?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12480521 ]
Suresh Thalamati commented on DERBY-2247: ----------------------------------------- While doing some testing I ran into the LOBStreamControl.java in the stack. Couple of minor questions. 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. 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 file through LOBStreamControl.java , is this expected ? > 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.