NeoLoad has a built-in variable where you can run SQL requests against different type of databases such as MySQL, SQL server, Oracle, DB2 and PostgreSQL.

This variable will be evaluated at the beginning of the script only. So, if you have to run other SQL queries, you will have to do it from a Javascript using JAVA code.

As an example, Neotys has created JAVA code that will allow you to run such SQL queries from a Javascript.

First, you have to download the nl-sql.jar.pdf (use the "Save link as" feature from your browser) copy the nl-sql.jar.pdf (rename it nl-sql.jar) into your <neoload_project>\lib\jslib folder.

Then, create your Javascript in NeoLoad.

This is an example of connection:

var connection = new Packages.SQLConnection("mysql");
connection.connect("localhost", 3306, "mysql", "root", "admin");

The different types of SQL servers that can be used are : mysql, oracle, db2, postgresql, mssql.
The connection parameters are in this order: name of the server (or IP address), port, database name, username and password.

Then, to select multiple results:
 
var results = connection.getResults("SELECT * FROM user");
// we iterate on each item returned by the SQL statement

for (var i = 0 ; i < results.size() ; i++) {
  var item = results.get(i);
// Each column of the database can be accessed through its name:
  logger.debug("name = " + item.get("name"));
}

To select a single result:
 
var result = connection.getSingleResult("SELECT * FROM user WHERE name = 'user1'");
logger.debug("name = " + result.get("name")); // This will display: user1

At the end of the Javascript we have to close the connection:
 
connection.disconnect();

For more information, see “NeoLoad Javascript API” under “Appendixes” section in NeoLoad documentation.

nl-sql.jar.pdf

nl-sql.jar.pdf

2.63 KB

December 10, 2012

Processed