Author: Lukasz Grela
Version: 1.0
Last update: Mon Feb 20 13:49:12 CET 2006
Introduction:
This test specification guides tester through all test cases of DB Derby Module.
Purpose: Tests that it is possible to register Derby Database
Setup: derby database is required, there are two ways: download from website or install Sun Application Server which contains derby by default
#
Test case
Description
1
Setup Derby settings
1.
Choose Tools > Options from the main window. 2.
Click Advanced Options in the Options window. 3.
In the left pane of the Options window, expand IDE Configuration > Server and External Tool Settings > Derby Options.
Set the Derby location that points to directory where derby is installed 4
Set the folder where your Derby databases are stored in the Database Location property.
Click Close.
RESULT:
Derby Database menu item appears under Tools in the main window.
Purpose: Test creating Derby Database and check whether dialog that is using for creating database expose desired functionality.
Setup: Register Derby Database, Run Derby Server
#
Test case
Description
1
Create Derby Database
1.
Choose Tools > Derby Database > Create Derby Database 2.
Enter a name for the database, a user name, and a password. 3.The button "OK" should be enable - click on it to create database.
RESULT:
All actions are done correctly, In the Runtime window, expand Databases > the new node should be visible which represent new database
2
Connection to database
1.
Cretate databse - repeat previous testcase
2.Pick Connect item in popup menu on created database node - to connect to database
3.Click on database node - you should be able to expand it and nodes that represent "Tables" "Views" and "Procedures" should be visible
RESULT:
All actions are done correctly.
2
Check that Dialog exposes desired behaviour
1.
Choose Tools > Derby Database > Create Derby Database
2. Check that "OK" button is disable when the field "Database name" is empty, and there is a message on bottom "Database name is empty".
3. Check if in case that User Name and/or password are empty the warning message is visible that recommends to enter User name and password.
RESULT:
All actions are done correctly.
3
Check that additional dialog appears when Database Location is not set
1.
Choose Tools > Options from the main window. 2.
Click Advanced Options in the Options window. 3.
In the left pane of the Options window, expand IDE Configuration > Server and External Tool Settings > Derby Options.
Remove Database Location 4 Choose Tools > Derby Database > Create Derby Database 5
Check that dialog called "Set Database Location" is appeard - enter database location using browser or manually, click ok 6
Dialog called "Create Derby Database" should appear, check that text field with Database Location contains desired location.
