[Bodington-developers] Commons DBCP

[Matthew B. <mat...@co...>]

I was going to have a look at moving from our custom database connection
pooling to common-dhcp (http://jakarta.apache.org/commons/dbcp/).
Initially this work would be against WebLearn HEAD but I could push it
across to Bodington HEAD.

Currently org.bodington.database.ConnectionPool doesn't cope with a
database restart while Bodington is still running and rather than adding
support for this I though it might make more sense to replace it with a
"standard" open source equivilent.

With the move to commons-dhcp we also get things like custom connection
validation.

One feature I might have to reimplement (or throw away?) is the
restriction of the number of database connections per user which
o.b.d.ConnectionPool currently supports.

Any comments?

-- 
+--Matthew Buckett-----------------------------------------+
| VLE Developer, Learning Technologies Group               |
| Tel: +44 (0) 1865 283660 http://www.oucs.ox.ac.uk/       |
+------------Computing Services, University of Oxford------+