Java Recipes - Part 1

You can store large JSON/String objects in RDBMS with blob. Oracle DB recommends blob for storing JSON objects. In this article, we’ll learn it how to handle it using JPA.

Using iterator index in lambda inside forEach

You can make use of streams as shown below:

// For setting the parameters in prepared statement query
// params is ArrayList contains the parameter values in same order, ? appears in query (implicit index)
IntStream.range(1, params.size() + 1)
          .forEach(idx -> q.setParameter(idx, params.get(idx - 1)));
// OR
AtomicInteger idx = new AtomicInteger();
params.forEach(e -> q.setParameters(idx.incrementAndGet(), e));