To create a JDBC query manually:
In Reports Builder, display the Data Model view.
In the Data Model view, single-click
in the tool palette.
Click in the main area (canvas region) of the window.
In the JDBC Query dialog box, define the JDBC query or procedure and the connection parameters for the data source. Click Help for assistance.
Click Connect to display the Connect dialog box.
In the Connect dialog box, enter your user name, password and database name, choose the Driver Type you want to use, then click Connect.
In the JDBC Query dialog box, click OK to close the dialog box and
display your new JDBC query in
the Data Model view.
Copyright © 1984, 2005, Oracle. All rights reserved.