File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes how to connect database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "how to connect database " Watch "how to connect database " New topic

how to connect database

neeraj jadhav

Joined: Apr 06, 2009
Posts: 2
i have created database using MS ACCESS 2007. i need to know how can i connect that database to my java program, so that i can fetch required data from the database and display it.

please give me step by step details of the process as i know absolutely nothing about database connectivity in java.

Vijitha Kumara

Joined: Mar 24, 2008
Posts: 3902

You can get a good overview from Jdbc Tutorial to get started. It's that only the driver you should get to match your vendor. And we have a separate forum dedicated to JDBC related posts.

[How to ask questions] [Twitter]
Campbell Ritchie

Joined: Oct 13, 2005
Posts: 46368
Moving to our databases forum.
Scott Selikoff
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3753

For Access, you need to use a JDBC-ODBC bridge. There's a number of examples on the web of this.

Can I recommend using real database software? I know its not relevant but many programmers find Access unusable as a real database system (flame bait I know).

[OCA 8 Book] [Blog]
I agree. Here's the link:
subject: how to connect database
It's not a secret anymore!