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

Anurag Shekhar updated DERBY-2787:
----------------------------------

    Attachment: derby-2787.diff

This patch makes a call to connection.addLobMapping to add entry in connection. 
Once an entry is added EmbeddedConnection takes care of calling free method 
hence clearing file.

please see the description of DERBY-2729 for more info able SQLState changes. 
This patches follows similar scheme. 

modified files

java/engine/org/apache/derby/impl/jdbc/EmbedClob.java

added call to Connection.addLobMapping in constructors.
moved checking for closed connection before check for valid flag in 
checkValidity method. This ensures that if the clob is freed because of closed 
connection proper sql code is set in SQLException.
    
java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/ClobStoredProcedureTest.java

Modified tests to get new value for locators. As the Clob now add itself to the 
connection stored procedure will be getting different value for locator. 
      
java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/BlobClob4BlobTest.java

If a clob is accessed after commit or after free SQLException gets a SSQLState 
of XJ217. Updated testClobAfterCommit to check for it.

> make entry for clob in connection so that temporary file is removed when a 
> connection is closed or transaction is commited/rolledback
> -------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-2787
>                 URL: https://issues.apache.org/jira/browse/DERBY-2787
>             Project: Derby
>          Issue Type: Bug
>          Components: JDBC
>    Affects Versions: 10.3.0.0
>            Reporter: Anurag Shekhar
>            Assignee: Anurag Shekhar
>         Attachments: derby-2787.diff
>
>


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

Reply via email to