SIVHD
Katalon Apprentice
11/08/2018

[Q][Keywords] How i can execute T-SQL query ? In MSSQL connection

Hello community, 
I have a problem with using 'advanted' queries. 

I have working keywords with connect to mssql and mysql databases :D
I can do method who execute 'basic' queries like 
select * from table1 

update bla bla 

select 
with inner 
gropu by having order etc. 

but i have problems with query who have transact sql (t-sql)

My eg. query like : 

@declare variable 1
@declare var2 

sel;ect * from where a = @var2 ;
etc... 

i think its driver problem. 

this its not work with heidi sql default profile, heidi cant execute tsql. 

So what i need to do ?? 

From katalon dosc example : 

package com.database
 
import java.sql.DriverManager
 
import java.sql.ResultSet
 
import java.sql.Statement
 
import com.kms.katalon.core.annotation.Keyword
 
import com.mysql.jdbc.Connection

what i need to import and using 
I need to create new conn executing methots and close connection. 

Any ideas ? 
Upvote
Quote
Sign In or Register to comment.