Welcome to the new Parasoft forums! We hope you will enjoy the site and try out some of the new features, like sharing an idea you may have for one of our products or following a category.

Db tool configuration

sachin
sachin Posts: 17 ✭
in SOAtest

Please help to share the steps to configure db tool in top of the package to check the connectivity is success or not.

If the connection success then rest of the scenario will execute otherwise it will terminate the process.

The reason behind this in order to save db locking

Comments

  • benken_parasoft
    benken_parasoft Posts: 1,313 ✭✭✭
    edited December 2024

    share the steps to configure db tool in top of the package to check the connectivity is success or not.

    You could add a DB Tool as a set-up test. Aside from establishing a connection, the DB Tool must also execute a SQL statement. You could provide a trivial SELECT or DESCRIBE statement, for example.

    If the connection success then rest of the scenario will execute otherwise it will terminate the process.

    There are various options to configure test execution to abort on errors or to configure tests to be conditionally skipped depending on the success of other test cases. For example, you could enable the option to Abort Scenario on Fatal Error.

    The reason behind this in order to save db locking

    I also recommend adding a Global Database Account Property then referencing it all your DB Tools. Disable "Close Connection" to reuse the connection across multiple tests. The connection will always be closed automatically at the end of the execution. You can also review the Auto-Commit and Rollback options.

  • sachin
    sachin Posts: 17 ✭

    Please help to share the steps for setup test - db tool connection.do we have to create any variable to store the info?

    If the connection is success then rest of the test suite will execute or or it will not proceed with next step.

  • benken_parasoft
    benken_parasoft Posts: 1,313 ✭✭✭

    Please help to share the steps for setup test - db tool connection

    You should add a Global Database Account Property. This is where you provide the connection settings.

    You can configure a DB tool as a set-up test:
    DB
    Adding Set-Up and Tear-Down Tests

    The DB tool's connection settings can reference the Database Account Property:
    Connection Tab

    On the SQL Query Tab, just provide some trivial SQL statement, like a SELECT or DESCRIBE statement.

    If the connection is success then rest of the test suite will execute or or it will not proceed with next step.

    You can enable the option to Abort Scenario on Fatal Error. The DB tool will report a fatal error if it can't connect.

Categories