Online Hibernate Training just in Rs. 1000

One week online training in Hibernate ORM framework. Learn Hibernate Framework and enhance your skills. Best Online Hibernate training at 90% discount. Join Now!! Offer is valid Only for limited Period!!! Online Training

First Step towards JDBC!

First Step towards JDBC! First Step towards JDBC Introduction T his article introduce you with JDBC and shows you how to create a database application to access the databases. For the shake of simplicity, in very first example Access database and

Ads

Tutorials   
JDBC Video Tutorial: Create, Read, Update and Delete (CRUD) Operation examples JDBC Video tutorial - How to read Data from MySQL Database? JDBC Video tutorial - How to delete Data in a MySQL Database? Solving java.lang.ClassNotFoundException: com.mysql.jdbc.Driver exception JDBC Video tutorial - How to update Data in a MySQL Database? JDBC Video Tutorial- How to insert data into MySQL database table? JDBC Video Tutorial: How to download JDBC Driver for MySQL? JDBC Tutorial - Writing first JDBC example and running in Eclipse Java Cross Join MySQL Database Connectivity Example In Java Change Column Name in MySQL Java Mysql Connection Example JDBC ODBC Connection In Java ResultSet In Java Prepared Statement Example JdbcRowSet interface Java JdbcRowSet Example First Step towards JDBC! JDBC Training, Learn JDBC yourself Jdbc Get Column Names JDBC Example with MySQL JDBC Prepared Statement Update JDBC Prepared Statement Insert JDBC Prepared Statement Example JDBC Prepared statement Close JDBC Prepared Statement Addbatch JDBC Nested Resultset JDBC-Odbc Connection JDBC-Odbc Connectivity JDBC Insert Preparedstatement JDBC Insert Null JDBC Get Metadata JDBC Insert Record Jdbc Insert Statement JDBC Meta Data Get tables Jdbc Mysql Connection String Jdbc Mysql Connection Url JDBC Next Jdbc Get Connection JDBC Get Int JDBC Exception JDBC Get Row Count JDBC Functions JDBC Fetch JDBC Execute Update Example JDBC Execute Statement JDBC Execute Query JDBC Drive For Mysql JDBC Connectivity Code In Java JDBC connection timeout
Ads

First Step towards JDBC

     

Introduction

This article introduce you with JDBC and shows you how to create a database application to access the databases. For the shake of simplicity, in very first example Access database and Sun's JDBC-ODBC drivers are used. In the later sections we will show you how to use JDBC from your servlets or JSP pages to create dynamic pages or to store the data received from visitors.

What is JDBC?

Java Database Connectivity or JDBC for short is set of Java API's that enables the developers to create platform and database independent applications in java. The biggest advantage of programming in Java is its platform independence. An application written to access the MS Access database on Win 95/Win NT platform can work on Linux against Oracle database, only by changing the name of driver, provided none of the database calls it makes are vendor specific.

What are JDBC Drivers?

JDBC Drivers are set of classes that enables the Java application to communicate with databases. Java.sql that ships with JDK contains various classes for using relational databases. But these classes do not provide any implementation, only the behaviours are defined. The actual implementaions are done in third-party drivers. Third party vendors implements the java.sql.Driver interface in their database driver. 

JDBC Drivers Types

Sun has defined four JDBC driver types. These are:

  1. Type 1: JDBC-ODBC Bridge Driver
    The first type of JDBC dirver is JDBC-ODBC Bridge which provide JDBC access to any ODBC complaint databases through ODBC drivers. Sun's JDBC-ODBC bridge is example of type 1 driver.
  2. Type 2: Native -API Partly - Java Driver
    Type 2 drivers are developed using native code libraries, which were originally designed for accessing the database through C/C++. Here a thin code of Java wrap around the native code and converts JDBC commands to DBMS-specific native calls.
  3. Type 3: JDBC-Net Pure Java Driver
    Type 3 drivers are a three-tier solutions. This type of driver communicates to a middleware component which in turn connects to database and provide database connectivity.
  4. Type 4: Native-Protocol Pure Java Driver
    Type 4 drivers are entirely written in Java that communicate directly with vendor's database through socket connection. Here no translation or middleware layer, are required which improves performance tremendously.

  Links to JDBC Drivers Site   Here is the link of some of the site providing the JDBC drivers:

  1. MERANT DataDirect provides JDBC driver technology through n-tier, server-based data connectivity and high-performance, DBMS-independent JDBC middleware.
     
  2. MM MySQL JDBC DRIVERS - 100% pure java driver for MySQL and is distributed  under the GNU LGPL.
      
  3. The mSQL JDBC Driver-A pure-java JDBC driver for mSQL was created and is being maintained by George Reese from The Center for Imaginary Environments.
     

A list of currently available JDBC drivers can be found at http://java.sun.com/products/jdbc/jdbc.drivers.html

You can easily find the JDBC driver for SQL Server and all other database servers by surfing the following link:
http://industry.java.sun.com/products/jdbc/drivers

Advertisements

Ads
Share on Google+Share on Google+

First Step towards JDBC!

Posted on: January 30, 2005 If you enjoyed this post then why not add us on Google+? Add us to your Circles

Advertisements

 

Discuss: First Step towards JDBC!   View All Comments

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments:8
anita rathi
March 11, 2012
advance java

i want more info.abaut java. Nd these interview q. Help me for my company.
ravisha from surya vamsha
April 2, 2012
about surya vamsha

hi send me related information to my mail id
rahul garg
April 4, 2012
import or export database

hi... sir my name is rahul garg and i want to know how to import or export data in oracle9i,,,,(how can transfer our database to another computer......
Netaji
April 19, 2012
c and java

what is pds?
chandrashekhar sangeet
June 8, 2012
java program

i want quesction and answer
chandrashekhar sangeet
June 8, 2012
java program

plz give me program in to java for teaching it is good for me
OM
June 21, 2012
java problem

Please write a program in java language for ms access connectivity
java
September 9, 2012
What are nstive code libraries

please tel me the answer

Ads

 

Ads