Two Laptop Bag
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!