JDBC: Working with ResultSets & Query Batches


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level


Overview/Description

ResultSets allow SELECT query results to be processed systematically in a Java app while executing INSERT and UPDATE queries can be handled efficiently with query batches. This is very much a hands-on course and gets into the nitty-gritty of processing large volumes of data using JDBC. You will cover a lot of features of the ResultSet object - from its navigability to its ability to update data. You will also optimize updates by running them in a batch, and cover the implementations of atomic transactions when using JDBC.



Expected Duration (hours)
1.8

Lesson Objectives

JDBC: Working with ResultSets & Query Batches

  • discover the key concepts covered in this course
  • identify the types of ResultSets available in JDBC
  • scroll through a ResultSet to access data in various locations
  • recognize the limitations of a TYPE_FORWARD_ONLY ResultSet
  • refresh the contents of a ResultSet while iterating over its contents
  • recognize the types of modifications that a ResultSet may not pick up
  • modify the contents of a SQL table by updating a ResultSet
  • remove data from a SQL table by performing deletes from a ResultSet
  • identify potential issues when trying to modify a read-only ResultSet
  • group similar INSERT queries together into a bath to optimize their executions
  • combine the optimizations of batch executions and batch updates
  • describe how the auto-commit feature may prevent queries from running as a transaction
  • use the rollback feature of JDBC to undo modifications after an Exception is thrown
  • perform a partial rollback by implementing Savepoints in a Java app
  • summarize the key concepts covered in this course

    • Course Number:
    it_jmjdbcdj_03_enus

    Expertise Level
    Beginner