1/15
These flashcards cover key concepts, components, and terminology related to Java Database Connectivity (JDBC), providing essential vocabulary for understanding JDBC architecture, transactions, and SQL operations.
JDBC
Java Database Connectivity, the standard Java API that allows Java programs to interact with relational databases.
JDBC API
The layer providing standard interfaces and classes for Java applications to interact with databases.
JDBC Driver Manager
Central class responsible for managing JDBC drivers and establishing connections to databases.
JDBC Driver
Vendor-specific software that bridges Java application's JDBC calls and the database's native protocol.
Transaction
A logical unit of database operations that must be executed completely to ensure data integrity.
CRUD Operations
Create, Read, Update, and Delete; the four basic functions of persistent storage in databases.
PreparedStatement
A precompiled SQL statement used for executing parameterized queries to enhance security and performance.
CallableStatement
Used to execute stored procedures in the database allowing complex operations and output parameters.
ACID Properties
Atomicity, Consistency, Isolation, Durability; the key properties that guarantee reliable transactions.
SQL Injection
A code injection technique where an attacker can execute arbitrary SQL code on a database.
ResultSet
An iterator that holds data retrieved from a database query, allowing Java applications to process results.
Type 1 JDBC Driver
JDBC-ODBC Bridge Driver, which is now deprecated and uses ODBC to connect with databases.
Type 2 JDBC Driver
Native-API Driver that requires native libraries and is platform-dependent.
Type 3 JDBC Driver
Network Protocol Driver that uses middleware to convert JDBC calls into database-specific calls.
Type 4 JDBC Driver
Thin Driver, fully written in Java that communicates directly with the database's native protocol.
Exception Handling
Managing errors that occur during database operations to ensure smooth application performance.