Package javax.sql.rowset.serial

Examples of javax.sql.rowset.serial.SerialBlob

108
109
110
111
112
113
114
115
116
117
118
  public long save(SequencerReference sequencerReference) throws IOException {
    MapSqlParameterSource params = new MapSqlParameterSource();

    Blob ipBlob = null;
    try {
       ipBlob = new SerialBlob(sequencerReference.getIpAddress().getAddress());
    }
    catch (SQLException e) {
      e.printStackTrace();
    }
View Full Code Here
110
111
112
113
114
115
116
117
118
119
120
    Blob xmlblob = null;
    try {
      if (status.getXml() != null) {
        byte[] rbytes = status.getXml().getBytes();
        xmlblob = new SerialBlob(rbytes);
        params.addValue("xml", xmlblob);
      }
      else {
        params.addValue("xml", null);
      }
View Full Code Here
197
198
199
200
201
202
203
204
205
206
207
      user.setRoles(roles.toArray(new String[user.getRoles().length]));

      try {
        if (user.getRoles().length > 0) {
          byte[] rbytes = LimsUtils.join(user.getRoles(), ",").getBytes();
          roleBlob = new SerialBlob(rbytes);
        }
      }
      catch (SerialException e) {
        e.printStackTrace();
      }
View Full Code Here
77
78
79
80
81
82
83
84
85
86
87
    }

    public Image addImage(User owner, byte[] image) {
        try {
            Image im = new Image();
            im.setImage(new SerialBlob(image));
            im.setUser(owner);
            im.setTimestamp(new Date());
            em.persist(im);
            addLinked(owner, im);
            return im;
View Full Code Here
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
        PreparedStatement pstmt = con.prepareStatement("INSERT INTO testblob(id, lo) VALUES(?,?)");

        byte [] initialData = randomData();
       
        pstmt.setString(1,"testConcurrentReplace");
        pstmt.setObject(2, new SerialBlob(initialData), Types.BLOB);
        assertEquals(1, pstmt.executeUpdate());

        con.commit();
       
        con2.rollback();
       
        // con2 access the blob
        PreparedStatement pstmt2 = con2.prepareStatement("SELECT lo FROM testblob WHERE id=?");
        pstmt2.setString(1, "testConcurrentReplace");
        ResultSet rs2 = pstmt2.executeQuery();
        assertTrue(rs2.next());
       
       
        // con replace the blob
        byte [] newData = randomData();
        pstmt = con.prepareStatement("UPDATE testblob SET lo=? where id=?");
        pstmt.setObject(1, new SerialBlob(newData), Types.BLOB);
        pstmt.setString(2,"testConcurrentReplace");
        assertEquals(1, pstmt.executeUpdate());
       
        // con2 read the blob content
        Blob initContentBlob = rs2.getBlob(1);
View Full Code Here
31
32
33
34
35
36
37
38
39
40
41
public class BlobConverter implements TypeConverter<Blob> {

  @Override
  public Blob fromBytes(byte[] t) {
    try {
      return new SerialBlob(t);
    } catch (SerialException e) {
      throw new RuntimeException(e);
    } catch (SQLException e) {
      throw new RuntimeException(e);
    }
View Full Code Here
2787
2788
2789
2790
2791
2792
2793
2794
2795
2796
2797
            if (type.equals(Array.class) && !(value instanceof SerialArray)) {
                return new SerialArray((Array) value);
            }

            if (type.equals(Blob.class) && !(value instanceof SerialBlob)) {
                return new SerialBlob((Blob) value);
            }

            if (type.equals(Clob.class) && !(value instanceof SerialClob)) {
                return new SerialClob((Clob) value);
            }
View Full Code Here
638
639
640
641
642
643
644
            throw new SQLException();
        }
        if (params == null) {
            throw new SQLException();
        }
        params.put(Integer.valueOf(parameterIndex - 1), new SerialBlob(x));
    }
View Full Code Here
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
public class SerialBlobTest extends TestCase {

    public void testConstructorLBlob() throws Exception {
        boolean isAbnormal = false;
        MockSerialBlob mockBlob = new MockSerialBlob(isAbnormal);
        SerialBlob serialBlob = new SerialBlob(mockBlob);
        // SerialBlob constructor initiliases with the data of given blob,
        // therefore, blob.getBytes is invoked.
        assertTrue(mockBlob.isGetBytesInvoked);
        assertEquals(1, serialBlob.length());

        isAbnormal = true;
        mockBlob = new MockSerialBlob(isAbnormal);
        try {
            new SerialBlob(mockBlob);
            fail("should throw SQLException");
        } catch (SQLException e) {
            // expected
        }

        try {
            new SerialBlob((Blob) null);
            fail("should throw SQLException");
        } catch (SQLException e) {
            // expected
        }
    }
View Full Code Here
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
        }
    }

    public void testConstructor$B() throws Exception {
        byte[] buf = new byte[8];
        SerialBlob serialBlob = new SerialBlob(buf);
        assertEquals(8, serialBlob.length());

        try {
            new SerialBlob((byte[]) null);
            fail("should throw NullPointerException");
        } catch (NullPointerException e) {
            // expected
        }
    }
View Full Code Here
TOP

Related Classes of javax.sql.rowset.serial.SerialBlob

  • com.adaptrex.core.ext.ExtTypeFormatter
  • com.denimgroup.threadfix.service.DocumentServiceImpl
  • com.forgeessentials.playerlogger.types.BlockChangeType
  • com.j256.ormlite.db.DerbyEmbeddedDatabaseType$ObjectFieldConverter
  • com.j256.ormlite.db.DerbyEmbeddedDatabaseType$SerializableFieldConverter
  • com.mycila.testing.plugin.db.SqlResultsTest
  • com.nearinfinity.hbase.dsl.types.BlobConverter
  • com.sun.rowset.internal.CachedRowSetWriter
  • evolaris.platform.smssvc.web.action.SmsServiceExecutionAction
  • net.sf.hajdbc.sql.serial.SerialBlobFactory
    • Copyright © 2018 www.massapicom. 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.