- We have SQL Server DataBase Running. - That Server has 2 Lines. One is from Bharati & Other is from VSNL(means two different Vendors). - At a time only one Line is Working. both line has it'sown static IP Address. - Two lines are their for emergency. means if one line goes down then other will start. - so that my website that is used by airlines will not stop.
- Database connectivity is done through JAVA using SQL Driver. - Connection URL Required IPAddress:port number, - For SQL Server , we have Fixed Port Number. but IPAddress for that Server will change based on the Lines. which line is
running is Current IP. - Is it any way to find out the current IP assign to this Server through JAVA or SQL.
- Our Website is in JSP & Servlets. - Need some solution from SQL side means , is there any SQL Query that will return the IPAddress of that machine. Or is there any other way .We tried writing code But it is very slow.