Search code examples
oraclemule-studiotns

Connecting to oracle-tns from mulestudio

I want to connect to oracle database with connection type "TNS" from Anypointstudio. But I am not sure what is the Database URL that can be used for this purpose. Below are the details

Database version: sqldeveloper-4.1.3.20.78

Username: muleuser ,
Password: muleuser , HOST:XX , PORT: 1521 , SERVICE_NAME = XX Connection Type: TNS

Please provide me the equivalent jdbc url and jdbc driver name which can be used to connect to db from Anypointstudio: Version: 5.4.1

Solution

  • I have resolved the issue. The problem was I was using older version of the jar Now I use latest 0jdbc.14 and I am able to connect.

    Thanks everyone for the quick response and help. Keep it up