Re: MySQL equivalent for oracle.jdbc.pool.OracleConnectionCacheImpl

[Anand Pandey]

Hi Senthil,
If you look at JDBC 2.0 documents, you will find that it does not mandate a Connection Cache to be implemented by the JDBC 2.0 vendor. Although Oracle has implemented a connection cache by providing a class called Oracle.jdbc.pool.OracleConnectionCacheImpl. Although most of the Oracle application requests a connection through the getConnection() method of the connection cache instance but it is not mandatory.

As Mark mentioned above, MySQL does not come with connection pooling implementation because there are really many available among open source communities. When you are doing Connection Pooling and Connection Caching, make sure that you have included classes12.zip and jndi.zip in the classpath.

I think you might as well be aware that Oracle has released new version of JDBC drivers for Oracle Database 10g and there as well you need to use the new Implicit connection caching mechanism instead of deprecated OracleConnectionCacheImpl. Thanks,
-Anand

Anand Pandey
Professional Services