OracleDb class

Main entry point for Oracle database operations

Singleton class that manages Oracle client initialization, connection pools, and provides factory methods for creating connections.

Constructors

OracleDb()
factory

Properties

autoCommit ↔ bool
getter/setter pair
connectionClass ↔ String?
getter/setter pair
hashCode → int
The hash code for this object.
no setterinherited
isInitialized → bool
no setter
oracleClientVersion → String
no setter
oracleClientVersionString → String
no setter
poolCount → int
no setter
poolIncrement ↔ int
getter/setter pair
poolMax ↔ int
getter/setter pair
poolMin ↔ int
getter/setter pair
poolNames → List<String>
no setter
poolPingInterval ↔ int
getter/setter pair
poolTimeout ↔ int
getter/setter pair
queueMax ↔ int
getter/setter pair
queueTimeout ↔ int
getter/setter pair
runtimeType → Type
A representation of the runtime type of the object.
no setterinherited
stmtCacheSize ↔ int
getter/setter pair
versionString → String?
no setter
versionSuffix → String?
no setter

Methods

closeAllPools() → Future<void>
Close all connection pools
closePool(String poolName) → Future<void>
Close a specific pool
createConnection({required OracleConfig config}) → Future<OracleConnection>
Create a standalone connection (not from a pool)
createPool({required OracleConfig config, String poolName = 'default', PoolConfig? poolConfig}) → Future<OracleConnectionPool>
Create a connection pool
getConnection({String poolName = 'default', OracleConfig? config}) → Future<OracleConnection>
Get a connection from a pool
getPool({String poolName = 'default'}) → OracleConnectionPool?
Get an existing connection pool by name
initOracleClient({String? libraryPath}) → Future<void>
Initialize the Oracle client library
noSuchMethod(Invocation invocation) → dynamic
Invoked when a nonexistent method or property is accessed.
inherited
shutdown() → Future<void>
Shutdown the Oracle client
toString() → String
A string representation of this object.
inherited

Operators

operator ==(Object other) → bool
The equality operator.
inherited

Constants

AQ_DEQ_MODE_BROWSE → const int
AQ_DEQ_MODE_LOCKED → const int
AQ_DEQ_MODE_REMOVE → const int
AQ_DEQ_MODE_REMOVE_NO_DATA → const int
AQ_DEQ_NAV_FIRST_MSG → const int
AQ_DEQ_NAV_NEXT_MSG → const int
AQ_DEQ_NAV_NEXT_TRANSACTION → const int
AQ_DEQ_NO_WAIT → const int
AQ_MSG_DELIV_MODE_BUFFERED → const int
AQ_MSG_DELIV_MODE_PERSISTENT → const int
AQ_MSG_DELIV_MODE_PERSISTENT_OR_BUFFERED → const int
AQ_MSG_STATE_EXPIRED → const int
AQ_MSG_STATE_PROCESSED → const int
AQ_MSG_STATE_READY → const int
AQ_MSG_STATE_WAITING → const int
AQ_VISIBILITY_IMMEDIATE → const int
AQ_VISIBILITY_ON_COMMIT → const int
CQN_OPCODE_ALL_OPS → const int
CQN_OPCODE_ALL_ROWS → const int
CQN_OPCODE_ALTER → const int
CQN_OPCODE_DELETE → const int
CQN_OPCODE_DROP → const int
CQN_OPCODE_INSERT → const int
CQN_OPCODE_UPDATE → const int
DB_TYPE_BFILE → const int
DB_TYPE_BINARY_DOUBLE → const int
DB_TYPE_BINARY_FLOAT → const int
DB_TYPE_BINARY_INTEGER → const int
DB_TYPE_BLOB → const int
DB_TYPE_BOOLEAN → const int
DB_TYPE_CHAR → const int
DB_TYPE_CLOB → const int
DB_TYPE_CURSOR → const int
DB_TYPE_DATE → const int
DB_TYPE_INTERVAL_DS → const int
DB_TYPE_INTERVAL_YM → const int
DB_TYPE_JSON → const int
DB_TYPE_LONG → const int
DB_TYPE_LONG_RAW → const int
DB_TYPE_NCHAR → const int
DB_TYPE_NCLOB → const int
DB_TYPE_NUMBER → const int
DB_TYPE_NVARCHAR → const int
DB_TYPE_OBJECT → const int
DB_TYPE_RAW → const int
DB_TYPE_ROWID → const int
DB_TYPE_TIMESTAMP → const int
DB_TYPE_TIMESTAMP_LTZ → const int
DB_TYPE_TIMESTAMP_TZ → const int
DB_TYPE_VARCHAR → const int
STMT_TYPE_ALTER → const int
STMT_TYPE_BEGIN → const int
STMT_TYPE_CALL → const int
STMT_TYPE_COMMIT → const int
STMT_TYPE_CREATE → const int
STMT_TYPE_DECLARE → const int
STMT_TYPE_DELETE → const int
STMT_TYPE_DROP → const int
STMT_TYPE_EXPLAIN_PLAN → const int
STMT_TYPE_INSERT → const int
STMT_TYPE_MERGE → const int
STMT_TYPE_ROLLBACK → const int
STMT_TYPE_SELECT → const int
STMT_TYPE_UNKNOWN → const int
STMT_TYPE_UPDATE → const int
SUBSCR_EVENT_TYPE_AQ → const int
SUBSCR_EVENT_TYPE_DEREG → const int
SUBSCR_EVENT_TYPE_OBJ_CHANGE → const int
SUBSCR_EVENT_TYPE_QUERY_CHANGE → const int
SUBSCR_EVENT_TYPE_SHUTDOWN → const int
SUBSCR_EVENT_TYPE_SHUTDOWN_ANY → const int
SUBSCR_EVENT_TYPE_STARTUP → const int
SUBSCR_GROUPING_CLASS_TIME → const int
SUBSCR_GROUPING_TYPE_LAST → const int
SUBSCR_GROUPING_TYPE_SUMMARY → const int
SUBSCR_NAMESPACE_AQ → const int
SUBSCR_NAMESPACE_DBCHANGE → const int
SUBSCR_QOS_BEST_EFFORT → const int
SUBSCR_QOS_DEREG_NFY → const int
SUBSCR_QOS_QUERY → const int
SUBSCR_QOS_RELIABLE → const int
SUBSCR_QOS_ROWIDS → const int
SYSASM → const int
SYSBACKUP → const int
SYSDBA → const int
SYSDG → const int
SYSKM → const int
SYSOPER → const int
SYSPRELIM → const int
SYSRAC → const int
TPC_BEGIN_JOIN → const int
TPC_BEGIN_NEW → const int
TPC_BEGIN_PROMOTE → const int
TPC_BEGIN_RESUME → const int
TPC_END_NORMAL → const int
TPC_END_SUSPEND → const int