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. All RDBMS software companies provide their own JDBC Driver and unique driver class and URL to access their database. Usually you can download these for free from the database vendors web site. Logi JReport only includes a JDBC drivers for the HSQLDB and Derby databases.
- In Logi JReport Designer, not all the data types supported by JDBC can be used. The data types that are supported in Logi 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.
The following topics describe tasks related to JDBC connections: