JMeter connecting DB database via Org.sqlite.JDBC Drive

Recently encountered a project, the default business library is built-in DB database, in the performance script editing process to obtain the corresponding ID number through the Regular Expression Extractor (association), through the ID number to the DB database to find the corresponding data Source Name field content, Make the parameters (parameter) variable for the next post request.

Due to the lack of access to the DB database, official Help documents are not introduced, the following combination of Niang content and personal experience summarized as follows:

1, the required driver: Org.sqlite.JDBC (sqlite-jdbc-x.xx.x.jar), driver download can click "Original path"

Analyze the driver file to see the required driver's class as shown in (source path)

　　

2, the database path settings, the Internet generally refers to the db file placed in the Jmeter/bin folder, set the database Url=jdbc:sqlite:test.db way, but I did not succeed/(ㄒoㄒ)/~~, simply change directly to the database URL =jdbc:sqlite:d:\java_software\apache-jmeter-3.0\apache-jmeter-3.0ly\bin\ime.db, i.e. (Database URL=jdbc:sqlite: DB data absolute path), try OK.

3, Configuration display:

　　JDBC Connection Configuration

　　

JDBC Request Configuration

　　

　　The execution results show:

Other database configuration can be referenced (I did not verify): http://m.blog.csdn.net/amoscn/article/details/74991924

JMeter connecting DB database via Org.sqlite.JDBC Drive