We are providng an application on JBoss to a client. They have asked us to support the following scenarios:
1) App Starts without SQL Server. Then SQL starts. 2) SQL Server Starts, then app starts. (This works) 3) Everything running... Then SQL Server disappears and then later re-appears. When the server re-appears app must recover. 4) App and SQL Server starting at the same time (which is just scenario 1 or scenario 2 depending on which is faster)
The biggest problem we've found so far is with scenario 1). Is this feasible at all?