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 Major Dilemna 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 "Major Dilemna" Watch "Major Dilemna" New topic

Major Dilemna

Suzana Shah

Joined: Jan 07, 2002
Posts: 12
Now I wanted to create a web page using JSP connected to MS access Database, what do i have to do?
my system spec is as follows:
platform : Win98
Tomcat version 3.3
MS access 2000
JDK 1.3
Do i need to install a driver? if so how and where, and what do i do?
I havent used this JDBC DBC before so have no clue, can anyone help
Adam Hardy
Ranch Hand

Joined: Oct 09, 2001
Posts: 567
You should probably do the Sun JDBC trail. Yes you will also need to load the driver. To make a connection to any database in JDBC, you need to do something like this:

where driverClassJDBC is the name of your JDBC DBC bridge driver (don't use it myself) and myDBurl is the URL to your database.

I have seen things you people would not believe, attack ships on fire off the shoulder of Orion, c-beams sparkling in the dark near the Tennhauser Gate. All these moments will be lost in time, like tears in the rain.
Adam Hardy
Ranch Hand

Joined: Oct 09, 2001
Posts: 567
whoops there's another smiley.
look at the other thread here if you haven't already, they're talking about the same thing.
JDBC :roll: DBC!
I agree. Here's the link:
subject: Major Dilemna
It's not a secret anymore!