Ruaidhri,
The issue is two-fold. First, as some have pointed out, it is
about the scalability of the database. Does Access have the
power to handle the workload you would be driving toward
it with your interface.
One way to guage this is if you have already been using Access
in a client-server environment, and it has been adequate to the
task, you should be able to have it support the same number of
users concurrently through a web interface.
The second, and more difficult issue, is a proper JDBC Driver.
Sun's entry level JDBC-ODBC Bridge driver ( known as the
Type 1 Driver ) is not thread safe, and therefore is not likely to
suit your purposes. Since the Access Network API is not
published, and reverse engineering such protocols is likely to
violate some licensing agreement with MS, you will not likely
find a true Type 4 ( pure Java ) Driver.
What you are left with are the Type 2 and Type 3 Drivers that
may be available on the open market. Please note that Access
does not have a central database engine, and relies upon the so
called JET ( Joint Engine Technologies ) Driver to coordinate
and control locking and updating of the source database by
multiple users concurrently, either locally or over the network.
This is similar to older ISAM technologies like DBase.
Sun maintains a list of JDBC Driver manufacturers and their
driver releases. You can search for Drivers based upon your
database, platform, driver type, etc. The list will usually have
contact information for the vendor of that driver.
Try this link: http://industry.java.sun.com/products/jdbc/drivers
My search for MS Access showed a dozen or more drivers,
mostly type 2 and type 3, but two manufacturers said they
produce a type 4? Hope this helps.
Art
----- Original Message -----
From: "Ruaidhrí Fernandes" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, May 01, 2001 1:47 PM
Subject: Re: MS Access
> Hi all,
> Im new to JSP. Trying to create an e-commerce web site
> using JSP alone.
> Im usinf MS Acess as my database and im wondering how
> i would go about making a connection to it using JSP.
> If anyone knows or knows some web page explaining how
> to do it that would be great.
> Thanks
> Ruaidhri Fernandes
>
> --- Ashish Shrestha <[EMAIL PROTECTED]> wrote:
> > Celeste Haseltine wrote:
> > > I must admit that I had not heard of the FreeTDS
> > driver. I've already
> > > purchased a Type 4 JDBC driver, but just out of
> > curiousity, is FreeTDS a
> > > type 4 driver, or a type 2? For my production
> > internet application, I
> > > needed a Type 4 driver, and one that included the
> > extended API.
> >
> > It is a Type 4 driver, but I think the
> > implementation is not
> > complete.
> > --
> > a s h i s h @ j d g n p . o r g
> > Get Headlines 0.5.2 for free at
> > http://headlines.sourceforge.net/
> >
> >
>
===========================================================================
> > To unsubscribe: mailto [EMAIL PROTECTED] with
> > body: "signoff JSP-INTEREST".
> > For digest: mailto [EMAIL PROTECTED] with body:
> > "set JSP-INTEREST DIGEST".
> > Some relevant FAQs on JSP/Servlets can be found at:
> >
> > http://java.sun.com/products/jsp/faq.html
> > http://www.esperanto.org.nz/jsp/jspfaq.html
> > http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> >
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
>
>
> =====
> "If a rabbit's foot is so lucky,..... what happened to the rabbit?"
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Auctions - buy the things you want at great prices
> http://auctions.yahoo.com/
>
>
===========================================================================
> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
> For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST
DIGEST".
> Some relevant FAQs on JSP/Servlets can be found at:
>
> http://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.html
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
>
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets