Hi, I am asking this question to clear my basic concept about connectinity to oracle database via java program. In order to conect to database I was told to use IP address instead of URL, SID instead of schema and make sure oracle database is running in MTS mode. My question is: (1)what is MTS mode, SID and what is the advantage of using IP address instead of using URL? and (2)What is the relationship between them? I know this question might be too basic for a lot of people to answer but if some one can I will really appreciate. Thanks Anurag
SID and what is the advantage of using IP address instead of using URL? --> actually, I would suggest the opposite. If your IP address of the server that your database resides on changes, then you have to change the Connection code. If you use the DNS url then if the server moves, the code doesn't have to, as long as the server name stays the same. not sure about MTS mode??? Jamie
posted 13 years ago
MTS stands for Multi Threaded Server
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads