<p>Hello,</p><p> </p><p>Could anyone please help me to understand how to connect Oracle datasource?</p><p>I have done the following</p><p> </p><p> </p><ul class='bbcol decimal'><li>Added JAR file ojdbc6 </li><li>Given URL template as jdbc:oracle:thin:
@<HOST>:<PORT>:<DATABASE> </li><li>And in the driver class, I have the string as oracle.jdbc.OracleDriver ( v12.1) </li><li>Database URL as jdbc:oracle:thin:
@localhost:1521:<span class='bbc_underline'><strong>pdborcl</strong></span> </li><li>given user and password as hr/hr</li></ul><p>But I am getting the error as ora - 12505 TNS Listner error</p><p>later I have changed <strong>driver class</strong> to my root database as dbc:oracle:thin:
@localhost:1521:<span class='bbc_underline'><strong>orcl</strong></span></p><p>But unable to login.</p><p> </p><p>I guess the problem is connecting the oracle plugable database.</p><p>Please assist.</p><p> </p><p>Thanks in advance,</p><p>Sathya</p>