The JDBC-OBDC bridge is quite limited. For one, it does not support JDBC
v.2.0.
Also, there are some problems with Access itself, especiallyh in date and
floating point handling (for example, Acess 2K for some reason refuses to
store floating point numbers, it strips the decimal point and stores them as
integers instead).

> -----Original Message-----
> From: kim [mailto:lekim@b...]
> Sent: Saturday, September 09, 2000 16:42
> To: Pro_JavaServer_Pages
> Subject: [pro_jsp] JDBC and MS Access97?
>
>
> It seems to me that there are some differences when I tried to run JDBC
> with Access (as opposed to DB2 or Oracle, PostgreSQL ...):
>
> 1. The type date/time does not work well. I had to convert it to a string
> type.
>
> 2. It is also said that multithread won't work with Access. Although case
> study in chapter 19 used Connection pool manager with Access. So I am not
> sure that which way is the correct statement?
>
> Probably there are more differences than the above mentioned, because I
> could not run some code examples with Access, but those codes worked well
> with other databases.
>
> I hope somebody with more experience with Acces will give me some more
> explainations.
>
> TIA
>
> ---
> Do you know what you want from this list? How would you provide
> programmers with the solutions they need? If you have the
> answers, and are willing to work in Birmingham (UK), then you
> could be a List Manager. Please send CVs and a covering letter to
> listsupport@p... for further information.