Craig makes a valid point. I should further qualify my answer however and say I was only "seconding" the original reply noting sun.jdbc.odbc.JdbcOdbcDriver may be the only option for MS-Access. (I can't think of any others off the top of my head and had to see what the books were saying on the topic.)
/DB Programming the JDBC and Java/ points some of Craig's notes out in detail, which I should have noted. I just felt the answering question on the choice of a backend data store was a bit off topic for the list. I do agree that MS-Access has very little place in enterprise web applications (let our Micros~1 advocates vehemently protest that statement). Both sun.jdbc.odbc.JdbcOdbcDriver and MS-Access are poor choices in any environment other than a learning/tutorial/academic one. Tim > -----Original Message----- > From: Craig R. McClanahan [mailto:craigmcc@;apache.org] > Sent: Tuesday, November 12, 2002 14:32 > To: Tomcat Users List > Subject: RE: Tomcat -> Access Connection. > > > > > On Tue, 12 Nov 2002, Stone, Timothy wrote: > > > Date: Tue, 12 Nov 2002 13:25:03 -0500 > > From: "Stone, Timothy" <[EMAIL PROTECTED]> > > Reply-To: Tomcat Users List <[EMAIL PROTECTED]> > > To: Tomcat Users List <[EMAIL PROTECTED]> > > Subject: RE: Tomcat -> Access Connection. > > > > Ditto. > > > > I believe JDBC-OBDC bridge (sun.jdbc.odbc.JdbcOdbcDriver) is the > > MS-Access option (I have two O'Reilly books here that > present this class > > as the MS-Access option). > > > > The JDBC-ODBC driver can be used to connect to MS Access > databases, but > it's not a recommended solution for servlet/JSP based > applications -- it > does not deal well with multiple simultaneous requests, which > is pretty > typical in a multiuser web app. You're likely to have no end of wierd > problems due to this. > > For that matter, MS Access isn't really designed for this sort of use > either. > > > Tim > > Craig > > > -- > To unsubscribe, e-mail: <mailto:tomcat-user-unsubscribe@;jakarta.apache.org> For additional commands, e-mail: <mailto:tomcat-user-help@;jakarta.apache.org> -- To unsubscribe, e-mail: <mailto:tomcat-user-unsubscribe@;jakarta.apache.org> For additional commands, e-mail: <mailto:tomcat-user-help@;jakarta.apache.org>
