SoapUI's JDBC Request

Source: Internet
Author: User
Tags soapui

Before have tried jmeter jdbc request, very convenient, this afternoon idle to nothing, see soapui inside also has a JDBC request, also come to try.

First, add a JDBC request, and then directly copy some of the link parameters of JMeter in the past, always error, unable to access the database. Then Baidu looked at the next, and finally to the official online to find the answer, recorded for sharing, after you encounter similar needs to use, you can not hit the head!

1. Add a JDBC Request

2. When you are finished adding, see the JDBC content page:

We need to add the driver and the connection string ourselves.

Note: The driver needs us to download, Mysql-connector-java-5.1.7-bin.jar, download, and put it directly under the Soapui Lib folder.

See the above connection method, I just said here is the connection mode of MySQL.

Driver:mysql/com.mysql.jdbc.driver ----> here is how Mysql drives the reference.

Connection string:jdbc:mysql://120.44.25.15:3306/test?user=root&password=123456 ----> here is how to concatenate the database strings. The following are special instructions:

The connection string is made up of the following methods:

jdbc:mysql://ip[database server IP Address]:p ort[port number]/database[database name]?user=[fill in the login database user name]&password=[password]

3. Click the Green: Test Connection button to see if the connection is successful, and if successful, you will see the following prompt box:

4. You can then enter the corresponding SQL statement in the input box below to see that the query was successful!

This is even if the connection and the use of success, if it is a complex SQL statement, you may need to study the stored procedures themselves, there is an option to check the stored procedures.

Hope can help everyone!

SoapUI's JDBC Request

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.