This topic explains how to configure and apply the DB tool in SOAtest and Virtualize. Sections This tool allows you to query databases for validating SQL statements with SOAtest.Sections include:
| Table of Contents | ||
|---|---|---|
|
...
Enable the Local option and specify the Driver, URL, Username, and Password of the database to be queried. You . For more information on configuring database connection settings, see Database Configuration Parameters in SOAtestor Database Configuration Parameters in Virtualize.You can also enable the Close connection option to close the connection if you are querying the database once and do not need to wait for another command. Do not enable this option when you plan to connect multiple DB tools to the same DB so that all tools can share a connection. Sharing the connection improves resource efficiency, as opposed to using resources on a new connection for each DB tool.
If your test suite has a Database Account shared property, you can connect UseLocal Settings, Use Shared Property, or Use Both. These options enable you to use only settings within the corresponding DB tool, settings from a shared global database account (global database settings that you added to the test suite as a Global Property), or both. . For more information on how to define shared properties and export them to a file, see Adding Global Test Suite Properties in SOAtest or Adding Global Properties in Virtualize.
| Info | ||
|---|---|---|
| ||
The Traffic tool shows a connection ID. Checking this ID will help you ensure that your DB tools are using the same connection. |
...
Oracle databases support various proprietary data types. If your database utilizes these data types. For , you must add the appropriate jar(s) to the JDBC classpath in the Preferences panel (go to Parasoft > Preferences > Parasoft > JDBC Drivers).For example, Oracle supports oracle.xdb.XMLType. This is available with xdb.jar and xmlparserv2.jar, which are shipped with specific Oracle applications. It is also available from the XML Developer's Kit (XDK) Java, which is available at http://www.oracle.com (click Downloads, click the link for the XML Developer Kit, then select the kit for any platform). Note that this kit contains other files, but you need only the two listed above.
...