RE: TAF or ONS/FAN/FCF for Wildfly

From: Mike Killough <mwkillough_at_hotmail.com>
Date: Mon, 7 Mar 2016 11:10:02 -0600
Message-ID: <BAY172-W10C272F7BC6E5AE10D14A2C2B10_at_phx.gbl>

I believe TAF is working fine. I am logged on to sqlplus to monitor connections in gv$session and my session fails back and forth with no issue. I can see that Wildfly's pooled connections move to the other instance and the failed_over column in gv$sessions equals yes, but then Wildfly disconnects all those sessions and creates new connections. For FCF, I'm able to configure Wildfly to accept fast-connection-failover-enabled and ONS-configuration but when I stop the clusterware and the database service fails over, there are no pooled connections.

Mike

Subject: Re: TAF or ONS/FAN/FCF for Wildfly To: oracle-l_at_freelists.org
From: gogala.mladen_at_gmail.com
Date: Sun, 6 Mar 2016 15:14:50 -0500

  
    
  
  
    On 03/04/2016 10:10 AM, Mike Killough
      wrote:

    
    
      
      Has anyone gotten either TAF or ONS/FAN/FCF working
        with Oracle and Wildfly for the app servers? The database is
        11.2.0.4 and Wildfly is 8.2.0. I have had no luck and can get
        into detail if someone has experience with this.
        

        
        Thanks,

          

          Mike
      
    
    While having no experience with either wild or domestic flies, I
    have configured TAF for Java applications. Basically, it's all in
    the TNS entry that your application uses to connect. Here is the
    document which explains how to do it:

    

    https://docs.oracle.com/cd/E19509-01/820-3492/boaem/index.html

    

    The applications that I have been helping with were written using
    Hibernate framework which is not so popular any more.

    

    -- 
Mladen Gogala
Oracle DBA
Tel: (347) 321-1217
 		 	   		  

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Mar 07 2016 - 18:10:02 CET