I believe this is the answer to your question: http://stackoverflow.com/questions/4832056/java-jdbc-how-to-connect-to-oracle-using-service-name-instead-of-sid
On Tue, May 24, 2016 at 3:34 PM, Ioannis Vlachos <[email protected]> wrote: > Hi. > In my organization we use Oracle, but we can only connect through Service > Name and not SID. > Is there any way to specify Service Name instead of SID in the connection > configuration? > All the efforts I have made result in an ora-12505 error: tns listener does > not currently know of sid given in connect descriptor. > > Thanks > > Ioannis Vlachos > -- WBR Maxim aka solomax
