aspose file tools
The moose likes JDBC and the fly likes how to connect database Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "how to connect database " Watch "how to connect database " New topic
Author

how to connect database

neeraj jadhav
Greenhorn

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.


NJ
Vijitha Kumara
Bartender

Joined: Mar 24, 2008
Posts: 3670

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.


SCJP 5 | SCWCD 5
[How to ask questions] [Twitter]
Campbell Ritchie
Sheriff

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

Joined: Oct 23, 2005
Posts: 3652

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).


My Blog: Down Home Country Coding with Scott Selikoff
 
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: how to connect database
 
Similar Threads
H2 database - how can I know if the database exsists or not
Database connectivity problem
Help Connecting SQL Server 7 to Jboss 3
database connection
Connection to MySQL