mysql - part 1

mysql - part 1 - COP 4610L: Applications in the Enterprise...

Info iconThis preview shows pages 1–6. Sign up to view the full content.

View Full Document Right Arrow Icon
COP 4610L: MySQL Part 1 Page 1 Mark Llewellyn © COP 4610L: Applications in the Enterprise Fall 2006 Introduction To MySQL – Part 1 COP 4610L: Applications in the Enterprise Fall 2006 Introduction To MySQL – Part 1 School of Electrical Engineering and Computer Science University of Central Florida Instructor : Mark Llewellyn markl@cs.ucf.edu CSB 242, 823-2790 http://www.cs.ucf.edu/courses/cop4610/fall2006
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
COP 4610L: MySQL Part 1 Page 2 Mark Llewellyn © Database Access via JDBC The Java Database Connectivity (JDBC) interface enables any Java program to send SQL queries to any database, and receive back result tables with the desired data. Similar to the basic idea of Java in writing a program that will run on any hardware platform, JDBC enables the development of programs which function with nearly all commercially available DBMSs. Apart from the general popularity of Java, this is the fundamental reason for the widespread acceptance of JDBC. In order to guarantee the general database access, JDBC defines a certain core functionality supported by all DBMSs, This common denominator can be implemented by JDBC. This implies that different product characteristics and manufacturer- specific optimizations are ignored by the JDBC standard.
Background image of page 2
COP 4610L: MySQL Part 1 Page 3 Mark Llewellyn © Database Access via JDBC (cont.) One prerequisite for the use of JDBC is the availability of a JDBC driver for the database being utilized. The JDBC driver translates the JDBC queries of the Java database client into the respective supplier-specific calls. The simplest version on the Windows platform is the Open Database Connectivity (ODBC) interface. ODBC also enables different databases to function via a uniform interface. JDBC and ODBC are both based on the same idea. Using the JDBC-ODBC bridge, it is possible to access an ODBC data source via JDBC.
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
COP 4610L: MySQL Part 1 Page 4 Mark Llewellyn © Different Methods for Database Access The figure on the next slide summarizes the various options available for accessing a database. The client software typically communicates with the server via a proprietary interface. The drivers translate JDBC or ODBC commands into the respective database specific calls. The user can also access the database using an SQL specific tool. One disadvantage of the ODBC solution is that every computer on which a Java database application is to run, the ODBC connection must be configured. This contradicts the Java principle “write once, run anywhere”. The way around this is through the use of servlets in which the only computer on which the ODBC must be configured is the one on which the servlet engine will run. If a database application is installed on several computers or distributed as an applet, the JDBC-ODBC bridge is not an option as the ODBC connection would have to be configured on every computer.
Background image of page 4
COP 4610L: MySQL Part 1 Page 5 Mark Llewellyn © Summary of Database Access Methods SQL Tool JDBC Database Driver ODBC Database Driver Database DB-specific API Java Database Client JDBC-ODBC Bridge JDBC API ODBC API
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 6
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 44

mysql - part 1 - COP 4610L: Applications in the Enterprise...

This preview shows document pages 1 - 6. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online