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 29.542.085 Times

SQLUnit 5.0

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

SQLUnit

Report Broken Link
Printer Friendly Version


Product Homepage
Download (28 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  
Database Tools  -  nsFB 1.2
nsFB is an internal AOLserver database driver for the Firebird or Interbase database. It supports reading and writing BLOB data and ARRAY data. nsFB project supports the full size of varchar (32765 bytes) or char (32767 bytes). Many...
22.53 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...
 
NEW DOWNLOADS IN MACINTOSH SOFTWARE, PROGRAMMING
Macintosh Software  -  Cisdem Data Recovery for Mac 4.1.0
Using advanced scanning technology and directory restructuring algorithm, Cisdem Data Recovery for Mac can help you to recover lost valuable data, documents, emails, videos, music, photos, and lost partitions from any Mac...
6.6 MB  
Macintosh Software  -  NoteBurner M4V Converter Plus for Mac 4.2.9
NoteBurner M4V Converter Plus for Mac is the best solution for Mac users to convert iTunes DRM M4V movies. This powerful M4V DRM removal tool helps you to remove both iTunes purchased M4V movies (including iTunes Extras) and rentals from iTunes...
22.93 MB  
Macintosh Software  -  iDoctor 2.0
iDoctor equips Mac users with 15 cleaning and optimization tools to make their working on Mac easy and simply. With iDoctor’s help you can also manage, encrypt, backup, recover or shred files with just a couple of mouse clicks. Thus,...
98 KB  
Macintosh Software  -  AnyMP4 Free iPhone Data Recovery for Mac 7.3.18
AnyMP4 Free iPhone Data Recovery for Mac can allow you to recover deleted files from iPhone/iPad/iPod like Camera Roll, Notes, Reminders, Voice Memos, and Safari Bookmark on Mac. You can directly recover deleted data from iOS Device like...
24.4 MB  
Macintosh Software  -  AnyMP4 DVD Ripper for Mac 6.3.16
AnyMP4 DVD Ripper for Mac not only help you rip DVD movies to any video formats like MP4, MOV, M4V, AVI, WMV, FLV, MKV, MPEG and more for Mac, but also rip DVD to other audio formats such as MP3, FLAC, WAV, WMA, AAC, ALAC, AC3 and more for Mac....
43.8 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