This topic describes how to connect to and access OceanBase Database in Oracle mode, including OceanBase Client (OBClient), OceanBase Developer Center (ODC), and OceanBase Driver.
OceanBase Client (OBClient)
OBClient is an interactive query tool that supports batch processing. It must be installed separately. OBClient provides a command-line interface and, when it is connected to a database, functions as the client. It supports Oracle and MySQL tenants in OceanBase Database.
Before OBClient runs, you must specify the connection information of an OceanBase tenant. After it connects to OceanBase Database, you can use OBClient to run some database commands (including general MySQL commands) and execute some SQL and PL/SQL statements to accomplish the following tasks:
Calculate, store, and print query results
Create database objects, check and modify object definitions
Develop and run batch processing scripts
Manage the database and modify parameters
OceanBase Developer Center (ODC)
OceanBase Developer Center (ODC) is an enterprise-level database development platform tailored for OceanBase Database.
ODC supports the connection of both MySQL and Oracle tenants in OceanBase Database. It provides database developers with various features, including daily development, WebSQL-based workspace, SQL diagnostics, session management, and data import and export.
OceanBase Driver
OceanBase Driver allows applications to connect to OceanBase Database, so that you can use other languages (such as Java) or environments to connect to and execute SQL statements in OceanBase Database.
OceanBase Connector/J is a driver that allows Java applications to connect to an OBServer node. The name of the installation package of OceanBase Connector/J is:
oceanbase-client-[version].jar.Oracle Connector for Java (OCI) is a C-language driver compatible with the Oracle OCI interface. Users and applications developed based on Oracle OCI can be smoothly migrated to the Oracle mode of OceanBase Database by using Oracle Connector for Java.
OCI provides standard database access features through dynamic-linked libraries (OBCI libraries). Applications linked with the OBCI libraries during runtime can use these features.