Best Java code snippets using java.sql.ResultSet.getBytes (Showing top 20 results out of 4,662)

private byte[] fetch() {
  try {
    prep.setInt(2, seq++);
    ResultSet rs = prep.executeQuery();
    if (rs.next()) {
      return rs.getBytes(1);
    }
    return null;
  } catch (SQLException e) {
    throw DbException.convert(e);
  }
}

 @Override
 public List<byte[]> handle(final ResultSet rs) throws SQLException {
  if (!rs.next()) {
   return Collections.emptyList();
  }
  final ArrayList<byte[]> data = new ArrayList<>();
  do {
   final byte[] bytes = rs.getBytes(5);
   data.add(bytes);
  } while (rs.next());
  return data;
 }
}

  public OAuth2AccessToken mapRow(ResultSet rs, int rowNum) throws SQLException {
    try {
      return deserializeAccessToken(rs.getBytes(2));
    }
    catch (IllegalArgumentException e) {
      String token = rs.getString(1);
      jdbcTemplate.update(deleteAccessTokenSql, token);
      return null;
    }
  }
}

String imageName = request.getPathInfo().substring(1); // Returns "foo.png".
try (Connection connection = dataSource.getConnection(); PreparedStatement statement = connection.prepareStatement(SQL_FIND)) {
  statement.setString(1, imageName);
  try (ResultSet resultSet = statement.executeQuery()) {
    if (resultSet.next()) {
      byte[] content = resultSet.getBytes("content");
      response.setContentType(getServletContext().getMimeType(imageName));
      response.setContentLength(content.length);

 @Override
 public List<ProjectFileHandler> handle(final ResultSet rs) throws SQLException {
  if (!rs.next()) {
   return null;
  }
  final List<ProjectFileHandler> handlers = new ArrayList<>();
  do {
   final int projectId = rs.getInt(1);
   final int version = rs.getInt(2);
   final long uploadTime = rs.getLong(3);
   final String uploader = rs.getString(4);
   final String fileType = rs.getString(5);
   final String fileName = rs.getString(6);
   final byte[] md5 = rs.getBytes(7);
   final int numChunks = rs.getInt(8);
   final String resourceId = rs.getString(9);
   final ProjectFileHandler handler =
     new ProjectFileHandler(projectId, version, uploadTime, uploader, fileType, fileName,
       numChunks, md5,
       resourceId);
   handlers.add(handler);
  } while (rs.next());
  return handlers;
 }
}

@Test
public void test() throws Exception {
  Connection conn = DriverManager.getConnection(getUrl());
  PreparedStatement stmt = conn.prepareStatement(
    "UPSERT INTO " + TABLE_NAME + " VALUES (?, ?, ?)");
  stmt.setString(1, KEY);
        "SELECT SET_BYTE(vb, 1, 1), SET_BYTE(b, 1, 1) FROM " + TABLE_NAME);
  assertTrue(rs.next());
  assertArrayEquals(new byte[] { 1, 1, 3, 4 }, rs.getBytes(1));
  assertArrayEquals(new byte[] { 1, 1, 3, 4 }, rs.getBytes(2));
  assertTrue(!rs.next());
  rs =
        "SELECT SET_BIT(vb, 8, 1), SET_BIT(b, 8, 1) FROM " + TABLE_NAME);
  assertTrue(rs.next());
  assertArrayEquals(new byte[] { 1, 3, 3, 4 }, rs.getBytes(1));
  assertArrayEquals(new byte[] { 1, 3, 3, 4 }, rs.getBytes(2));
  assertTrue(!rs.next());

    + "' AND outputtype = 'AUDIO' AND locale = '" + locale + "' AND voice = '" + voice + "' AND outputparams = '"
    + outputparams + "' AND style = '" + style + "' AND effects = '" + effects + "' AND inputtext = ?";
PreparedStatement st = connection.prepareStatement(query);
st.setString(1, inputtext);
ResultSet results = st.executeQuery();
if (results.next()) {
  audio = results.getBytes(1);

public Set<ChangeTable> listOfChangeTables() throws SQLException {
  final String query = GET_LIST_OF_CDC_ENABLED_TABLES;
  return queryAndMap(query, rs -> {
    final Set<ChangeTable> changeTables = new HashSet<>();
    while (rs.next()) {
      changeTables.add(
          new ChangeTable(
              new TableId(realDatabaseName, rs.getString(1), rs.getString(2)),
              rs.getString(3),
              rs.getInt(4),
              Lsn.valueOf(rs.getBytes(6)),
              Lsn.valueOf(rs.getBytes(7))
          )
      );
    }
    return changeTables;
  });
}

@Override
public SerializedObject<byte[]> readSerializedSaga(ResultSet resultSet) throws SQLException {
  return new SimpleSerializedObject<>(resultSet.getBytes(1), byte[].class,
                    resultSet.getString(2),
                    resultSet.getString(3));
}

 @Override
 public List<byte[]> handle(final ResultSet rs) throws SQLException {
  if (!rs.next()) {
   return Collections.emptyList();
  }
  final List<byte[]> data = new ArrayList<>();
  do {
   final byte[] bytes = rs.getBytes(1);
   data.add(bytes);
  } while (rs.next());
  return data;
 }
}

PreparedStatement ps=prepareStatement(c, select, ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_UPDATABLE)) {
ps.setString(1, cluster);
try(ResultSet resultSet=ps.executeQuery()) {
  int index=1;
  while(resultSet.next()) {
    byte[] bytes=resultSet.getBytes(1);
    try {
      PingData data=deserialize(bytes);

    + "' AND outputtype = 'AUDIO' AND locale = '" + locale + "' AND voice = '" + voice + "' AND outputparams = '"
    + outputparams + "' AND style = '" + style + "' AND effects = '" + effects + "' AND inputtext = ?";
PreparedStatement st = connection.prepareStatement(query);
st.setString(1, inputtext);
ResultSet results = st.executeQuery();
if (results.next()) {
  audio = results.getBytes(1);

public Set<ChangeTable> listOfNewChangeTables(Lsn fromLsn, Lsn toLsn) throws SQLException {
  final String query = GET_LIST_OF_NEW_CDC_ENABLED_TABLES;
  return prepareQueryAndMap(query,
      ps -> {
        ps.setBytes(1, fromLsn.getBinary());
        ps.setBytes(2, toLsn.getBinary());
      },
      rs -> {
        final Set<ChangeTable> changeTables = new HashSet<>();
        while (rs.next()) {
          changeTables.add(new ChangeTable(
                    rs.getString(4),
                    rs.getInt(1),
                    Lsn.valueOf(rs.getBytes(5)),
                    Lsn.valueOf(rs.getBytes(6))
                  ));
        }
        return changeTables;
      }
  );
}

  @Override
  public TokenCode mapRow(ResultSet rs, int rowNum) throws SQLException {
    int pos = 1;
    String code = rs.getString(pos++);
    String userid = rs.getString(pos++);
    String client_id = rs.getString(pos++);
    long expiresat = rs.getLong(pos++);
    Timestamp created = rs.getTimestamp(pos++);
    byte[] authentication = rs.getBytes(pos++);
    return createTokenCode(code, userid, client_id, expiresat, created, authentication);
  }
}

 @Override
 public String handle(final ResultSet rs) throws SQLException {
  String attachmentsJson = null;
  if (rs.next()) {
   try {
    final byte[] attachments = rs.getBytes(1);
    if (attachments != null) {
     attachmentsJson = GZIPUtils.unGzipString(attachments, "UTF-8");
    }
   } catch (final IOException e) {
    throw new SQLException("Error decoding job attachments", e);
   }
  }
  return attachmentsJson;
 }
}

PreparedStatement prep = prepare(sql);
prep.setLong(1, block);
ResultSet rs = prep.executeQuery();
if (rs.next()) {
  boolean compressed = rs.getInt(1) != 0;
  byte[] compare = rs.getBytes(2);
  if (compressed == (compressAlgorithm != null) && Arrays.equals(b, compare)) {
    blockExists = true;

try {
  connection = connectionProvider.getConnection();
  try (PreparedStatement preparedStatement = connection.prepareStatement(sqlQuery)) {
    if (queryTimeoutSecs > 0) {
      preparedStatement.setQueryTimeout(queryTimeoutSecs);
    try (ResultSet resultSet = preparedStatement.executeQuery()) {
      List<List<Column>> rows = Lists.newArrayList();
      while (resultSet.next()) {
        ResultSetMetaData metaData = resultSet.getMetaData();
        int columnCount = metaData.getColumnCount();
          Class columnJavaType = Util.getJavaType(columnType);
          if (columnJavaType.equals(String.class)) {
            row.add(new Column<String>(columnLabel, resultSet.getString(columnLabel), columnType));
          } else if (columnJavaType.equals(Integer.class)) {
            row.add(new Column<Integer>(columnLabel, resultSet.getInt(columnLabel), columnType));
            row.add(new Column<Boolean>(columnLabel, resultSet.getBoolean(columnLabel), columnType));
          } else if (columnJavaType.equals(byte[].class)) {
            row.add(new Column<byte[]>(columnLabel, resultSet.getBytes(columnLabel), columnType));
          } else if (columnJavaType.equals(Long.class)) {
            row.add(new Column<Long>(columnLabel, resultSet.getLong(columnLabel), columnType));

 @Override
 public List<Pair<String, Props>> handle(final ResultSet rs) throws SQLException {
  if (!rs.next()) {
   return Collections.emptyList();
  }
  final List<Pair<String, Props>> properties = new ArrayList<>();
  do {
   final String name = rs.getString(3);
   final int eventType = rs.getInt(5);
   final byte[] dataBytes = rs.getBytes(6);
   final EncodingType encType = EncodingType.fromInteger(eventType);
   String propertyString = null;
   try {
    if (encType == EncodingType.GZIP) {
     // Decompress the sucker.
     propertyString = GZIPUtils.unGzipString(dataBytes, "UTF-8");
    } else {
     propertyString = new String(dataBytes, "UTF-8");
    }
    final Props props = PropsUtils.fromJSONString(propertyString);
    props.setSource(name);
    properties.add(new Pair<>(name, props));
   } catch (final IOException e) {
    throw new SQLException(e);
   }
  } while (rs.next());
  return properties;
 }
}

private static String getStringColumn(ResultSetMetaData metaData, ResultSet resultSet, int column) throws SQLException {
  if (column == -1) return null;
  final int columnType = metaData.getColumnType(column);
  switch (columnType) {
    case Types.BINARY:
    case Types.VARBINARY:
    case Types.LONGVARBINARY: {
      return new String(resultSet.getBytes(column), StandardCharsets.UTF_8);
    }
    case Types.CHAR:
    case Types.LONGVARCHAR:
    case Types.LONGNVARCHAR:
    case Types.VARCHAR:
    case Types.NVARCHAR: {
      return resultSet.getString(column);
    }
    default: {
      final Object object = resultSet.getObject(column);
      if (object instanceof byte[]) {
        return new String((byte[]) object, StandardCharsets.UTF_8);
      } else if (object instanceof String) {
        return (String) object;
      } else {
        return null;
      }
    }
  }
}

public boolean next() throws SQLException {
  completed = !resultSet.next();
  currentChangePosition = completed ? TxLogPosition.NULL : TxLogPosition.valueOf(Lsn.valueOf(resultSet.getBytes(COL_COMMIT_LSN)), Lsn.valueOf(resultSet.getBytes(COL_ROW_LSN)));
  if (completed) {
    LOGGER.trace("Closing result set of change tables for table {}", changeTable);
    resultSet.close();
  }
  return !completed;
}