When using an Amazon Web Services RDS instance from a Java application, what is the best JDBC connection string?
It should tolerate the instance falling over to the standby. AWS handles flipping the CNAME to point from the primary to standby under the hood.
The best JDBC connection URI for AWS RDS instances
amazon-rdsamazon-web-servicesjdbcrds
Best Answer
From http://aws.amazon.com/rds/faqs/#36
As long as you have your RDS instance in multi-AZ, you are good with the jdbc url of the RDS instance FQDN.