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 Logi Report catalog, you can retrieve data from the relational databases for your reports.
Logi Report Designer also provides connection plug-ins for the most commonly used relational databases: Oracle, MySQL, MS SQL Server and PostgreSQL, for an easy connection setup procedure.
Select the following links to view the topics:
- Setting Up JDBC Connections in a Catalog
- JDBC Connection Plug-ins
- DBMS Objects in JDBC Connections
- Using Data Sources via OOJDBC
- In Logi Report Designer, not all the data types supported by JDBC can be used. The data types that are supported in Logi Report 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.