cancel
Showing results for 
Search instead for 
Did you mean: 

DB Connection Issues

Highlighted
Visitor

DB Connection Issues

I'm facing issues in connecting to Oracle DB through Soap UI- Ready Api. It used to work for me earlier, somehow when I changed my machine, my scripts started failing .I tried connecting to DB using below two methods and with each of them I'm facing a different error:

Method 1- Mentioned the right connection String using this format - jdbcSmiley Surprisedracle:thin:<USER>/<PASSWORD>@<HOST:127.0.0.1>:<PORT>/<ServiceName>

Error- Can't get the Connection for specified properties; java.sql.SQLException: ORA-28040: No matching authentication protocol.

I have tried all combinations of ojdbc drivers to resolve this. But nothing helped. Curretnly I have placed ojdbc6 

 

Method 2- Using Groovy script:

[‎23-‎07-‎2019 23:12]  Chatterjee, Sujoy (GE Healthcare): 

import groovy.sql.Sql

 

def dbUrl      = "jdbcSmiley Tongueostgresql://localhost/test-db"

def dbUser     = "test"

def dbPassword = "test"

def dbDriver   = "org.postgresql.Driver"

 

def sql = Sql.newInstance(dbUrl, dbUser, dbPassword, dbDriver)

 

Using this throws an error - java.sql.SQLException:No Suitable driver found for HOST error at line 12

 

 

Please help! It has been 3 weeks that I have been struggling with these issues

 

New Here?
Join us and watch the welcome video:
Watch the New Interview
APITestingMistake#2