It would nice to also leverage the optional pooling that a JDBC driver can give you under 1.4 ... if its possible.
that is a subject for the sandbox version.
Peter is right. Being able to use either DBCP or JDK 1.4 pooling, and have that come by default through Avalon DataSource would be a major usefulness. Pooling is vital.
Right now, we have three implementations:
JdbcDataSource -- which implements the pooling directly.
InformixDataSource -- which uses Informix's database pooling mechanisms.
It *could* be altered to be more generic and work
with other DataSources
J2EEDataSource -- which delegates to a JNDI context to find the
DataSource object and pull the Connections from there.My thoughts on SandBox will be to directly enable JDBC 3.0 pooling using the javax.sql.DataSource interface as the component interface.
It is designed from the ground up for what you want--the initial scratchings are there, though not well tested.
I was also planning on putting together a default implementation of the pooling datasource for databases that don't support it directly.
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
