Difference between revisions of "DTP Smoke Test"

From Eclipsepedia

Jump to: navigation, search
(New page: {{Back To|name=DTP Main Page|href=Data Tools Platform Project}} ==About== * This Smoke test is just a simple way to make sure that the basic parts of your DTP installation are working cor...)
 
(Before starting Eclipse)
 
Line 6: Line 6:
 
===Before starting Eclipse===
 
===Before starting Eclipse===
 
* Download the latest Apache Derby core plug-in (do a Google search for "Derby 10 Core Plug-in for Eclipse" and you will probably find it)
 
* Download the latest Apache Derby core plug-in (do a Google search for "Derby 10 Core Plug-in for Eclipse" and you will probably find it)
 +
* --OR--
 +
* Download the Apache Derby 10.1.2 plug-in from Orbit (this links to the current recommended build - http://download.eclipse.org/tools/orbit/downloads/drops/R200709171314/bundles/org.apache.derby_10.1.2.1_v200706111724.jar)
 
* Copy the plug-in into your Eclipse/plugins directory.
 
* Copy the plug-in into your Eclipse/plugins directory.
  

Latest revision as of 10:22, 22 May 2008

Back to DTP Main Page


[edit] About

  • This Smoke test is just a simple way to make sure that the basic parts of your DTP installation are working correctly.

[edit] Before starting Eclipse

[edit] DTP Smoke Test

  • Is the Database Development perspective available?
  • Open the Database Development perspective
  • Create a new Derby connection profile
  • Connect to the Derby profile
  • Expand into the profile to verify you can see tables, stored procedures, etc.
  • Find the SYSIBM schema, expand the Stored Procedures node, right-click on a stored procedure and select "Run"
  • The stored procedure should open in an editor window
  • If the Configure Parameters dialog appears, change the default values as necessary and click OK
  • The stored procedure executes, and the output displays in the SQL Results view
  • Open the Resource perspective
  • Create a new "General" project
  • Create a new SQL file (select your Derby connection profile in the drop-down list)
  • In the new SQL file type w/o the quotes: "select * from SYS.SYSTABLES"
  • Right-click in the SQL editor and select "Execute All"
  • The sql statement executes, and the output displays in the SQL Results view