What Is J DBC? 11 Database Connectivity, is (Subdomains web hosting)
What Is J DBC? 11 Database Connectivity, is an API developed by Microsoft to allow access to databases. The API and subsequent interface code allow access to a wide range of databases on many platforms using a variety of languages. This all sounds wonderful for a middleware product. Surely we could use ODBC as an interface between Java and MySQL. Why don t we? The answer isn t as simple as not wanting to use a Microsoft product in our development. It is possible to use ODBC from Java using a product called the JDBC-ODBC Bridge, supplied by Sun. This bridge takes Java commands based on the JDBC API and sends them to an installed ODBC driver, which subsequently accesses the database. Any results work through the software in reverse. The bridge was supplied with Java 1.2 and 2.0 as a stopgap for developers who needed quick access to a database from their Java code. At the time, the JDBC specification wasn t mature; there weren t many vendor drivers available that used JDBC, but many were available for ODBC. Now that all major database vendors have pure Java solutions, use of the bridge isn t encouraged. There are drawbacks to using ODBC in the process of accessing a database through Java. The primary drawback is that the code that implements ODBC is based on the C language and uses a large number of generic pointers. A number of problems occur with interfacing Java to C code, not to mention performance issues. It is much better to have a Java solution to database interfacing in order to provide a seamless solution. Modeling Database Applications with JDBC Before we start to look at the specifics of JDBC, let s take a moment and consider how it is used to interface a Java application with MySQL. Figure 2.1 shows a simple two-tier deployment model. Client Java Applet Java Application JDBC Server MySQL Database Figure 2.1 A two-tier deployment model.
Note: If you are looking for high quality webhost to host and run your jsp application check Vision jsp hosting services