2. Here is where you can set the various properties for the JDBC drivers, such
as the driver name and the default JDBC URL. Click on the Derby Embedded
driver, and then click on the Edit button. You can see that the default JDBC
URL is already filled in. Anytime after you have registered a new driver, you
can always come here to change the default JDBC URL and driver name.
3. Click on OK to exit the Edit Dialog. Now, click on OK to exit the Manage
JDBC Drivers Dialog. Finally, click on Finish.
Working with Data
[ 80 ]
Data Sets
With the preceding examples completed, you should have four Data Sources in
your report. The reason we kept each of these Data Sources is to demonstrate the
differences in each when setting up Data Sets. As mentioned before, Data Sets are
basically descriptions of the data you want to retrieve. Each type of Data Source is
going to contain different Data Set types. In the following examples, we are going
to create five different Data Sets, of which four are going to be based on each of
the different Data Sources we have created, and one will be a Joined Data Set or
combination of two of the existing Data Sets.
First we are going to build a simple Data Set from the XML Data Source,
dsXMLEmployee. Building the XML Data Set consists of defining columns to be
built, and then resolving them to XML paths using XPath expressions.
Pages:
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98