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] Assigned: (DERBY-2345) truncate on a Blob does not work when the Blob is in memory
Date Fri, 16 Feb 2007 13:14:05 GMT

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

Anurag Shekhar reassigned DERBY-2345:
-------------------------------------

    Assignee: Anurag Shekhar

> truncate on a Blob does not work when the Blob is in memory
> -----------------------------------------------------------
>
>                 Key: DERBY-2345
>                 URL: https://issues.apache.org/jira/browse/DERBY-2345
>             Project: Derby
>          Issue Type: Bug
>          Components: JDBC
>            Reporter: V.Narayanan
>         Assigned To: Anurag Shekhar
>            Priority: Minor
>
> I tried the following repro. After calling the truncate the Blob object still returns
the length as 29 (its original length) . 
> import java.sql.*;
> public class TruncateBugRepro {
>     
>     Connection con = null;
>     
>     public Connection getEmbeddedConnection() throws Exception {
>         if(con == null) {
>             Class.forName("org.apache.derby.jdbc.EmbeddedDriver");
>             con = DriverManager.getConnection
>                 ("jdbc:derby:DB1;create=true");
>         }
>         return con;
>     }
>     
>     public void testTruncate() throws Exception {
>         //String used to getBytes from and insert into Blob.
>         String str = new String("I am a Blob!!! I am a Blob!!!");
>         Connection con = getEmbeddedConnection();
>         //create the blob
>         Blob blob = con.createBlob();
>         //insert bytes
>         blob.setBytes(1,str.getBytes());
>         //Retuns the Blob length as 29
>         System.out.println("" + blob.length());
>         blob.truncate(14);
>         //returns the Blob length as 29
>         System.out.println("" + blob.length());
>     }
>     
>     public static void main(String[] args) throws Exception {
>         TruncateBugRepro t = new TruncateBugRepro();
>         t.testTruncate();
>     }
> }

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