CODEWITHSUNDEEP
oracle-databasemule-studiotns
mule-user
mule-user

Reputation: 223

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

Upvotes: 0

Views: 825

Answers (2)

mule-user
mule-user

Reputation: 223

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

Upvotes: 0

Rob Mascaro
Rob Mascaro

Reputation: 851

If you have SQLDeveloper installed, I'm going to assume you have the thin client installed at least and that you can connect within SQLDeveloper.

The JDBC URL syntax is:

jdbc:oracle:thin:username/password@HOSTNAME:1251:SID

"SID" can be either the database SID or the Service Name as specified in the listener.ora file

Upvotes: 1

Related Questions