gudusoft.gsqlparser

Enum EOBTenantMode

Object

Enum<EOBTenantMode>

gudusoft.gsqlparser.EOBTenantMode

All Implemented Interfaces:

Serializable, Comparable<EOBTenantMode>

public enum EOBTenantMode
extends Enum<EOBTenantMode>

OceanBase tenant compatibility mode.

OceanBase is a multi-tenant database whose SQL surface depends on the tenant kind. Each TGSqlParser instance configured for EDbVendor.dbvoceanbase carries one of these modes:

• MYSQL — User tenant in MySQL compatibility mode. SQL surface is MySQL 5.7 / 8.0 plus OceanBase extensions. Uses backtick-quoted identifiers and ; as the statement terminator.
• ORACLE — User tenant in Oracle compatibility mode. SQL surface is Oracle SQL plus PL/SQL plus OceanBase extensions. Uses double-quoted identifiers, / as the PL/SQL block delimiter, and supports packages, anonymous blocks, and PL/SQL routines.
• SYSTEM — System (sys) tenant. Lexically MySQL-family (backticks, ;, no PL/SQL) but additionally accepts OceanBase administrative DDL such as CREATE TENANT, ALTER SYSTEM, CREATE RESOURCE POOL, CREATE RESOURCE UNIT, and zone/server management commands.

Tenant mode is permanent for the life of an OceanBase tenant on the server side; this enum mirrors that immutability at the parser level. One mode per TGSqlParser instance — do not switch modes mid-script.

Set the mode via TGSqlParser.setOBTenantMode(EOBTenantMode). The default for a freshly constructed parser configured for dbvoceanbase is MYSQL.

Since:

4.0.1.4

Enum Constant Summary

Enum Constants

Enum Constant and Description
MYSQL User tenant — MySQL compatibility mode (default).
ORACLE User tenant — Oracle compatibility mode (full PL/SQL).
SYSTEM System (sys) tenant — MySQL syntax + OceanBase administrative DDL.

Method Summary

Modifier and Type	Method and Description
static EOBTenantMode	valueOf(String name) Returns the enum constant of this type with the specified name.
static EOBTenantMode[]	values() Returns an array containing the constants of this enum type, in the order they are declared.

Methods inherited from class Enum

clone, compareTo, equals, finalize, getDeclaringClass, hashCode, name, ordinal, toString, valueOf

Methods inherited from class Object

getClass, notify, notifyAll, wait, wait, wait

Enum Constant Detail

MYSQL

public static final EOBTenantMode MYSQL

User tenant — MySQL compatibility mode (default).

ORACLE

public static final EOBTenantMode ORACLE

User tenant — Oracle compatibility mode (full PL/SQL).

SYSTEM

public static final EOBTenantMode SYSTEM

System (sys) tenant — MySQL syntax + OceanBase administrative DDL.

Method Detail

values

public static EOBTenantMode[] values()

Returns an array containing the constants of this enum type, in the order they are declared. This method may be used to iterate over the constants as follows:

for (EOBTenantMode c : EOBTenantMode.values())
    System.out.println(c);

Returns:

an array containing the constants of this enum type, in the order they are declared

valueOf

public static EOBTenantMode valueOf(String name)

Returns the enum constant of this type with the specified name. The string must match exactly an identifier used to declare an enum constant in this type. (Extraneous whitespace characters are not permitted.)

Parameters:

name - the name of the enum constant to be returned.

Returns:

the enum constant with the specified name

Throws:

IllegalArgumentException - if this enum type has no constant with the specified name

NullPointerException - if the argument is null