i have implemented Oracle 126.96.36.199 Single Node RAC with 2 node. i have enabled ons on both node. for TAF it's working fine. but when we apply in java .. it is not working.. how can i implement in java...
we had done all the methods using following links..
We have configured like below in application. it connects well. Oracle Configured as Single Node Rac in 188.8.131.52.
when i down the available server, 2nd node getting up, it works in backend whn i use TAF. when apply below method it returns ORA-17410 error .. could u check below code and suggest me to change to work..
java.util.Properties prop = new java.util.Properties();
prop.setProperty("MinLimit", "5"); // the cache size is 5 at least
prop.setProperty("InitialLimit", "1"); // create 3 connections at startup
prop.setProperty("InactiveConnectionTimeout", "20"); // seconds
have a look on the following whitepaper (it includes a Java example on FCF and FAN, and especially what driver to use!)
Universal Connection Pool Documentation:
Check if you are using the correct data source with the correct connection pooling mechanism.
Furthermore: If you use FCF and FAN, then the reconnect/get connection out of the connection pool, is something the application has to do, after it received a client error.
Also: You connection string implies you want to use TAF
(TYPE = SELECT)(METHOD = PRECONNECT)(RETRIES = 180)(DELAY = 5)
but this is not available in JDBC Thin.... Just in JDBC Thick. And TAF + FCF won't work (just TAF with FAN).