Skip to content
kaumei JDBC kaumei JDBC

✅ JDBC update

  • @JdbcUpdate define a method which will execute SQL updates
    • create prepareStatement
    • fill parameter from the method
    • configure statement
    • execute and process the Statement.executeUpdate
    • process possible generated values and return them
  • ✅ the value of @JdbcSelect must contain a valid SQL select statement with named parameters (:name) as described in param binding
  • ✅ Return types may be void, int, or boolean;
    • ✅ int will return the result of executeUpdate
    • ✅ boolean returns true when at least one row is affected.
  • ✅ Returning generated values requires @JdbcReturnGeneratedValues. The method must return a mandatory, non-collection type that can be mapped via @JdbcToJava.
    • ✅ GENERATED_KEYS: The processor calls getGeneratedKeys() (default)
    • ✅ EXECUTE_QUERY: The processor calls executeQuery()
    • return type must be nonnull or unspecific

✅ JDBC batch update

Section titled “✅ JDBC batch update”
  • @JdbcUpdateBatch define a method which will execute SQL updates in batch ‘mode’
  • For batch operations, declare the return type as an inner interface extending JdbcBatch.
  • the Result must be nonnull or unspecific
  • supported annotations
    • ✅ @JdbcBatchSize on the method or on an parameter for dynamic
  • ✅ Define the @JdbcUpdate method in the interface The processor emits a nested implementation that collects parameters, honours @JdbcBatchSize (constant or parameter), and delegates to PreparedStatement#addBatch().