Browse Prior Art Database

Method for reproducible unit test of database applications using table renaming

IP.com Disclosure Number: IPCOM000015972D
Original Publication Date: 2002-Oct-10
Included in the Prior Art Database: 2003-Jun-21
Document File: 2 page(s) / 50K

Publishing Venue

IBM

Abstract

Method for reproducible unit test of database applications using table renaming

This text was extracted from a PDF file.
This is the abbreviated version, containing approximately 53% of the total text.

Page 1 of 2

Method for reproducible unit test of database applications using table renaming

  Method for reproducible unit test of database applications using table renaming

Disclosed is a system for unit testing database client applications. This document consists of the following:

Problem Statement


1.


2.


3.

1. Problem Statement

In unit tests of database client applications, one or more tests that access the same database table may be run concurrently by one or more testers. In such situations, the tests of database client applications, which should be independent of each other, depend on each other.Two ways to avoid this problem have been proposed but both introduce other limitations. One way is preparing a database for each tester to avoid sharing database, but it puts the burden of creating and maintaining database on each tester. The other way is intercepting SQL requests to the database server and replacing COMMIT requests with ROLLBACK, but it changes the test results of applications in which the difference of COMMIT and ROLLBACK is significant.

2. Proposed Solution

In the proposed system, technique called "table renaming" is used. Table renaming automatically redirects the database table references in the tested application in such a way that it is assured that no concurrent access to database tables occurs. Table renaming requires a way to setup the tables referenced by the tested application assuming that the table references are redirected. Applying table renaming on command files that setup the database tables and executing t...