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] Updated: (DERBY-2787) make entry for clob in connection so that temporary file is removed when a connection is closed or transaction is commited/rolledback
Date Fri, 08 Jun 2007 08:01:25 GMT

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


Mime
View raw message