JDBC Connections

JDBC is a Java API for executing SQL statements. It consists of a set of classes and interfaces written in the Java programming language which enables SQL statements to be executed against virtually any relational database as well as other types of data that also support JDBC. By setting up JDBC connections in a JReport catalog, you can retrieve data from the relational databases for your reports.

JReport Designer also provides connection plugins for the most commonly used relational databases: Oracle, MySQL and MS SQL Server, for an easy connection setup procedure.

Notes:

In JReport Designer, not all the data types supported by JDBC can be used. The data types that are supported in JReport Designer are: Bit, Tinyint, Smallint, Integer, Bigint, Float, Real, Double, Numeric, Decimal, Char, VarChar, LongVarChar, Date, Time, TimeStamp, Binary, LongVarBinary, Blob, Clob, Array, and nVarChar.
For the Blob, Clob, and Array types, you cannot browse their data in the Catalog Manager; however, the Blob data type can be used to display images.

This section contains the following topics:

Previous Page Next Page