SE452: JDBC [2/12]

The Java Database access APIs - (Not actually an acronym for Java DataBase Connectivity)

• A low level API used for accessing data in databases or tabular data
• Defines a basic low level SQL api
• Based on the X/Open SQL CLI (Call Level Interface)
  • The same basis for Microsoft's ODBC
  • ODBC is a C interface, not appropriate for Java

JDBC Goals

• Provide a Call Level API to allow Java to execute "raw" SQL queries
• Be SQL-92 (SQL-2) compliant
• Integrate with the rest of the Java language
• Keep things simple