do JDBC request , First of all, understand this JDBC What is the object , Then look for the database connection to the response URL And database driver .

database URL:jdbc:sqlserver://200.99.197.190:1433;databaseName=ebank

Database driven :com.microsoft.sqlserver.jdbc.SQLServerDriver

download sqljdbc4.jar Put it in apache-jmeter-2.6\lib below

Sqlserver Drive pack (jar) name :

Microsoft+SQL+Server+JDBC+Driver+3.0sqljdbc_3.0.1301.101_chs.exe

-- Download and unzip sqljdbc4.jar Put in apache-jmeter-2.6\lib below

The method I use is to specify the driver class by connecting to the database , Some people use JTDS The driver class of the open source community , Different driver classes correspond to jar Different , Be sure to pay attention to .

Connect to the database and specify the driver class ( You can download the standard version of sqlserver drive )

ClassName ="com.microsoft.jdbc.sqlserver.SQLServerDriver";

Access database Url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=db_JXC;SelectMethod=Cursor";

JTDS The driver class of the open source community ( I don't know where to download ,JTDS The open source community ?)

Class.forName(net.sourceforge.jtds.jdbc.Driver).newInstance();

DriverManager.getConnection("jdbc:jtds:sqlserver://localhost:1433/"+"library"," user "," password ");

Datebase

Driver class

Database URL

MySQL

com.mysql.jdbc.Driver

jdbc:mysql://host:port/{dbname}

PostgreSQL

org.postgresql.Driver

jdbc:postgresql:{dbname}

Oracle

oracle.jdbc.driver.OracleDriver

jdbc:oracle:thin:user/pass@//host:port/service

Ingres (2006)

ingres.jdbc.IngresDriver

jdbc:ingres://host:port/db[;attr=value]

MSSQL

com.microsoft.sqlserver.jdbc.SQLServerDriver

perhaps

net.sourceforge.jtds.jdbc.Driver

jdbc:sqlserver://IP:1433;databaseName=DBname

perhaps

jdbc:jtds:sqlserver://localhost:1433/"+"library"

In the above table are the collected database driver classes and URL Format

add to JDBC Default connection request , That is to say MS sql Connection information : database URL( Different driver classes have different connection strings )、MSSQL Driver class 、 Database username password .

add to JDBC request , Here is the stored procedure statement that I executed . Parameterization is used in the statement

Parameterization uses jmeter Control for , No function assistant .

And also used assertions in this script , because JDBC Request ( stored procedure ) There is one of them. SQL Return value , If returned to 1, The stored procedure is executed successfully

jmeter( 8、 ... and )-JDBC request (sqlserver) More articles about

  1. Jmeter send out JDBC request

    I spent two hours in the afternoon studying Jmeter send out JDBC request , Now let's share the basic operation process . do JDBC request , First, we need two jar package :mysql drive -mysql-connector-java-5.1.13-bi ...

  2. JMeter Handle jdbc Response result after request

    JMeter If carried out JDBC request , How to use the response result after the request for the next request ( That's the connection in the legend ), So I studied , Now I will make a record of the learning achievements : 1. add to "JDBC Connection Confi ...

  3. Jmeter And JDBC request ( Four )

    That we use a lot Jmeter The function of the HTTP request .JDBC Request.SOAP/XML -RPC Request, this 3 A request , Now let's introduce What is? JDBC request First , Right click “ test plan ” ...

  4. Jmeter Use JDBC Ask for a brief introduction

    1. Now? oracle or mysql Of jdbc Then put jmeter Of lib Under the path 2. add to jdbc Default request control . 3. add to jdbc request 4. send out 5. appear ORA-00911 The error is due to sql sentence in wrong , Don't worry ...

  5. Jmeter And JDBC Request parameterization ( One )

    One . Environmental preparation a.jmeter5.1.1 The latest version , You can go to the website to download :https://jmeter.apache.org/download_jmeter.cgi b.jdbc drive : link :https:/ ...

  6. jmeter And JDBC request

    jmeter Not only can it be tested http request , It can also be executed JDBC The requested test . This time with mysql For example , Introduce JDBC How the request is sent Catalog 1. Environment configuration 2. Database connection configuration 3. Add one JDBC request 1. Environment configuration ...

  7. jmeter And JDBC Problems encountered with the request

    1. Time zone setting problem Cannot create PoolableConnectionFactory (The server time zone value '???��������??��??' is ...

  8. Jmeter And JDBC Request parameterization ( Two )

    Two . I've already talked about some basic configurations , And simple jdbc request , Let's see how to parameterize the query statement . There are several ways to parameterize ,foreach, Counter ,csv etc. , Here are some methods .

  9. 【jmeter】JDBC The problem of request loop call

    Use today jdbc Request to get data from the database , Multiple requests using loop controller , But the first one jdbc The request return value is correct , The return value of the second request is null . 1. From other blogs , Need to be in jdbc connection configur ...

  10. Jmeter Of JDBC Request to execute multiple SQL sentence

    notes : Yes mysqlconnector/j 3.1.1 The above version only supports the execution of multiple sql sentence 1.      download jdbc Drive to connect Mysql database , There needs to be a jdbc drive :mysql-connector-ja ...

Random recommendation

  1. HDU 1671 Phone List

    A template problem of dictionary tree , Query whether a prefix substring of the string exists before each insertion , Or whether the string is the prefix of a string . The specific implementation is to make a mark at the end of the string when inserting , If a string finds a tag when querying , The description has a prefix : The second case is the string pass ...

  2. R Language operation database

    The following is from http://www.douban.com/note/172387172/ CRAN There are a lot of them R Database support package for , send R Can read and write to the database . These bags have :RODBC.DBI.RMySQL.RO ...

  3. java The third class : Branching structure 、 Loop structure

    Branching structure 1.if You don't need to add {}, But not recommended , Easy to misunderstand 2. When writing a program, first prevent the loser test , Write logic again , Otherwise it will go wrong 3.if: A branch if else: The two branch if...else if...: Multiple branches ( junction ...

  4. from x_x Baidu Space

    Kong Hua's life         by  Indifferent mood yesterday , Yesterday again . today , Today again . Tomorrow, , Tomorrow again . The calendar is thinning out , I suddenly found out , It's a trace of time . Seems to be , Always waiting in numbness . when , To go through . Then calculate , How many days do I have ...

  5. ICMP Message analysis

    One . summary : 1.   ICMP Agree host or route to report error and provide relevant exception .ICMP It's the standard protocol for the Internet , but ICMP It's not a high-level agreement , It is IP Layer protocol . Usually ICMP The message is IP Layer or higher protocol (TCP or UDP) ...

  6. use php and imagemagick To handle the image file upload and zoom processing

    What also don't say , Go straight to the code , You can add watermark function by yourself : <?php /** * * @author zhao jinhan * @date 2014 year 1 month 13 Japan 11:54:30 * @email  ...

  7. Unity C# GetSaveFileName() Application

    This article is original. , Reprint please indicate the source :http://www.cnblogs.com/AdvancePikachu/p/6944870.html ah , This time it's great , I searched the Internet for a long time , Finally, I found the Chinese saving dialog , root ...

  8. Windows Service Learning Series ( One ): Establish a simple Windows service

    Reference resources :https://www.cnblogs.com/cncc/p/7170951.html One . development environment operating system :Windows 7 X64 development environment :VS2017 programing language :C# .NET edition : ...

  9. LoadRunner Vuser Test scripts add preconditions, for example

    Before calling the interface, you need to get the login token, Put it in the header . /* * LoadRunner Java script. (Build: 3020) * * Script Description: Interface performance test pin ...

  10. solve kali linux Install after upgrade w3af problem

    1. stay kali linux Lower installation w3af There will be a lot of problems , Because of the new version of kaliLinux , as well as python The configuration of the environment and There are many errors in the installation of the library kali linux The environment usually comes with itself git install ...