SQLUnit GUI Tool

The SQLUnitGUI Tool is a Swing based application for generating test cases by running the stored procedure against the database. The tool will append to the capture file defined in the properties file for the application. This is a very basic tool, it does not have any elegant error handling, but it works. The original version of the tool was contributed by Mohan Iyer, who used it to generate SQLUnit test cases against an Oracle database. The tool has been changed since to be more database agnostic.

To start the tool from the command line using, you can use the ant gui command defined in the supplied build.xml file. Alternatively you can set up a batch file or shell script to include the SQLUnit and JDOM JAR files in your classpath and invoke the following command:

$ java -Drcfile=guiconfig.properties net.sourceforge.sqlunit.tools.GUITool

Here are some screenshots of the SQLUnit GUI Tool.

A sample guiconfig.properties is provided in the etc directory in the distribution. Please modify it to suit your own installation.

Currently the tool just works. It does not provide user conveniences such as drop down lists of valid values, and will not return user-level messages on exceptions. I am neither too interested in Swing/GUI development nor very capable in this regard, so any changes I make to this tool would be for my own benefit, to support some feature I need. If anyone is interested in improving the tool and making it more user-friendly, you are welcome to send me a patch on the CVS version or the complete source code as an email attachment, and I will be happy to put it in CVS and give you credit.

Mohan Iyer envisaged that this basic Swing application could be leveraged to provide various editor plug-ins for SQLUnit. If anyone is interested in doing this, please feel free to go ahead and send me the plug-in code and I will be happy to put it in CVS and give you credit. Since I dont use IDEs myself, I will just take your word for it that the plug-in works.