Package java.sql

Examples of java.sql.Blob.truncate()

97
98
99
100
101
102
103
104
105
106
107
            assertEquals (data1 [i], data2 [i]);
        data2 = blob.getBytes (5 * BUFFER_SIZE + 1, UPDATE_SIZE);
        for (int i = 0; i < UPDATE_SIZE; i++)
            assertEquals (data1 [i], data2 [i]);
        //test truncate
        blob.truncate (BUFFER_SIZE);
        assertEquals ("truncate failed", BUFFER_SIZE, blob.length());
        rs.close();
        con.commit();
        stmt.close();
        pstmt.close();
View Full Code Here
168
169
170
171
172
173
174
175
176
177
178
        for (int i = 0; i < 100; i++) {
            data [i] = (byte) i;
        }
        blob.setBytes (1, data);
        assertEquals (blob.length(), 100);
        blob.truncate (50);
        assertEquals (blob.length(), 50);
        blob.setBytes (1, data);
        assertEquals ("set failed", blob.length(), 100);
        blob.truncate (50);
        assertEquals ("truncation failed", blob.length(), 50);
View Full Code Here
172
173
174
175
176
177
178
179
180
181
182
        assertEquals (blob.length(), 100);
        blob.truncate (50);
        assertEquals (blob.length(), 50);
        blob.setBytes (1, data);
        assertEquals ("set failed", blob.length(), 100);
        blob.truncate (50);
        assertEquals ("truncation failed", blob.length(), 50);
        rs.close();
        con.commit();
        stmt.close();
        pstmt.close();
View Full Code Here
126
127
128
129
130
131
132
133
134
135
136
        assertTrue(rs.next());
        Blob blob = rs.getBlob("DATA");

        assertEquals(100, blob.length());

        blob.truncate(50);
        assertEquals(50, blob.length());

        blob.truncate(150);
        assertEquals(150, blob.length());
View Full Code Here
129
130
131
132
133
134
135
136
137
138
139
        assertEquals(100, blob.length());

        blob.truncate(50);
        assertEquals(50, blob.length());

        blob.truncate(150);
        assertEquals(150, blob.length());

        data = blob.getBytes(1, 200);
        assertEquals(150, data.length);
        for (byte i=0; i<50; i++) {
View Full Code Here
53
54
55
56
57
58
59
60
61
62
63
        rs.next();
        Blob blob = rs.getBlob (1);
        InputStream is = blob.getBinaryStream();
        long l = is.skip (20);
        //truncate blob after accessing original stream
        blob.truncate (l);
        int ret = is.read();
        //should not be able to read after truncated value
        assertEquals ("stream update failed", -1, ret);
        byte [] buffer = new byte [1024];
        for (int i = 0; i < buffer.length; i++)
View Full Code Here
408
409
410
411
412
413
414
415
416
417
418
      ReadStream readStream = file.openRead();

      if (_lob instanceof Blob) {
        Blob blob = (Blob) _lob;
        blob.truncate(0);

        if (_outputStream != null)
          _outputStream.close();

        _outputStream = blob.setBinaryStream(0);
View Full Code Here
712
713
714
715
716
717
718
719
720
721
722
      case OracleModule.OCI_D_FILE:
        break;
      case OracleModule.OCI_D_LOB:
        if (_lob instanceof Blob) {
          Blob blob = (Blob) _lob;
          blob.truncate(length);
        } else if (_lob instanceof Clob) {
          Clob clob = (Clob) _lob;
          clob.truncate(length);
        }
        break;
View Full Code Here
410
411
412
413
414
415
416
417
418
419
420
   
    try {
      this.rs = this.stmt.executeQuery("SELECT field1 FROM testBug34677");
      this.rs.next();
      Blob blob = this.rs.getBlob(1);
      blob.truncate(0L);
      assertEquals(0, blob.length());
      assertEquals(-1, blob.getBinaryStream().read());
    } finally {
      closeMemberJDBCResources();
    }
View Full Code Here
111
112
113
114
115
116
117
118
119
120
121
                throw new IOException("Failed select blob for message: " + sequence + " in container.");
            }

            // Update the blob
            Blob blob = rs.getBlob(1);
            blob.truncate(0);
            blob.setBytes(1, data);
            rs.updateBlob(1, blob);
            rs.updateRow();             // Update the row with the updated blob
        } finally {
            close(rs);
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.