Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

jdbc terms?

 
bairava surya
Ranch Hand
Posts: 134
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi every one
i just started to learn the jdbc please help me with terminologies
what is jdbc driver and what is jdbc jar file?
with my knoledge driver means a software to connect to database.
provide me some usefull stuff to understand?
 
Campbell Ritchie
Sheriff
Posts: 51415
87
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Go through the Java™ Tutorials and you will find a section about JDBC.
 
Tapas Chand
Ranch Hand
Posts: 583
8
BSD Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
bairava surya wrote:with my knoledge driver means a software to connect to database.

Your understanding is correct. JDBC driver is a collection of Java classes packaged in a JAR.
I hope this answers your 1st question too.
For example, if you want to connect to Oracle 11g database from your Java application, you will need ojdbc6_g.jar to be downloaded from Oracle website

There are different drivers also for a specific database.
You can explore more here.
 
manisha Mulchandani
Greenhorn
Posts: 20
Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
JDBC stands for Java Database Connectivity is an Application Programming Interface(API) which contains many classes and interfaces to allow java program to connect with the databases like MS Access,MYSQL,oracle etc.

Yes,Driver is a software which allows the hardware to communicate with Operating system.it is bridge/interface between hardware and OS.

There are 4 types of JDBC Drivers:
1) JDBC-ODBC Driver
2) Native API driver
3) Pure Java Driver
4) Network Driver

For more Details Refer following link:
Types of Driver

For program to connect java program with MS Access:

program with MS Access
 
Tim Holloway
Saloon Keeper
Posts: 18365
56
Android Eclipse IDE Linux
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
JDBC is also an API that provides these services in a standard vendor-defined way. The java.sql and javax.sql packages define the objects and methods that allow writing vendor-independent database client code. That's very important because you don't have to learn a different API for every brand of dataabase you work with, and you can often code for multiple brands of databases using common code.
 
bairava surya
Ranch Hand
Posts: 134
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi friends
after my effort on searching i got enough knowledge
initially we load the driver class in class path the driver manager self registers this driver class and wen we call the getconnection() the driver manager calls connect() on the registered driver.
is this correct ?and provide me some more info if any wrong
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic