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
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Mail Systems
Eclipse Documentation

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




Eclipse BIRT Report Developer Guide
Previous Page Home Next Page

Previous Next

How to create a SQL query to retrieve data from a JDBC data source

This procedure assumes you have already created the JDBC data source that this data set uses.

Figure 3-1 Viewing a schema

Figure 3‑1
If you want to see only views in the JDBC data source, in Type, select View, and choose Apply Filter. If you want to see all tables, views, and stored procedures, select All, and choose Apply Filter.
If the data source has a large number of objects, you can limit the number of object names that are retrieved by typing one or more letters in the Filter field and choosing Apply Filter. Available Items displays the objects that have names that begin with the same letter or letters that you typed. You also can use SQL filter characters for the database that you are using. For example, on some databases, an underscore (_) matches any single character, and the percent sign (%) matches any sequence of characters.
If the database supports schemas, a Schema drop-down list is available. Select a schema to display only objects from that schema.
In the text area, type a SQL statement that indicates what data to retrieve from the JDBC data source. You can also drag tables, views, and columns from Available Items to the text area to insert their names in the SQL statement at the insertion point, as shown in Figure 3‑2.
For some databases, if a table or column name contains spaces or SQL reserved words, you must enclose the name in quotation marks (" "). If you drag and drop tables and columns, and those items need to be enclosed in double quotation marks, select the Use identifier quoting option. When this option is selected, the data set editor inserts the quotation marks around a table or column name when you drop it in the text area.

Figure 3-2 Adding a table to a SQL query


(c) Copyright Actuate Corporation 2009

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