call-greeting

Saturday, July 23, 2011

JDBC

 Q>what is not JDBC?
=>JDBC is not a programming language like java.
=>JDBC is not a software to install into our computer syatem inorder to use it.
=>JDBC is not a shortcut for the expression Java Data Base Technology.
Q>what is JDBC?
=>JDBC is a data acess technolgy from sun micros system that enable any kind of a java program
    to communicate with any kind of  database in a standard manner.
=>JDBC is a J2SE technology.
=>JDBC is a specification.
=>JDBC is an API.
Q>explain the architecture of JDBC?
=>Java power is making method calls.
=>Java method calls are not understandable to database.They understand only SQL,
=>Java compiler doesnot accept SQL syntax directly.
=>Java and database are heterogeneous to each other.Still they have to communicate each other.
=>Knowing about the elements involved in java-database communication is nothing  but understanding the    
     architecture of JDBC.
=>JDBC  architecture has 5 elements.
                1.JDBC client
                2.JDBC API
                3.Driver manager
                4. JDBC driver
                5.database server
JDBC Architecture:-
          


           
Q>what is JDBC client?what are the responsibilities of JDBC?
=>A client is a software or a program/application that requests the server for resources sake.
=>which java program communicating with database for CRUD operations using JDBC technology that java
    program is known as a JDBC client or JDBC application.
=>ODBC(open data base connectivity )technology is used to connect other than java program to    
    communicate with database.
  Responsibilities of JDBC client:-
=>establishing the connection.
=>submitting appropriate SQL statements.
=>processing and presenting the result.
=>handling the exceptions.
=>dealing with transactions whenever necessary.
=>closing the connection.