Eclipse Plug-in for Generating and Executing Test Cases for Database Objects

1. What databases does TC4DBO support?

TC4DBO supports IBM® DB2® UDB, Oracle, SQL Server, and Informix database.

Back to top

2. What kinds of unit test frameworks does TC4DBO support?

TC4DBO supports JUnit and SQLUnit.

Back to top

3. How do I create a TC4DBO project?

Create a Java™ project. Then right-click on the Java project and select Enable TC4DBO on the pop-up menu.

Back to top

4. How do I generate unit test code?

• From the menu, choose File > New > Other.
• On the wizard page, choose the wizard Stored Procedure Test Case.
• Choose either Junit Test Case or SQLUnit XML Test Case.

Back to top

5. How do I run generated SQLUnit test code?

We can use the ant task to run the SQLUnit test scripts. There are two ways to do this job:

The first way is to run the test case in WSAD:

• Right-click on the build.xml file.
• Select the Run as button in the tool bar.
• Select the Run As > Ant Build… menu.
• Select test target in the targets tab.
• Set Base Directory to the path of build.xml.
• Set Arguments to either

— Dscript.name&=<script file name>

or

—Dscript.dir=<the folder which you want to run>

The second way is to run the ant task in cmd. You must first have put the path of ANT_HOME\bin into the Environment Variables. Then cd to the folder of build.xml, and run either of the following:

ant —Dscript.name&=<test script name>

—Dscript.dir&=<the folder that contains the scripts>

You can find the report in the output folder.

Back to top

6. Where can I get more details about SQLUnit?

Please refer to SQLUnit User Guide.

Back to top