JDBC can be used
to provide connection to many of the popular Relational Database Management
systems out on the market??”such as Oracle, MySQL, Microsoft SQL Server, and
PostgreSQL.
In addition to the classic client/server-based reporting capabilities afforded to BIRT
through this mechanism, BIRT also offers some extensible data handling capabilities
through a number of different mechanisms. The Eclipse Data Tools Project is being
leveraged by BIRT for its XML Data Source handling. The Eclipse Open Data
Access allows developers to build custom drivers for data connections that JDBC
doesn't actually provide connectors for. The Classic Cars sample database was built
using ODA. For the Java-centric developers who are looking for more flexibility,
or with specific needs in mind: BIRT's extensible event handling model allows Java
programmers to write scripted Data Sources, where the data is populated either
through Java code or JavaScript code at run time.
Most of these are topics that are beyond the scope of this book. In this chapter,
we are going to focus primarily on using the Classic Cars example database, and
configuring BIRT to use a JDBC database connection to MySQL. This will give
the reader some familiarity with the basics of how to establish a connection to a
database, using JDBC drivers.
Pages:
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87