Jmeter数据库连接,配置JDBC Connection Configuration时,Validation Query字段要填写的内容:
验证查询的列表可以配置 jdbc.config.check。查询属性,默认情况下:
hsqldb:select 1 from INFORMATION_SCHEMA.SYSTEM_USERS
Oracle:select 1 from dual
DB2:select 1 from sysibm.sysdummy1
MySQL:select 1
Microsoft SQL Server (MS JDBC driver):select 1
PostgreSQL:select 1
Ingres:select 1
Derby:values 1
H2:select 1
Firebird:select 1 from rdb$database