CODEWITHSUNDEEP
oracle-databasejdbcoracle-sqldeveloper
SK7
SK7

Reputation: 641

Connect to an Oracle DB with sqldeveloper

My backend system is connecting to a remote Oracle DB via datasource : 

dataSource_esb {

    dialect = org.hibernate.dialect.Oracle10gDialect
    driverClassName = 'oracle.jdbc.driver.OracleDriver'
    url : jdbc:oracle:thin:@x.x.x.x:1521/test
    username : username
    password : password

}

Now I am trying to connect to this DB via sqldeveloper, but I am not able to connect. Below is sqldeveloper configuration :

Upvotes: 1

Views: 1486

Answers (2)

Basanta Nahak
Basanta Nahak

Reputation: 1

As per your data base URL jdbc:oracle:thin:@x.x.x.x:1521/test jdbc:oracle:thin is your driver type @x.x.x.x:1521 is port Number Then instead of /test there should be :test if test is your data base SID in configuration. Hope you understood

Thanks Basanta

Upvotes: 0

cjungel
cjungel

Reputation: 3791

Database test should be in SID instead of service name.

Upvotes: 1

Related Questions