Specifying driver name when combining Replication driver and DBCP

Hi,
I've not seen this clearly documented, so I'd like to get it clarified.  We're using master/slave configuration, and we want our connection pool to connect both to master and slave in the fashion of the ReplicationDriver.

We're running against mysql 5.1.x, and using jdbc driver jar 5.1.12, latest released at the moment.

Should we be specifying com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource for the driver name, when we also want the benefits of the Replication driver?  Will we get the full benefit of the ReplicationDriver ?  

This is in an environment without a container, btw.  We're using the url to look up the driver to use.  We use Class.forName to load whatever drivername we want.  And we use dbcp-1.2.2, but sometime soon we hope to upgrade to the new dbcp.

It appears to work fine then we specify the MysqlConnectionPoolDataSource, and the replication url I thought I should should get a better opinion.

Thanks very much,
Kevin Fries


      

-- 
MySQL Java Mailing List
For list archives: http://lists.mysql.com/java
To unsubscribe:    http://lists.mysql.com/[email protected]