I know there has been some discussion already on this (in particular, this unresolved post: http://www.jboss.org/index.html?module=bb&op=viewtopic&t=59662), but I was wondering if anyone out there has had luck getting FCF and/or db load balancing working within JBoss.

Basically, the behavior I want is that if one of the database instances in my RAC cluster goes down, I want the next time I get a db connection in JBoss to transparently get a connection to a different db instance in my RAC cluster.

Thanks in advance for any experiences you can share.