You don't have any choice with Access, AFAIK. Access is fine for
development, but you'll need a pure JDBC driver and a "real" database like
MS SQLServer, Oracle, or even mySQL for multiple concurrent users. The
problem is, no one's ever written a pure JDBC driver for Access. Another,
less scalable, solution is to make sure your code accessing Access is
single-threaded.
Scott
-----Original Message-----
From: A mailing list about Java Server Pages specification and reference
[mailto:[EMAIL PROTECTED]]On Behalf Of Deniz Ers�z
Sent: Tuesday, April 25, 2000 10:52 AM
To: [EMAIL PROTECTED]
Subject: Re: A question
So, what should i use instead of JDBC-ODBC?
----- Original Message -----
From: "Scott Stirling" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, April 25, 2000 5:05 PM
Subject: Re: A question
> The Sun JDBC-ODBC bridge driver, which I'll bet dollars to donuts you're
using
> to connect to Access, is buggy. It's always just a matter of time or
number of
> concurrent users until you hit a snag in it that will kill javaw.exe on
Windows.
>
> Scott Stirling
>
> ----- Original Message -----
> From: Deniz Ers�z <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, April 25, 2000 9:49 AM
> Subject: Re: A question
>
>
> > Yes, my database connection part is approved in a normal application,
but
> > when I execute several queries JSWDK server crashes...
> >
> > ----- Original Message -----
> > From: "Rebecca Coleman" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Tuesday, April 25, 2000 4:28 PM
> > Subject: Re: A question
> >
> >
> > > are you closing your connection to the db when you're finished?
> > >
> > > -----Original Message-----
> > > From: Deniz Ersoz [mailto:[EMAIL PROTECTED]]
> > > Sent: Tuesday, April 25, 2000 8:51 AM
> > > To: [EMAIL PROTECTED]
> > > Subject: A question
> > >
> > >
> > > When I'm accessing an Access Database JSWDK 1.01 server crashes after
> > > several queries... What vcan be the problem?
> > >
> > > Thanx for your attention.
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
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
