Win a copy of Svelte and Sapper in Action this week in the JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Paul Clapham
  • Bear Bibeault
  • Junilu Lacar
Sheriffs:
  • Jeanne Boyarsky
  • Tim Cooke
  • Henry Wong
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • salvin francis
  • Frits Walraven
Bartenders:
  • Scott Selikoff
  • Piet Souris
  • Carey Brown

jdbc terms?

 
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?
 
Marshal
Posts: 70301
282
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Go through the Java™ Tutorials and you will find a section about JDBC.
 
Ranch Hand
Posts: 624
9
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 http://tutorials.jenkov.com/jdbc/driver-types.html";" target="_new" rel="nofollow">here.
 
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
 
Saloon Keeper
Posts: 22501
151
Android Eclipse IDE Tomcat Server Redhat Java 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
 
Consider Paul's rocket mass heater.
    Bookmark Topic Watch Topic
  • New Topic