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 .


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
      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
      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"
      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
      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
      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.
      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
      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
      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)
      Table is created, is present under Tables node
  2. View data from table
    1. Invoke View data from popup on some populated table
      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
      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
      Changes can be committed, or rolled back
  5. Filtering data in data viewer
    1. type something into Matching rows textfield
      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
      Data can be viewed by pages.
  7. Delete row
    1. View data on your table
    2. Select some row
    3. Click Delete records
      Row is deleted.
  8. Truncate data
    1. View data on your table
    2. Click Truncate table
      All data are deleted.
Not logged in. Log in, Register

By use of this website, you agree to the NetBeans Policies and Terms of Use. © 2012, Oracle Corporation and/or its affiliates. Sponsored by Oracle logo