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.

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 chapter describes the following tasks related to JDBC connections:

Setting Up the JDBC Driver

Setting Up a JDBC Connection

Setting Up OOJDBC Connections

DBMS Objects in a JDBC Connection

Previous Page Next Page