Hello I have a problem that in my application there are two data bases Oracle and SQL Server and i want to dynamically check that which data base is available and then connect to available data base. best regards
How do you mean, check to see if they're available? Do these databases get turned off occassionally? You could attempt to connect to one, and if that connection fails, attempt to connect to the other. More likely, however, is that you want to store the connection information in some .properties file and have the user select which connection they want to use, yes?
Piscis Babelis est parvus, flavus, et hiridicus, et est probabiliter insolitissima raritas in toto mundo.
Joined: Feb 21, 2003
I am little confused with your answer , actually our client use two DBMS (Oracle and SQL Server) due to their differenc interfaces, thats why whole data can be stored on both servers. In this case if one DBMS does down then, then the customer must connect to anpther dbms dynamically. Is this possible in minimum efforts or it requires more to do? best regards Faisal Ishaque