Re: Which one is better ODBC / JDBC ?
Posted by: douglas wilson
Date: August 20, 2014 12:59AM

I think JDBC better because of the main reason it is portable and secure.

ODBC is a standard Microsoft Windows® interface that enables communication between database management systems and applications typically written in C or C++.

JDBC is a standard interface that enables communication between applications based on Oracle Java and database management systems.

-->ODBC can’t be directly used with Java because it uses a C interface andODBC makes use of pointers which have been removed totally from Java.

-->ODBC mixes simple and advanced features together and has complex options for simple queries. But JDBC is designed to keep things simple while allowing advanced capabilities when required.

-->ODBC requires manual installation of the ODBC driver manager and driver on all client machines. JDBC drivers are written in Java and JDBC code is automatically installable, secure, and portable on all platforms.

-->JDBC API is a natural Java interface and is built on ODBC. JDBC retains some of the basic features of ODBC.

Options: ReplyQuote

Written By
Re: Which one is better ODBC / JDBC ?
August 20, 2014 12:59AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.