- 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.
Problem:
- 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.
Thanks