It is used to connect to a RDMS that has supplied
a JDBC driver. Most widely used enterprise RDMS already provide these, such as
Oracle, Microsoft SQL Server, MySQL, PostgreSQL as well as many others. Other
embedded database platforms, such as HSQL and Apache Derby, also provide JDBC
drivers for accessing data; in some cases, it may be the only way to access data stored
on those platforms.
One thing to note about JDBC drivers is that the JDBC connecting URL is different
for each platform. The JDBC URL for Oracle is not going to be the same as that for
MySQL or Derby. Check your documentation for your platform. Once you have a
basic template, you can set up a basic URL for future projects based on that platform,
when you manage your drivers.
So let's go through an example to get acquainted with the JDBC Data Source. In
the following example, we are going to work with the Classic Cars database that is
provided with BIRT. In the previous example using it, we used a built-in ODA Data
Source that was based on the JDBC driver. In this example, we will use the actual
JDBC driver for Derby.
1. Create or open the report EmployeeReportCH5.rptDesign.
2. Under the Data Explorer tab, right-click on Data Sources, and select New
Data Source. Under the list of available drivers, select JDBC Data Source,
and use the name dsSampleDataBase.
Pages:
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95