Follow Techotopia on Twitter

On-line Guides
All Guides
eBook Store
iOS / Android
Linux for Beginners
Office Productivity
Linux Installation
Linux Security
Linux Utilities
Linux Virtualization
Linux Kernel
System/Network Admin
Programming
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Databases
Mail Systems
openSolaris
Eclipse Documentation
Techotopia.com
Virtuatopia.com

How To Guides
Virtualization
General System Admin
Linux Security
Linux Filesystems
Web Servers
Graphics & Desktop
PC Hardware
Windows
Problem Solutions
Privacy Policy

  




 

 

Eclipse Data Tools Platform Guide
Previous Page Home Next Page


Creating and Executing a SQL Query

Create a SQL file and run it against a given database instance.

  1. Create a Java project.
    1. Select File > New > Project from the main menu bar.
    2. Select Java Project and click Next.
    3. Enter a Project Name and click Finish.
  2. Create a SQL file and associate it with a Derby connection profile.
    1. Select File > New > SQL File from the main menu bar.
    2. In the Enter or Select Parent Folder box, select the Java project you just created.
    3. Enter the File Name.
    4. Associate this SQL file with the Apache Derby connection profile by indicating the Database Server Type, Connection Profile Name, and Database Name.
  3. Click Finish.
  4. In SQL File Editor, enter the following SQL statement:

    select * from SYS.SYSTABLES

  5. Right-click in the editor and select Execute All.

    The query results appear in the SQL Results view. The left pane displays the execution history. For each statement, including stored procedures, that you run, you can create an Eclipse launch configuration. This allows you to quickly retest the execution using slightly different values and settings. You can rename or delete launch configurations as needed.


 
 
  Published under the terms of the Eclipse Public License Version 1.0 ("EPL") Design by Interspire