Hi Team,
My tests are failing when i add new throw skip exception to my script. I am getting Java null pointer exception.My script is able to read the data from excel but its not skipping when the Runmode is N. This is my code . Pls help me where should i change.
import java.util.Hashtable;
import org.openqa.selenium.WebDriver;
import org.testng.SkipException;
import org.testng.annotations.DataProvider;
import org.testng.annotations.Test;
public class Dataexecution {
public WebDriver driver;
@Test(dataProvider="getdata")
public void DataTest(Hashtable<String,String>data){
if[color=#FF0000:9ot7j86k](data.get("Runmode").equals("N"))[/color:9ot7j86k]{
throw new SkipException("Skipping the testrun since runmode is N");
}
}
@DataProvider
public Object[][]getdata(){
Xls_Reader xls= new Xls_Reader("C:\\Users\\sairam\\Desktop\\login.xlsx");
String Sheetname="Data";
String testcaseName="TestA";
int teststartrow=1;
while(!xls.getCellData(Sheetname, 0, teststartrow).equals(testcaseName)){
teststartrow++;
}
System.out.println("Test Data start from " +teststartrow);
int colStartRownum=teststartrow+1;
int dataStartRownum=teststartrow+2;
int rows=0;
while(!xls.getCellData(Sheetname, 0, dataStartRownum+rows).equals("")){
rows++;
}
System.out.println("Total rows are:-" +rows);
int clos=0;
while(!xls.getCellData(Sheetname, clos, colStartRownum).equals("")){
clos++;
}
System.out.println("Total colums are :-"+clos);
Object[][]data= new Object[rows][1];
int datarow=0;
Hashtable<String,String>table=null;
for(int rnum=dataStartRownum;rnum<dataStartRownum+rows;rnum++){
table=new Hashtable<String,String>();
for(int col=0;col<clos;col++){
String key=xls.getCellData(Sheetname, col,dataStartRownum);
String value=xls.getCellData(Sheetname, col, rnum);
table.put(key, value);
}
data[datarow][0]=table;
datarow++;
}
return data;
}
}
*******************************This is the output after running the above code****************
[TestNG] Running:
C:\Users\sairam\AppData\Local\Temp\testng-eclipse-1225353220\testng-customsuite.xml
Test Data start from 1
Total rows are:-2
Total colums are :-4
FAILED: DataTest({A2=A2, A1=A1, A88=A88, Y=Y})
java.lang.NullPointerException
at Dataexecution.DataTest(Dataexecution.java:18)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.testng.internal.MethodInvocationHelper.invokeMethod(MethodInvocationHelper.java:86)
at org.testng.internal.Invoker.invokeMethod(Invoker.java:643)
at org.testng.internal.Invoker.invokeTestMethod(Invoker.java:820)
at org.testng.internal.Invoker.invokeTestMethods(Invoker.java:1128)
at org.testng.internal.TestMethodWorker.invokeTestMethods(TestMethodWorker.java:129)
at org.testng.internal.TestMethodWorker.run(TestMethodWorker.java:112)
at org.testng.TestRunner.privateRun(TestRunner.java:782)
at org.testng.TestRunner.run(TestRunner.java:632)
at org.testng.SuiteRunner.runTest(SuiteRunner.java:366)
at org.testng.SuiteRunner.runSequentially(SuiteRunner.java:361)
at org.testng.SuiteRunner.privateRun(SuiteRunner.java:319)
at org.testng.SuiteRunner.run(SuiteRunner.java:268)
at org.testng.SuiteRunnerWorker.runSuite(SuiteRunnerWorker.java:52)
at org.testng.SuiteRunnerWorker.run(SuiteRunnerWorker.java:86)
at org.testng.TestNG.runSuitesSequentially(TestNG.java:1244)
at org.testng.TestNG.runSuitesLocally(TestNG.java:1169)
at org.testng.TestNG.run(TestNG.java:1064)
at org.testng.remote.AbstractRemoteTestNG.run(AbstractRemoteTestNG.java:126)
at org.testng.remote.RemoteTestNG.initAndRun(RemoteTestNG.java:152)
at org.testng.remote.RemoteTestNG.main(RemoteTestNG.java:57)
FAILED: DataTest({A2=F2, A1=A2, A88=Ah, Y=N})
java.lang.NullPointerException
at Dataexecution.DataTest(Dataexecution.java:18)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.testng.internal.MethodInvocationHelper.invokeMethod(MethodInvocationHelper.java:86)
at org.testng.internal.Invoker.invokeMethod(Invoker.java:643)
at org.testng.internal.Invoker.invokeTestMethod(Invoker.java:820)
at org.testng.internal.Invoker.invokeTestMethods(Invoker.java:1128)
at org.testng.internal.TestMethodWorker.invokeTestMethods(TestMethodWorker.java:129)
at org.testng.internal.TestMethodWorker.run(TestMethodWorker.java:112)
at org.testng.TestRunner.privateRun(TestRunner.java:782)
at org.testng.TestRunner.run(TestRunner.java:632)
at org.testng.SuiteRunner.runTest(SuiteRunner.java:366)
at org.testng.SuiteRunner.runSequentially(SuiteRunner.java:361)
at org.testng.SuiteRunner.privateRun(SuiteRunner.java:319)
at org.testng.SuiteRunner.run(SuiteRunner.java:268)
at org.testng.SuiteRunnerWorker.runSuite(SuiteRunnerWorker.java:52)
at org.testng.SuiteRunnerWorker.run(SuiteRunnerWorker.java:86)
at org.testng.TestNG.runSuitesSequentially(TestNG.java:1244)
at org.testng.TestNG.runSuitesLocally(TestNG.java:1169)
at org.testng.TestNG.run(TestNG.java:1064)
at org.testng.remote.AbstractRemoteTestNG.run(AbstractRemoteTestNG.java:126)
at org.testng.remote.RemoteTestNG.initAndRun(RemoteTestNG.java:152)
at org.testng.remote.RemoteTestNG.main(RemoteTestNG.java:57)
===============================================
Default test
Tests run: 2, Failures: 2, Skips: 0
===============================================
===============================================
Default suite
Total tests run: 2, Failures: 2, Skips: 0
===============================================
[TestNG] Time taken by [FailedReporter passed=0 failed=0 skipped=0]: 22 ms
[TestNG] Time taken by org.testng.reporters.jq.Main@27f674d: 79 ms
[TestNG] Time taken by org.testng.reporters.EmailableReporter2@3f3afe78: 13 ms
[TestNG] Time taken by org.testng.reporters.SuiteHTMLReporter@1cd072a9: 71 ms
[TestNG] Time taken by org.testng.reporters.XMLReporter@1e643faf: 43 ms
[TestNG] Time taken by org.testng.reporters.JUnitReportReporter@39ba5a14: 14 ms
