![]() |
|||
![]() ![]() |
![]() |
![]()
|
![]() |
Application The user application calls ODBC functions to send SQL statements to the database and retrieve results. It performs these tasks:
Driver Manager Driver managers primary purpose is to load specific drivers on behalf of the user application. It may also:
Driver The driver processes ODBC function calls, sends SQL statements to a specific data source, and returns results back to the application. When necessary, the driver translates and/or optimizes requests so that the request conforms to the syntax supported by the specific DBMS. The driver:
There are two types of ODBC drivers:
Data Source The data source consists of the data the user application wants to access and its associated parameters that is, the type of operating system, DBMS, and network layer (if any) used to access the DBMS. SummaryThis chapter discussed fundamental concepts such as relational databases, SQL, and database access programming interfaces. The next chapter discusses the Java Database Connectivity APIs role, components, and possible alternatives to it.
|
![]() |
|