|Summary:||Custom interceptor to support automatic failover of mirrored database|
|Product:||Tomcat Modules||Reporter:||Chris Abrams <chris.abrams.mobiqa>|
|Component:||jdbc-pool||Assignee:||Tomcat Developers Mailing List <dev>|
|Attachments:||Adds a new interceptor class|
Description Chris Abrams 2011-10-13 14:20:30 UTC
Created attachment 27771 [details] Adds a new interceptor class Custom Tomcat JDBC Pool interceptor which reconnects a JDBC Connection on failure. This was written to support automatic failover of a SQL Server database configured with database mirroring and using the Microsoft SQL Server JDBC driver, configured to support failover. It is hoped this interceptor may be more generally useful for supporting reconnection on failure but is untested on any database other than SQL Server 2008 R2.
Comment 1 Filip Hanik 2012-03-20 17:02:34 UTC
I like the idea, but it's not fine grained enough. What if I do 1 con = getConnection(); 2 con.close(); 3 con.executeQuery(); on step 3 we reconnect the connection only to fail identically again.