Planet Jaspersoft

io.cucumber.testng.UndefinedStepException: The step 'Clicks on Edit Product  Hyperlink' and 1 other step(s) are undefined.
You can implement these steps using the snippet(s) below:

@Then("Clicks on Edit Product Hyperlink")
public void clicks_on_edit_route_overrides_hyperlink() {
    // Write code here that turns the phrase above into concrete actions
    throw new io.cucumber.java.PendingException();
}
@Then("Verifies the navigation to Product Edit Page")
public void verifies_the_navigation_to_trading_partner_route_overrides_page() {
    // Write code here that turns the phrase above into concrete actions
    throw new io.cucumber.java.PendingException();
}

	at io.cucumber.core.runtime.TestCaseResultObserver.assertTestCasePassed(TestCaseResultObserver.java:69)
	at io.cucumber.testng.TestCaseResultObserver.assertTestCasePassed(TestCaseResultObserver.java:23)
	at io.cucumber.testng.TestNGCucumberRunner.lambda$runScenario$1(TestNGCucumberRunner.java:133)
	at io.cucumber.core.runtime.CucumberExecutionContext.lambda$runTestCase$3(CucumberExecutionContext.java:110)
	at io.cucumber.core.runtime.RethrowingThrowableCollector.executeAndThrow(RethrowingThrowableCollector.java:23)
	at io.cucumber.core.runtime.CucumberExecutionContext.runTestCase(CucumberExecutionContext.java:110)
	at io.cucumber.testng.TestNGCucumberRunner.runScenario(TestNGCucumberRunner.java:129)
	at io.cucumber.testng.AbstractTestNGCucumberTests.runScenario(AbstractTestNGCucumberTests.java:35)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:568)
	at org.testng.internal.MethodInvocationHelper.invokeMethod(MethodInvocationHelper.java:134)
	at org.testng.internal.TestInvoker.invokeMethod(TestInvoker.java:597)
	at org.testng.internal.TestInvoker.invokeTestMethod(TestInvoker.java:173)
	at org.testng.internal.MethodRunner.runInSequence(MethodRunner.java:46)
	at org.testng.internal.TestInvoker$MethodInvocationAgent.invoke(TestInvoker.java:816)
	at org.testng.internal.TestInvoker.invokeTestMethods(TestInvoker.java:146)
	at org.testng.internal.TestMethodWorker.invokeTestMethods(TestMethodWorker.java:146)
	at org.testng.internal.TestMethodWorker.run(TestMethodWorker.java:128)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1511)
	at org.testng.TestRunner.privateRun(TestRunner.java:766)
	at org.testng.TestRunner.run(TestRunner.java:587)
	at org.testng.SuiteRunner.runTest(SuiteRunner.java:384)
	at org.testng.SuiteRunner.runSequentially(SuiteRunner.java:378)
	at org.testng.SuiteRunner.privateRun(SuiteRunner.java:337)
	at org.testng.SuiteRunner.run(SuiteRunner.java:286)
	at org.testng.SuiteRunnerWorker.runSuite(SuiteRunnerWorker.java:53)
	at org.testng.SuiteRunnerWorker.run(SuiteRunnerWorker.java:96)
	at org.testng.TestNG.runSuitesSequentially(TestNG.java:1187)
	at org.testng.TestNG.runSuitesLocally(TestNG.java:1109)
	at org.testng.TestNG.runSuites(TestNG.java:1039)
	at org.testng.TestNG.run(TestNG.java:1007)
	at org.testng.remote.AbstractRemoteTestNG.run(AbstractRemoteTestNG.java:115)
	at org.testng.remote.RemoteTestNG.initAndRun(RemoteTestNG.java:251)
	at org.testng.remote.RemoteTestNG.main(RemoteTestNG.java:77)

org.openqa.selenium.NoSuchElementException: no such element: Unable to locate element: {"method":"xpath","selector":"//*[@id="TablePartners"]/tbody/tr/td[4]/a[1]"}
  (Session info: chrome=103.0.5060.134)
For documentation on this error, please visit: https://selenium.dev/exceptions/#no_such_element
Build info: version: '4.3.0', revision: 'a4995e2c09*'
System info: host: 'SADAKARP', ip: '100.200.1.3', os.name: 'Windows 11', os.arch: 'amd64', os.version: '10.0', java.version: '17.0.3'
Driver info: org.openqa.selenium.chrome.ChromeDriver
Command: [108db81f036e7466c1939f054decbfb8, findElement {using=xpath, value=//*[@id="TablePartners"]/tbody/tr/td[4]/a[1]}]
Capabilities {acceptInsecureCerts: true, browserName: chrome, browserVersion: 103.0.5060.134, chrome: {chromedriverVersion: 103.0.5060.53 (a1711811edd7..., userDataDir: C:\Users\sadakarp\AppData\L...}, goog:chromeOptions: {debuggerAddress: localhost:61571}, networkConnectionEnabled: false, pageLoadStrategy: normal, platformName: WINDOWS, proxy: Proxy(), se:cdp: ws://localhost:61571/devtoo..., se:cdpVersion: 103.0.5060.134, setWindowRect: true, strictFileInteractability: false, timeouts: {implicit: 0, pageLoad: 300000, script: 30000}, unhandledPromptBehavior: dismiss and notify, webauthn:extension:credBlob: true, webauthn:extension:largeBlob: true, webauthn:virtualAuthenticators: true}
Session ID: 108db81f036e7466c1939f054decbfb8
	at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:77)
	at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:499)
	at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:480)
	at org.openqa.selenium.remote.codec.w3c.W3CHttpResponseCodec.createException(W3CHttpResponseCodec.java:200)
	at org.openqa.selenium.remote.codec.w3c.W3CHttpResponseCodec.decode(W3CHttpResponseCodec.java:133)
	at org.openqa.selenium.remote.codec.w3c.W3CHttpResponseCodec.decode(W3CHttpResponseCodec.java:53)
	at org.openqa.selenium.remote.HttpCommandExecutor.execute(HttpCommandExecutor.java:184)
	at org.openqa.selenium.remote.service.DriverCommandExecutor.invokeExecute(DriverCommandExecutor.java:167)
	at org.openqa.selenium.remote.service.DriverCommandExecutor.execute(DriverCommandExecutor.java:142)
	at org.openqa.selenium.remote.RemoteWebDriver.execute(RemoteWebDriver.java:569)
	at org.openqa.selenium.remote.ElementLocation$ElementFinder$2.findElement(ElementLocation.java:162)
	at org.openqa.selenium.remote.ElementLocation.findElement(ElementLocation.java:60)
	at org.openqa.selenium.remote.RemoteWebDriver.findElement(RemoteWebDriver.java:387)
	at org.openqa.selenium.remote.RemoteWebDriver.findElement(RemoteWebDriver.java:379)
	at com.inovalon.cucumber.stepdef.tradingpartners.AddTradingPartner.search_for_the_Trading_Partner_created_and_verify_for_its_existance(AddTradingPartner.java:107)
	at ✽.Search for the Trading Partner created and verify for its existance(classpath:features/AddTradingPartner.feature:19)

package com.sadakar.cucumber.common;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;

import org.testng.annotations.AfterSuite;
import org.testng.annotations.BeforeSuite;

public class DatabaseHooks {

	// Connection object
	private static Connection dbConn = null;
	// Statement object
	@SuppressWarnings("unused")
	private static Statement stmt;
	// Constant for Database URL
	public static String DB_URL = "jdbc:sqlserver://14.456.9.20:1433;user=TestUser;password=TestPassWord;database=TestDB";

	@BeforeSuite //TestNG annotation
	public static Connection getDBConnection() {

		try {
			
			if (dbConn == null) {
				Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
				dbConn = DriverManager.getConnection(DB_URL);
				
				System.out.println("Connected to Database - BeforeSuite TestNG");
			}
			else {
				System.out.println("Already Connected to Database - BeforeSuite TestNG");
			}
		} catch (Exception e) {
			e.printStackTrace();
		} 
		return dbConn;
	}
	
	
	@AfterSuite //TestNG
	public static void closeConnection() {
		if (dbConn != null)
			try {
				dbConn.close();
				System.out.println("Database connection closed - AfterSuite TestNG");
			} catch (SQLException e) {
				e.printStackTrace();
			}
	}
}

CreateUser.java

Create a Connection Object in the CreateUser class. 
Create Statement(s) and execute and store the result in res1 variable of ResultSet
Connection for the database is created once in the above Hook and we are using it in 
CreateUser class and similarly, we can make use of the same connection in other classes. 

package com.sadakar.cucumber.stepdefinitions;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.time.Duration;
import java.util.List;
import org.openqa.selenium.By;
import org.testng.Assert;
import com.sadakar.cucumber.common.DatabaseHooks;
import com.sadakar.resource.utilities.Log;
import com.sadakar.webui.common.BasePage;
import io.cucumber.java.en.Then;

public class CreateUser extends BasePage {

Connection con = DatabaseHooks.getDBConnection();

@Then("Fills the user on the User form")
	public void fillTheUserFrom(io.cucumber.datatable.DataTable dataTableAddUser)
			throws InterruptedException, SQLException {

		if (dataTableAddUser == null)
			throw new NullPointerException("cells can not be null");
		List<List<String>> cells = dataTableAddUser.cells();

		Statement sta = con.createStatement();

		String AutomationUser1 = "select * from Users where username='AutomationUser1'";

		ResultSet res1 = sta.executeQuery(AutomationUser1);

		if (res1.next()) {

			System.out.println("ResultSet is not empty, 1 row returned");
			System.out.println("AutomationUser1 test user already exists  so deleting the existing and creating it again");
			
			String deleteUser = "delete from Users where UserName='AutomationUser1'";
			String deleteUserEmail = "delete from UserAdditionalInfo where Email='AutomationUser1@email.com'";

			sta.executeUpdate(deleteUser);
			sta.executeUpdate(deleteUserEmail);

			driver.findElement(By.xpath("//input[@id='UserName']")).clear();
			driver.findElement(By.xpath("//input[@id='UserName']")).sendKeys(cells.get(1).get(1));
			driver.findElement(By.xpath("//input[@id='UserEmail']")).sendKeys(cells.get(2).get(1));

		} else if (!res1.next()) {
			System.out.println("ResultSet is empty, no rows returned");
			System.out.println("Test user does not exist  so creating test user : AutomationUser1");

			driver.findElement(By.xpath("//input[@id='User']")).clear();
			driver.findElement(By.xpath("//input[@id='User']")).sendKeys(cells.get(1).get(1));
			driver.findElement(By.xpath("//input[@id='UserEmail']")).sendKeys(cells.get(2).get(1));
		} else {
			Assert.assertTrue(false);
		}

	}
}

@HRMLogin

Feature: Login to HRM Application
  I want to use this template for HRM Login page

  @LoginValidCredentials
  Scenario: LoginValidCredentials
    Given User login to HRM application with UserName and Password
      | Admin | admin123 |

@Directory
Feature: Dashboard page
  I want to use this template for my Directory Page

  Background: 
    Given User login to HRM application with UserName and Password
      | Admin | admin123 |

  @DirectoryTabIsSearchButtonDisplayed
  Scenario: DirectoryTabIsSearchButtonDisplayed
    Then User is on Directory page
    Then Is Search button displayed

package com.sadakar.common;
import org.openqa.selenium.WebDriver;
public class BasePage {
	
	public static WebDriver driver;

}

package com.sadakar.common;
import org.openqa.selenium.chrome.ChromeDriver;
import io.cucumber.java.After;
import io.cucumber.java.Before;

public class Hooks extends BasePage {

	@Before //Cucumber Before Hook
	public static void setupDriver() throws InterruptedException {

		System.setProperty("webdriver.chrome.driver", "D:\\chromedriver.exe");
		driver = new ChromeDriver();
		driver.manage().window().maximize();
		driver.get("https://opensource-demo.orangehrmlive.com/index.php/auth/login");
	}

	@After // Cucumber After hook
	public static void quitDriver() throws Exception {
		driver.quit();
	}

}

package com.sadakar.pageobjects;

import org.openqa.selenium.By;

public class DirectoryPOM {

	// locators for view Directory Page/Tab, Search button
	public By viewDirectoryLinkLocator = By.xpath("//*[@id=\"menu_directory_viewDirectory\"]");
	public By searchButtonLocator = By.xpath("//*[@id=\"searchBtn\"]");

}

package com.sadakar.stepdefinitions;

import java.time.Duration;

import org.openqa.selenium.WebElement;
import org.testng.Assert;

import com.sadakar.common.BasePage;
import com.sadakar.pageobjects.DirectoryPOM;

import io.cucumber.java.en.Then; 
public class Directory extends BasePage{

	DirectoryPOM dir = new DirectoryPOM();
	
	@Then("User is on Directory page")
	public void directoryPage() {

		// Navigating to Directory Page/tab
		driver.findElement(dir.viewDirectoryLinkLocator).click();
		driver.manage().timeouts().implicitlyWait(Duration.ofSeconds(5));
	}
	
	@Then("Is Search button displayed")
	public void isSearchButtonDisplayed() {
	
		// Verifying Search button is displayed or not
		WebElement searchButtonEle = driver.findElement(dir.searchButtonLocator);
		Assert.assertTrue(searchButtonEle.isDisplayed());
	}
}