Considering a DB that is based on ODBC, what is the function of JDBC in this case? [closed]

-1

What is the purpose of JDBC in a bd that is based on ODBC?

    
asked by anonymous 17.07.2017 / 18:59

1 answer

3

ODBC is an interface that does not depend on a specific programming language, database, or operating system. It can be used to write applications that search data from any database, regardless of the environment it is running. The biggest advantage of using ODBC as an interface between an application and a database is that when the database is changed the application does not need to be modified.

JDBC is an API for the Java language that facilitates the client to access a database, providing methods for fetching and updating database data. JDBC is best applied to object-oriented databases.

Deciding Between ODBC and JDBC

Use ODBC to:

  • Better performance for importing and exporting data
  • Importing and exporting lots of memory.

Use JDBC to:

  • Stand-alone platforms, allowing you to work with any operating system (32 and 64 bit).
  • Use functions already implemented in the interface;
  • Working with complex data types such as LONG, BLOB, etc.
17.07.2017 / 19:16