MySQL

Querying a MySQL database with LoadRunner

Querying a MySQL database with LoadRunner

Let's imagine that you want to execute arbitary SELECT, INSERT, UPDATE and DELETE queries against a MySQL database from a VuGen script. Obviously it is easiest to use the JDBC libraries from a Java-based script, but most people aren't licensed for any of the Java-based vuser types.

It is much more useful to be able to interact with MySQL from a C-based vuser script, such as the Web (HTTP/HTML) vuser type. JDS has already released code that allows you to use MySQL instead of the Virtual Table Server from a C-based script, but this code will allow you to run any query you like.

Read More

Posted by JDS Admin in Tech Tips
Persistent data in VuGen with MySQL

Persistent data in VuGen with MySQL

One of the main drawbacks with VuGen is the inability to easily store data for later retrieval, and the lack of interscript communication. I had this exact problem on a recent assignment, the problem was that the business process involved a batch process that needed to run before the rest of the business process could continue. The business scenario looked like this:

Read More

Posted by JDS Admin in Tech Tips