In our application we use hibernate as ORM and c3p0 for creating the connections to Oracle RAC 11g rel 2. As we use jdbc thin driver, we plan to use the FCF feature of Oracle RAC so as to reconnect the already created connection to a valid node in case of node failure. The oracle document says that we would need to create an PoolDataSource with the required configuration and then create connections from it. However we are not sure on how to configure the same in c3p0 as it creates the pool and connections. Please let us know if there is any provision to integrate the custom pooldatasource to c3p0 or if there are alternatives for achieving our requirement.
Thanks in advance,