Forum Discussion

Ditto's avatar
Ditto
New Contributor
8 years ago

Maven + SoapUI ClassNotFoundException(com.microsoft.sqlserver.jdbc.SQLServerDriver)

Hi Guy's, need a little bit of help with Maven and SoapUI. The long-term plan is to integrate my SoapUI tests with Jenkins, however, i'm unfortunately falling down at the first hurdle, when getting m...
NamrataMane's avatar
NamrataMane
Occasional Contributor
7 years ago

Hello All,

 

I am also facing the issue while executing the ready API script file in VSTS release

 

java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver error

 


import groovy.sql.Sql

def dbURL= "jdbc:sqlserver://servername:1433;databaseName=abcd"
def dbUsername= "ffff"
def dbPassword= "ffff!"
def dbDriver= "com.microsoft.sqlserver.jdbc.SQLServerDriver"
def db = Sql.newInstance(dbURL,dbUsername,dbPassword,dbDriver)

def List1 =[]
def index = 0

/**********************Select query*******************************/

def q1 = "select ITEM_ID, * from ITEM_PROPERTY"
// interact with DB
try{
//log.info(q1)

//db.eachRow(q1){

//if(qa)
//log.info "${it.ITEM_ID}"
log.info("Database connection successful")

//}
}catch(InstantiationException e){
log.info "Some db error"
log.info e.getMessage()
}finally{
// close database connection
db.close()
}

 

The script is working fine in tool. could someone please help....