TS 70 DB Sanity

Test Specification: Database support Specification

Author: Tomas Musil
Version: 1.0
Introduction: Covering basic scenarios for NetBeans database support. These can be tested against whatever database you connect.
Setup: Install IDE along with Glassfish server, this ensures that you have Java DB available .

Contents 1 Test Specification: Database support Specification 1.1 Test suite: DB basic operations 1.2 Test suite: MySQL server 1.3 Test suite: Oracle DB server, remote connection 1.4 Test suite: Table/Data manipulation

Test suite: DB basic operations

Purpose: Test basic DB operations with Java DB
Setup: Start IDE with fresh userdir.

1. Check Java DB is present
   1. Open Windows | Services
   • EXPECTED RESULT:
     Under Databases, Java DB node is present, contains Sample DB as child node.
2. Connect to Java DB Sample DB
   1. Expand Java DB node, select Sample DB node
   2. Invoke "Connect" from popup
   • EXPECTED RESULT:
     IDE should create new connection, its node appeared under Databases node.
3. Rename connection
   1. Select node representing connection to Sample DB
   2. Invoke "Rename" from popup
   3. Rename connection to something meaningful, e.g. "sample"
   • EXPECTED RESULT:
     Connection can be renamed.
4. Disconnect/Connect connection
   1. From popup on "sample" connection, invoke "disconnect" - icon changes, connection is stopped
   2. From popup on "sample" connection, invoke "connect" - icon changes, connection is stared
   • EXPECTED RESULT:
     When connection is active, its node can be expanded, contains schemas in DB.

Test suite: MySQL server

Purpose: Test basic DB operations with MySQL server. IDE should autodetect if you have standard MySQL installation.
Setup: Start IDE with fresh userdir, ensure you have MySQL server installed and running.

1. Check MySQL DB is present
   1. Open Windows | Services
   • EXPECTED RESULT:
     Under Databases, MySQL is present.
2. MySQL properties
   1. Invoke popup on MySQL node
   2. Open properties dialog
   3. Check properties, if everything was recognized by IDE, fill in password if necessary, close dialog.
   • EXPECTED RESULT:
     Settings are now correct, connection succeeds. Databases nodes can be displayed if you expand MySQL node.

Test suite: Oracle DB server, remote connection

Purpose: Test creating new connection to Oracle DB server.
Setup: Start IDE with fresh userdir. Have prepared credentials for connecting to some remote Oracle DB

1. Creating connection
   1. Open Windows | Services
   2. Expand Drivers node, select Oracle Thin
   3. Invoke Connect using from popup
   4. Notice missing driver file, follow instructions, download driver and add it. After that, you should be able to proceed.
   5. Fill in connection details on following panel. Test connection by button. Proceed to next panel
   6. Confirm default schema
   • EXPECTED RESULT:
     Connection can be established, can be connected/disconnected, renamed. Under connection node are schemas displayed, under schema you are able to list databases, views and procedures
2. View/Edit stored procedures
   1. Connect to Oracle DB
   2. Expand HR schema (or any other test schema in your DB), Procedures node
   3. Invoke View/Edit on some procedure, function and trigger node
   • EXPECTED RESULT:
     Code can be properly viewed in separate window. In case od editing, sql editor is opened, and changes after running code are reflected.

Test suite: Table/Data manipulation

Purpose: Test manipulation with data on table level
Setup: Start IDE with fresh userdir. Have some DB connection, e.g. to Java DB

1. Creating new table
   1. Connect to DB
   2. Invoke Create table from popup on Tables node
   3. Type table name, fill in two or three columns (use various data types)
   • EXPECTED RESULT:
     Table is created, is present under Tables node
2. View data from table
   1. Invoke View data from popup on some populated table
   • EXPECTED RESULT:
     Data are shown in editor area.
3. Add table row
   1. Invoke View data on table you've created
   2. Click on Insert Record in data viewer
   3. fill in data for first row
   4. Invoke Add row, fill in datador second row, confirm
   • EXPECTED RESULT:
     Data are added to table
4. In-place editing of data
   1. in data viewer, choose some cell and edit value
   2. Cell value is marked green, two buttons are enabled - Commit record x Cancel edit
   3. Check that both buttons work correctly
   • EXPECTED RESULT:
     Changes can be committed, or rolled back
5. Filtering data in data viewer
   1. type something into Matching rows textfield
   • EXPECTED RESULT:
     Data are filtred and only those rows where is match with textfield value are shown.
6. Paging in data viewer
   1. View data on some table with lot of records
   2. Try page navigation - first, last, next previous
   3. Check that also Page size is reflected
   • EXPECTED RESULT:
     Data can be viewed by pages.
7. Delete row
   1. View data on your table
   2. Select some row
   3. Click Delete records
   • EXPECTED RESULT:
     Row is deleted.
8. Truncate data
   1. View data on your table
   2. Click Truncate table
   • EXPECTED RESULT:
     All data are deleted.

• This page was last modified on 19 April 2011, at 12:28.
• This page has been accessed 5,143 times.