Java Database Connectivity Competency (Intermediate Level)

Topics covered

• apply a Predicate instance to a FilteredRowSet to get it to include only data that fulfils the condition defined in the Predicate
• combine the optimizations of batch executions and batch updates
• describe how the auto-commit feature may prevent queries from running as a transaction
• download image files from a SQL table into your file system
• execute stored procedures that return values and retrieve the outputs generated
• identify potential issues when trying to modify a read-only ResultSet
• load large image files into a SQL table using JDBC
• manipulate the contents of a CachedRowSet and push the updates to the underlying database table
• perform a partial rollback by implementing Savepoints in a Java app
• perform scrolling and navigation over the contents of a JdbcRowSet
• recall how a WebRowSet records modifications to its contents
• recognize the limitations of a TYPE_FORWARD_ONLY ResultSet
• recognize the limitations of working with a disconnected RowSet such as a CachedRowSet
• recognize the types of updates that can be performed on a FilteredRowSet
• refresh the contents of a ResultSet while iterating over its contents
• remove data from a SQL table by performing deletes from a ResultSet
• scroll through a ResultSet to access data in various locations
• update the contents of a SQL table through a JoinRowSet
• use JDBC to run stored procedures that use the same parameter to process inputs and outputs
• use JDBC to upload and download text data to and from a database