Comparing the Three Approaches
What is ODBC? How is it related to SQL/CLI?
What is JDBC? Is it an example of embedded SQL or of using function calls?List the three main approaches to database programming. What are the advantages and disadvantages of each approach?
What is the impedance mismatch problem? Which of the three programming approaches minimizes this problem?
Describe the concept of a cursor and how it is used in embedded SQL.
10.6. What is SQLJ used for? Describe the two types of iterators available in SQLJ.
Exercises
Consider the database shown in Figure 1.2, whose schema is shown in Figure 2.1. Write a program segment to read a student’s name and print his or her grade point average, assuming that A = 4, B = 3, C = 2, and D = 1 points.
Use embedded SQL with C as the host language.
Repeat Exercise 10.7, but use SQLJ with Java as the host language.
Consider the library relational database schema in Figure 6.6. Write a program segment that retrieves the list of books that became overdue yesterday
and that prints the book title and borrower name for each. Use embedded
SQL with C as the host language.
Repeat Exercise 10.9, but use SQLJ with Java as the host language
