Assignment: Java Database Connectivity (JDBC) versus Open Database Connectivity (ODBC)
Prior to beginning work on this discussion, read as well as the JDBC Tutorial and JDBC Introduction online resources, and review any relevant information in this week's lecture.
When developing an application, several different database management system (DBMS) access solutions are available including JDBC and ODBC. JDBC stands for Java database connectivity created by the Oracle Corporation. This technology is an Application Programming Interface (API) for the Java programming language that defines how a client may access a database. It provides methods for interacting with the database including issuing queries and updates in a database. On the other hand, ODBC stands for Open Database Connectivity and is a standard programming language middleware API for accessing DBMSs.
In your initial post, compare and contrast the differences between ODBC and JDBC technologies including their individual strengths and weaknesses. Describe the reasons a developer might select one technology versus the other.
JDBC//ODBC are used for connecting to back-end DBMS. Identify and explain other technologies that would allow user applications to communicate with the back-end database. Describe the advantages and disadvantages of these additional technologies, and describe how they compare with JDBC and ODBC.
Format your assignment according to the following formatting requirements:
1. The answer should be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides.
2. The response also includes a cover page containing the title of the assignment, the student's name, the course title, and the date. The cover page is not included in the required page length.
3. Also include a reference page. The Citations and references should follow APA format. The reference page is not included in the required page length.