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