JDBC Connection Through JMeter
6:31:00 PM vikas 0 Comments Category : JMeter
JMeter "JDBC Connection" for Oracle DataBase(PLSQL)
We can use JMeter which will reduce our manual effort to execute Any PLSQL query You can easily get JDBC connection configuration for MYSQL. This Post is for ORACLE DataBase (PLSQL)connection configuration through JMeter.
Here steps define to connect your ORACLE DataBase through JDBC connection
- Open a test plan and add a thread group
- Add a "JDBC Connection Configuration" from Configuration Element inside the thread group
- configure the "JDBC Connection Configuration" with respective details as mentioned below
#Variable Name: - Need to give a name for JDBC pool. we need to use same pool name while executing the query. - For MYSQL: - Select 1
- For ORACLE(PLSQL): - Select 1 From Dual
- Add JDBC request sampler from sampler
#Variable Name: - The variable name should be same as we given in Step 3. Over here the variable name is "connectionsetting"
- Write your SQL query and execute it for a successful result.
#Pool Configuration: - If you have any no. of virtual user to hit the database give on the "Max number of connection" otherwise leave it as 0(ZERO). Also, put some time out time. #Connection Validation by Pool: - Here the main part is validation query
You need to mention the JDBC driver class but before you need to download latest Oracle JDBC jar file and need to place that file inside "D:\apache-jmeter-3.0\lib" and mention the driver name over here Also, provide the right credentials to connect the DataBase