jmeter连接数据库
Database URL为数据库的JDBC连接字符串
JDBC Driver class 为驱动类名称,需将对应jar包放入到jmeter's/lib目录下(放入后,建议重启jmeter)
Username :数据库用户名
Password:数据库账号对应的密码
Database URL、JDBC Driver class 填写方式
数据库名 | Database URL | Driver class |
MySQL | jdbc:mysql://host[:port]/dbname | com.mysql.jdbc.Driver |
PostgreSQL | jdbc:postgresql:{dbname} | org.postgresql.Driver |
Oracle | jdbc:oracle:thin:@//host:port/service OR jdbc:oracle:thin:@(description=(address=(host={mc-name})(protocol=tcp)(port={port-no}))(connect_data=(sid={sid}))) | oracle.jdbc.OracleDriver |
Ingress (2006) | jdbc:ingres://host:port/db[;attr=value] | ingres.jdbc.IngresDriver |
Microsoft SQL Server (MS JDBC driver) | jdbc:sqlserver://host:port;DatabaseName=dbname | com.microsoft.sqlserver.jdbc.SQLServerDriver |
Apache Derby | jdbc:derby://server[:port]/databaseName[;URLAttributes=value[;…]] | org.apache.derby.jdbc.ClientDriver |
DM | jdbc:dm://host:port/{dbname} | dm.jdbc.driver.DmDriver |
sequoiaDB | ||
oceanbase | jdbc:mysql://host[:port]/dbname (?) jdbc:oceanbase://host[:port]/dbname (?) | com.mysql.jdbc.Driver (?) com.alipay.oceanbase.obproxy.mysql.jdbc.Driver (?) |
备注:DB(达梦)数据库等,需要有对应的jdbc jar包
参考网址