About

- Overview
- Download
- Changes
- Known Bugs
- License
- TODO
- Contributors

Documentation

- User Manual
- Developer Manual

Community

- Get Involved
- Mailing Lists
- CVS Repositories

JDBC Test Controller

> The JDBC Test controller is a generative controller whose function is to create a single test case for FTP applications. The JDBC Test allows you to configure an FTP sample:

> - Username : Username to use to connect to server
> - Password : Password to user to connect to server
> - Database URL : This includes the host name plus database name. It should be in the correct format for the database being tested (usually hostname/database name)
> - Sub Protocol : The sub-protocol to use with your specific database (ie "mysql" for MySQL)
> - Driver Class : The full class name of your driver (ie org.gjt.mm.mysql.Driver)
> - Number of Connections in Pool : JMeter will use a pool of connections that you can configure. Set here how many connections you would like the pool to maintain
> - Max usage for each connection : JMeter will automatically re-initialize SQL connections that have been used a certain number of times. You can change the max usage for each connection here.
> - SQL Query String : Finally, the actual SQL query you want to test.

> Note: If you were going to test multiple SQL queries, you would probably want to add a "Database Login" config element to the top of your test tree, and configure the username, password, database URL, sub-protocol, and Driver class in just the one place. You can similarly add a "Database Connection Pool" config element.

Example test tree

Copyright © 1999-2001, Apache Software Foundation