Can anyone help me out to tell if we can do connection pooling thro' JDBC-ODBC Bridge for Ms Access
which interfaces are to be used
Thanx
rohit
-
Connection Pooling (2 messages)
- Posted by: Rohit Vadera
- Posted on: August 14 2003 05:24 EDT
Threaded Messages (2)
- Connection Pooling by David Rabinowitz on August 14 2003 07:13 EDT
- Connection Pooling by Paul Strack on August 14 2003 09:57 EDT
-
Connection Pooling[ Go to top ]
- Posted by: David Rabinowitz
- Posted on: August 14 2003 07:13 EDT
- in response to Rohit Vadera
You can always use Apache Jakarta's DBCP, can be found in http://jakarta.apache.org/commons/dbcp
I had very good experience with it.
Davi -
Connection Pooling[ Go to top ]
- Posted by: Paul Strack
- Posted on: August 14 2003 09:57 EDT
- in response to David Rabinowitz
Do bear in mind that MS Access itself only supports a small handful of connections (two, I think), so make your connection pool small.
In general MS Access should not be used for any application that needs to scale above a dozen or so users.