On Mon, Mar 15, 2010 at 11:51 AM, Skellington <[email protected]> wrote:
> Hello, > So I would like to add a secondary datasource to my application, for > failover purposes. Are there any good suggestions or examples on > setting up a secondary/failover datasource if the primary can not be > reached? > Jordan beat me too it while I was typing this ;-), but I don't believe you can configure a secondary data*source* for failover without handling that at the application level, but depending on the JDBC driver you can configure the database connection itself to have a secondary server as failover. As Jordan pointed out you can use the MySQL driver to handle this, and the Microsoft SQL 2005 driver also supports failover at the JDBC level. I don't believe jTDS supports a failover configuration. More info on SQL Server here: http://msdn.microsoft.com/en-us/library/ms378988%28SQL.90%29.aspx Specifically the "failoverPartner" property will support this as long as you have mirroring configured on the SQL Server side. -- Matthew Woodward [email protected] http://blog.mattwoodward.com identi.ca/Twitter: @mpwoodward Please do not send me proprietary file formats such as Word, PowerPoint, etc. as attachments. http://www.gnu.org/philosophy/no-word-attachments.html -- Open BlueDragon Public Mailing List http://www.openbluedragon.org/ http://twitter.com/OpenBlueDragon mailing list - http://groups.google.com/group/openbd?hl=en !! save a network - please trim replies before posting !!
