stu nicholls dot com | menu - Professional dropdown #3

click here

Introduction to JDBC

Java Provides the ability to build platform-independent client/server database applications.
In Java 1.1 and onwards this has been realized with Java Data Base Connectivity (JDBC) API.Using Java, JDBC, and SQL, any possible client/server architectures may be realized. Using jdbc it is easy to send sql statements to virtually any relational database say Sybase, Ingress, Paradox, Oracle, Informix.

What Does the JDBC do?

JDBC helps to do three things
1)Establish a connection with database
2)Send SQL statements
3) Process the results
JDBC is a low level Interface, which means that it is used to invoke SQL commands directly

Why do we need JDBC when we have ODBC?

1) ODBC is not appropriate for direct use from Java because it uses C Interfaces. So the calls from Java to native C code leads to lot of drawbacks in security, implementation, robustness etc. ODBC API is a C interface (Procedural). JDBC is intended for direct use from Java (Object Oriented)
2) ODBC makes use of pointers and it is hard to learn. But Java does not have pointers.
3) ODBC is hard to learn and has complex options even for simple queries. Whereas JDBC is simple and allows most advanced capabilities
4) When ODBC is used ODBC driver manager and drivers must be manually installed on every client machine. JDBC code is automatically installable, portable, secure on all Java platforms

Our aim is to provide information to the knowledge

comments powered by Disqus
click here
click here