Hi Nitin,
Connection pooling (using connections from a pool) is not supported by
MS-Access. Please browse the following sites :
http://support.microsoft.com/support/kb/articles/q169/4/70.asp
http://support.microsoft.com/support/kb/articles/q166/0/83.asp
This is what Microsoft says on connection pooling with regard to
MS-Access :
You cannot enable connection pooling with the Microsoft Access driver.
The
Microsoft Access driver internally uses Jet, which supports the
apartment
threaded model. In other words, Jet requires the connect/disconnect
procedure
to be handled by the same thread. For connection pooling to work, the
connect/disconnect procedure needs to be handled by different threads.
This
applies to all the Microsoft Desktop drivers that use Jet.
This is the story for ODBC driver manager ver3.0 or later.
I do not know the details for JDBC and as such since it seems to depend
on
the database engine rather than the connection methodology i really
doubt if
we can use connection pooling to connect to MS-Access even with JDBC.
Let me know the sites or links to any articles that have used
connnection
pooling with MS-Access and JDBC.
Thanks,
ramana
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
