In Apache:
If you need full object/relational mapping OJB or Torque are good options. If most of your data is tabular and you want to work with it that way, Jakarta commons-dbutils works pretty well.
http://db.apache.org/ojb/ http://db.apache.org/torque/ http://jakarta.apache.org/commons/dbutils/
Both OJB and Torque use connection pooling -- I think commons-dbutils requires that you manage your own connections, I think.
Outside of Apache:
Hibernate, iBatis, TJDO, Cayenne, and Spring DAO all work pretty well. iBatis is particularly nice if you want O/R mapping and still want to be able to specify your own SQL.
-Brian
On Apr 20, 2004, at 5:45 PM, Philip, Anil [ITS] wrote:
Hi,
I am looking for an easy to use but efficient library class(es) to connect to the database - especially with connection pooling. Can anyone direct me to examples, downloads, documentation etc?
thanks, Anil Philip EWS, Sprint (PCS) Overland Park, KS