Unable to get data from SQl Server please share me some code for reference

[ssuneel]

QAF Version

Note: only the latest version is supported

Steps To Reproduce

@QAFDataProvider(sqlQuery="Select top 1 SALESID,COMPID from SaleTable where SalesStatus = '4' and SALESID like 'Sale'") @QAFTestStep(description="I search order {0}") public void iSearchOrder(Map <String, String> data) throws ClassNotFoundException {

	String getOrdernUmber=data.get("**SALESID**");
	System.out.println(getOrdernUmber + "*****************");
	String getcompanyId =data.get("**COMPID**");
	
}	

And also used application properties

db.driver.class=com.microsoft.sqlserver.jdbc.SQLServerDriver db.connection.url=jdbc:sqlserver://TSTData-DB.*: db.user=***** db.pwd=*****

Expected behavior

Please let me is it rgt way to use or not

Actual behavior

Is the issue reproducible on runner?

• [x] QAS
• [ ] Maven
• [ ] Gradle
• [x] Ant
• [ ] Eclipse

Test case sample

Please, share the test case (as small as possible) which shows the issue

[cjayswal]

Data provider is used with test case not with test step. @QAFDataProvider annotation is used to define data provider for test written in java. Refer documentation for example.

It is recommended to post questions with details (your current configuration, relevant code, execution logs, etc) in users group or in stack-overflow with qaf tag.