What is the difference between ODBC and JDBC?

ODBC is an SQL-based Application Programming Interface (API) created by Microsoft that is used by Windows software applications to access databases via SQL. JDBC is an SQL-based API created by Sun Microsystems to enable Java applications to use SQL for database access.

What advantages JDBC have over ODBC driver?

JDBC proponents cite these advantages of JDBC over ODBC: JDBC applications enjoy the platform-independence of Java, which lends itself to Internet applications. JDBC does not require software on each client system, which lends itself well for Internet applications. JDBC is simpler and easier to learn than ODBC.

Should I use ODBC or JDBC?

Both JDBC and ODBC are used from an application on the client side to access different types of database on the server side. If you want to platform and language independent then use ODBC else if you are working on Java platform then use JDBC.

Should I use JDBC or ODBC?

For Java applications it is not recommended to use ODBC because performance will be down due to internal conversion and applications will become platform Dependent. For Java application it is highly recommended to use JDBC because there we no performance & platform dependent problem. ODBC is procedural.

How do I use ODBC?

Add an ODBC data source

1. Click Start, and then click Control Panel.
2. In the Control Panel, double-click Administrative Tools.
3. In the Administrative Tools dialog box, double-click Data Sources (ODBC).
4. Click User DSN, System DSN, or File DSN, depending on the type of data source you want to add.
5. Click Add.

Does JDBC use ODBC?

JDBC was released as a part of Java development Kit (JDK) 1.1. in the year 1996 by SUN Microsoft. It is built the basis of ODBC and hence, some basics of ODBC retain in JDBC. It is a standard interface between any Java application and different databases.

What is the difference between JNDI and JDBC?

JDBC is Java Database Connectivity API, while JNDI is Java Naming and Directory Interface API. The main thing here is that in a JNDI directory you’re actually storing a JDBC DataSource, so, you’re simply using JDBC to obtain a Connection via JNDI lookup.

What are the advantages of JDBC?

which lends itself to Internet applications.

What is the difference between JDBC and SQLJ?

While JDBC provides a complete dynamic SQL interface from Java to relational databases, SQLJ fills a complementary role for static SQL. Although you can use static SQL statements in your JDBC programs, they can be represented more conveniently in SQLJ. Some advantages you gain in using SQLJ over JDBC for static SQL statements are:

What are the types of JDBC statements available?

Statement