You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Anurag Shekhar (JIRA)" <ji...@apache.org> on 2007/02/16 14:14:05 UTC
[jira] Assigned: (DERBY-2345) truncate on a Blob does not work when
the Blob is in memory
[ 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.