JDBC and ODBC
Not what you're looking for?
The purpose of this 3 page paper is to discuss JDBC with interfacing to
ODBC.
JDBC is a Java API (Application Programming Interface) that documents a
standard framework for dealing with tabular and, generally, relational data
A database is essentially a smart container for tables.
A table is a container comprised of rows.
A row is (conceptually) a container comprised of columns.
A column is a single data item having a name, type, and value.
ODBC (Open Database Connectivity), a C-based interface to SQL-based
database engines, provides a consistent interface for communicating with a
database and for accessing database metadata
Purchase this Solution
Solution Summary
This solution provides a brief description of JDBC, ODBC as well as the interface between them
Solution Preview
Please see the attached file.
Problem:
The purpose of this 3 page paper is to discuss JDBC with interfacing to ODBC.
JDBC is a Java API (Application Programming Interface) that documents a
standard framework for dealing with tabular and, generally, relational data
A database is essentially a smart container for tables.
A table is a container comprised of rows.
A row is (conceptually) a container comprised of columns.
A column is a single data item having a name, type, and value.
ODBC (Open Database Connectivity), a C-based interface to SQL-based
database engines, provides a consistent interface for communicating with a
database and for accessing database metadata
Solution:
"Open Database Connectivity (ODBC) is a widely accepted Application Programming Interface (API) for database access. It's based on the Call-Level Interface (CLI) specifications from X/Open and ISO/IEC for database API's, and uses Structured Query Language (SQL) as its database access language" (Microsoft.com, 2007).
ODBC was created to provide a uniform method of access to heterogeneous, database management systems. The ODBC architecture has four components:
• Application performs processing and calls ODBC functions to submit SQL statements and retrieve results.
• Driver Manager Loads and unloads drivers on behalf of an application. ...
Purchase this Solution
Free BrainMass Quizzes
Excel Introductory Quiz
This quiz tests your knowledge of basics of MS-Excel.
Basic UNIX commands
Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.
Java loops
This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.
Inserting and deleting in a linked list
This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.
Basic Networking Questions
This quiz consists of some basic networking questions.