Selenium MySQL Database connectivity

Here is the code for the connection to a mysql Database using Microsoft SQL Server JDBC driver. public void DBtest() throws Exception { // Load Microsoft SQL Server JDBC driver. Class.forName(“com.mysql.jdbc.Driver”); // Prepare connection url. String url = “jdbc:mysql://localhost/TEST_DB”; // Get connection to DB. Connection con = DriverManager.getConnection(url, “root”, “admin”); // Create statement object which […]

Accessing SQL Database in Selenium C# Script

Here is an example that shows you how you can connect to the database and how to execute the SQL queries in the selenium C# scripts. In this example I am connecting the SQL server by passing the server name, username password and the database name. I then execute the SQL command “select Employee_no from […]

Database Migration Testing

Database Migrating Testing verifies the following 1) Visibility of all business data in respective fields in migrated system 2) History data links to other system 3) Status of various business entities in migrated system. e.g. a. Task which have completed status should be displayed completed in migrated system b. Review history of any documents c. […]