I missed your note on MySQL Cluster.
No, there isn't a way to do this with connection pool.
We are proposing "clustered pool" for v3.
Probably, your application can have a layer to handle database connections (from multiple pools and can switch (failover) appropriately),
You may not get in-flight transaction failover, but will be a connection-request time failover
[Message sent by forum member 'jr158900' (jr158900)]
http://forums.java.net/jive/thread.jspa?messageID=278795