Download Shareware and Freeware Software for Windows, Linux, Macintosh, PDA

line Home  |  About Us  |  Link To Us  |  FAQ  |  Contact

Serving Software Downloads in 976 Categories, Downloaded 32.403.486 Times

SQLUnit 5.0

Company: SQLUnit Team
Date Added: September 27, 2013  |  Visits: 284

SQLUnit

Report Broken Link
Printer Friendly Version


Product Homepage
Download (29 downloads)



SQLUnit is a regression and unit testing harness for testing database stored procedures. An SQLUnit test suite would be written as an XML file. The SQLUnit harness, which is written in Java, uses the JUnit unit testing framework to convert the XML test specifications to JDBC calls and compare the results generated from the calls with the specified results.<br /><br />Stored procedures are often used to provide an object abstraction to the underlying relational data store. The object abstractions are consumed by Java middleware programs. In shops where this is the case, Java programmers often use the popular JUnit testing framework to unit test their code. Using SQLUnit to unit test the database stored procedures thus becomes a natural extension of the unit testing process, and provides unit testing coverage for a layer that is often neglected in this respect.<br /><br />Based on the realization that the stored procedure author need not be the same person who writes the Java code, and may not even know Java or JUnit, SQLUnit provides an XML language to write test suites. Even for those stored procedure authors who can write JUnit tests, the repetitive nature of JDBC programming would, over time, encourage the author to refactor the common parts of the tests into utility classes. SQLUnit already provides this functionality, except it goes one step further and abstracts the test specification out of Java into XML.<br /><br />The XML itself is fairly small and easy to learn for anybody and should be instantly intuitive to a person who is already familiar with JUnit.<br /><br />Further, since SQLUnit is written in Java and uses JDBC to communicate with the database, it should be possible, at least in theory, to write unit tests for stored procedures for any database that provides a JDBC driver. In reality, some porting may be needed for each new database, based on proprietary database vendor-specific extensions made over the SQL standard and the subset of the JDBC API implemented by the supplied JDBC driver. However, the porting activity should be relatively painless.

Requirements: No special requirements
Platforms: Mac, Mac OSX
Keyword: Author Calls Database Driver Harness Junit Object Person Porting Procedure Procedures Sqlunit Stored Testing Tests Write Written
Users rating: 0/10

License: Shareware Size: 4.7 MB
USER REVIEWS
More Reviews or Write Review


SQLUNIT RELATED
Database Tools  -  PostgreSQL Database Driver 1.0
PostgreSQL Database Driver comes with a class that manages connections to a PostgreSQL database server. It comes also with a class to perform SQL queries and retrieve the results.The connection class can executes queries and manage transactions....
10 KB  
Libraries  -  DBI::DBD 1.52
DBI::DBD is a Perl DBI Database Driver Writers Guide. SYNOPSIS perldoc DBI::DBD Version and volatility This document is still a minimal draft which is in need of further work. The changes will occur both because the DBI specification is...
409.6 KB  
Libraries  -  DBD::Oracle 1.19
DBD::Oracle is a Perl module with Oracle database driver for the DBI module. SYNOPSIS use DBI; $dbh = DBI->connect("dbi:Oracle:$dbname", $user, $passwd); $dbh = DBI->connect("dbi:Oracle:host=$host;sid=$sid", $user, $passwd); # See the...
368.64 KB  
Libraries  -  DBD::Informix 2005.02
DBD::Informix is a Perl module witj IBM Informix Database Driver for Perl DBI. SYNOPSIS use DBI; You should also read the documentation for DBI perldoc DBI as this document qualifies what is stated there. Note that this document was last...
276.48 KB  
Libraries  -  DBD::MaxDB 7.6.00.27
DBD::MaxDB is a Perl module for MySQL MaxDB database driver for the DBI module version 7.6.0 BUILD 027-121-124-939. SYNOPSIS use DBI; $dbh = DBI->connect("dbi:MaxDB:$hostname/$dbname", "$user", "$password") or die "Cant connect $DBI::err...
87.04 KB  
Programming  -  DBD::Pg 2.14.0
DBD::Pg - PostgreSQL database driver for the DBI module DBD::Pg is a Perl module that works with the DBI module to provide access to PostgreSQL databases.
235.52 KB  
Development Tools  -  RNEL_DB Object Oriented Database for Matlab 1.0
RNEL_DB is an object oriented database solution for large data sets that need to be stored and/or analyzed within Matlab. It provides a transparent solution for people that currently store their data in matlab-structures.Using the RNEL_DB...
460.8 KB  
Database Tools  -  ClsMySQL 1.0
A singleton, that concentrates access to a MySQL database into a single object, is implemented.ClsMySQL can perform the usual database access operations like establishing database server connections, executing SQL queries, retrieving results into...
10 KB  
Development Tools  -  Cowloop driver 3.0
The cowloop driver allows block-devices or files to be used in a read-write fashion without modifying the block-device or file itself. Modified data-blocks are not written back to the original read-only device, instead they are written to a...
 
Utilities  -  AnalogX CallerID 1.2
AnalogX CallerID can use any Unimodem/V-compatible voice modem that has Caller ID support to easily track incoming calls including: who is calling and their number (if available), how many calls have been received from this person, when the first...
370 KB  
NEW DOWNLOADS IN MACINTOSH SOFTWARE, PROGRAMMING
Macintosh Software  -  VideoSolo Video to GIF Converter (Mac) 1.0.12
How to make a GIF? VideoSolo Free Video to GIF Converter for Mac supports all popular video files including MP4, AVI, MOV, WMV, FLV, M4V, etc. You can easily turn MP4/AVI/MOV/WMV/FLV/M4V to GIF animation on Mac and share your GIFs with your...
46.51 MB  
Macintosh Software  -  VideoSolo Free Video Converter (Mac) 1.0.18
VideoSolo Free Video Converter for Mac is a fast, powerful and easy-to-master video converter. Its main purpose is to convert video files from one format into another. It is able to convert video and audio files in 300+ formats on Mac for totally...
75.29 MB  
Macintosh Software  -  VideoSolo Video Converter Ultimate (Mac) 1.0.18
VideoSolo Video Converter Ultimate for Mac is known for its ability to accept a wide-arrange of video formats. The list of video file types VideoSolo Video Converter Ultimate can input is extensive, including AVI, MP4, MPEG, VOB, MOV, and FLV,...
52.56 MB  
Macintosh Software  -  VideoSolo Blu-ray Player (Mac) 1.0.10
VideoSolo Blu-ray Player offers outstanding video quality and support for playback of Blu-ray discs, Blu-ray folders, and ISO image files. With VideoSolo Blu-ray Player, you'll be able to play Blu-ray discs released in different global regions....
34.92 MB  
Macintosh Software  -  Stellar Volume Repair 3.0
Stellar Phoenix Volume Repair tool can repair corrupt and damaged Mac hard drives with ease. The software has been designed to rebuild the damaged directory structure and replaces the damaged one with the repaired directory. When the directory of...
15.63 MB  
Programming  -  MacX Free iMovie Video Converter 4.1.8
MacX Free iMovie Video Converter is a professional free iMovie video converter for Mac that can convert any SD and HD videos such as M2TS, MKV, AVI, WMV, FLV, VOB, 3GP and more to iMovie accepted video formats MOV & MP4 for importing to iMovie...
22.92 MB  
Programming  -  TclAppleScript 2.0 Beta
The AppleScript command dates back to the days of the Classic MacOS, and was originally designed as a stopgap command to fill the place of "exec" on the old Classic MacOS. Much of its original code and commands are now obsolete, and its public API...
276.48 KB  
Programming  -  SwapList 0.1 Alpha
Java list implementation that swaps list items to a disk file in order to avoid out-of-memory error.
10.24 KB  
Programming  -  Custom Console 2.5
Write Your own Language or Batch Based Executable Programs in Java Runtime Environment. Use Custom JAR files as Command Line commands with this custom command line console program. Simply write your JAR files to accept Main String Arguments and...
286.72 KB  
Programming  -  Mano 1.05 Beta
Mano is a makeFile navigator containing a tree grouping the targets.
20.48 KB