This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
Please advice what is the role of XE from the following line of code.
I found the following entry in tnsnames.ora file
I am able to execute the program. My question is, Are these related ?
Also, I changed the above 2 entries as given below
I am getting following error
java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
The Connection descriptor used by the client was:
Hmm, the first example uses "XE" in 3 places. The second one uses "XE19" in two places, "XE24" in one place, and then causes an error message. It seems kind of obvious what should be tried to fix the error, no?
Joined: Aug 02, 2012
Even if I mess up with tnsnames.ora file and use this snipped in my code, It works fine
I want to know the relationship between my program and tnsnames.ora file.