Introduction to Tibero JDBC
This chapter explains what JDBC is, and introduces Tibero JDBC (hereafter tbJDBC) provided by Tibero.
JDBC
JDBC (Java Database Connectivity) is an API (Application Programming Interface) that allows Java programs to access a database to execute SQL statements.
JDBC provides the following advantages.
Use SQL statements in any relational database.
You don't need to create a vendor-specific program to connect to a specific DBMS.
A Java-written program provides universal access to platforms.
Applications written in Java operate in all environments.
Java functionality is scalable.
With JDBC you can use information obtained from a remote database to create an applet, or connect to one or more internal databases. JDBC also allows you to access information stored in a different storage, and reduces the amount of time to develop a new application.
tbJDBC
Tibero follows JDBC standards, which will be described in the following chapter, and provides an additional API. This API is referred to as tbJDBC(Java Database Connectivity of Tibero).
To describe the main characteristics, tbJDBC:
Consists of classes and interface methods.
Supports the SQL standard, SQL-99.
Can develop programs independently of the DBMS type.
Inherits Java packages such as java.sql.* and javax.sql.*.
The version of the JDBC depends on the specification of the Java standard.
– JDBC 3.0 (J2SE 1.4) – JDBC 4.0 (Java SE 6)
JDBC Architecture
Using JDBC standards, application developers can create and distribute JDBC drivers.
JDBC provides the following 4 types of drivers.
JDBC-ODBC Bridge Driver
Uses ODBC (Open Database Connectivity) without directly connecting to the database through JDBC.
Native-API Driver
Converts a JDBC command to a compatible command for a DBMS's own client program.
Net-Protocol Driver
Converts JDBC to a platform-independent protocol (for WAS), and then connects to WAS.
Native-Protocol Driver
Converts a JDBC statement to the DBMS's own protocol. Supported by DBMS vendor.
tbJDBC provides the JDBC driver to develop Java applications without installing a database server. The driver is the Native-Protocol Driver (or Thin Driver) type that is introduced in the previous table.
tbJDBC operates as follows:
[Figure 1] tbJDBC architecture
Default Path
After installing Tibero on the server, tbJDBC is created in the $TB_HOME/client/lib/jar directory. Its file name varies depending on the JDK version.
1.4 or higher
tibero7-jdbc-14.jar: tbJDBC file
tibero7-jdbc-14-dbg.jar: tbJDBC debugging file
6 or higher
tibero7-jdbc.jar: tbJDBC file
tibero7-jdbc-dbg.jar: tbJDBC debugging file
Restrictions
tbJDBC has the following restrictions:
When installing a database server, use the automatically created tbJDBC.
No backward compatibility is provided.
JDK 1.4 or a higher version must be installed.
If the system does not use Oracle's JDK, install another JDK that is compatible with the system. For example, for HP-UX, download JDK from HP, and for AIX, download JDK from IBM.
Last updated