| SQLUnit User Guide | ||
|---|---|---|
| <<< Previous | Next >>> | |
Work is currently going on to port SQLUnit (or to just make it run on) various databases. Here is the status of the porting efforts till date. If you are running SQLUnit with databases other than those listed below, let us know, and we will add in your information as well. If you are planning to run SQLUnit with a database not listed below, you probably will have no problems. Most non-standard features (such as Oracle CURSORs, multiple resultsets in Sybase, etc) have been identified and accounted for in the SQLUnit code. In case you do have problems, however, please let us know on the forum.
Table 1. Ports of SQLUnit to different databases
| Database Name (Version) | Porter | Status |
|---|---|---|
| PostgreSQL 7.3 | Sujit Pal | Complete. PostgreSQL was used to do a proof of concept of the initial release of SQLUnit. It has been used thereafter to test new features as they are developed. |
| MySQL 3.4 | Sujit Pal | MySQL does not support stored procedures or functions, but it has been used to test the batch tags, the diff and the sql tags. It plays nicely with SQLUnit. MySQL will support stored functions tentatively in version 5, so we will revisit this when that happens. |
| Oracle | Sahib Singh Wadhwa, Andrei Grigoriev, Sujit Pal | Complete, with a lot of patches and bug reports from Sahib and Andrei. Thanks to Andrei for running SQLUnit through a very thorough testing with Oracle and getting the last few Oracle CURSOR specific bugs ironed out. |
| Sybase ASE 12.5 | Sowmya Shetty, Lakshmi, Sujit Pal | Complete, with lots of testing support from Soumya Shetty and Lakshmi |
| IBM DB2 | Sujit Pal | Started June 05, 2003. In progress. The stored procedures were written in C, the Java stored procedures had issues running under JDK 1.4. Still need to build a test suite and run them. |
| HSQLDB (formerly Hypersonic) | Campbell Boucher-Burnett | In progress |
| Informix SE 7.0 | - | Not started. This should work, but has not been tested. The test cases are available in CVS, but the JDBC driver that I had available had issues with working with PAM authentication on Linux. If someone has a working setup of Informix, then I would appreciate you running the tests and letting me know the results. |
| Microsoft SQL Server 2000 | James Henderson, Paul King | On May 29, 2005, James contributed his suite of MS SQL Server tests that he uses to regression test SQLUnit. Earlier, on May 20, 2004, Paul reported that he has been using SQLUnit to test MS SQL Server 2000 for some time, but has not tested the LOB feature yet. |
| Sybase ASA 9.0.1 | David Fishburn | Complete, test suite included with distribution (test/asa/README) |
| <<< Previous | Home | Next >>> |
| Historical Trivia | License Information |