[
https://issues.apache.org/jira/browse/DERBY-2345?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Kristian Waagan resolved DERBY-2345.
------------------------------------
Resolution: Fixed
Fix Version/s: 10.3.0.0
Committed with revision 509375.
> 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
> Fix For: 10.3.0.0
>
> Attachments: derby-2345.diff
>
>
> 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.
