Table of Contents

Class OracleDelegate

Namespace
Quartz.Impl.AdoJobStore
Assembly
Quartz.dll

This is a driver delegate for the Oracle database.

public class OracleDelegate : StdAdoDelegate, IDriverDelegate, IDbAccessor
Inheritance
OracleDelegate
Implements
Inherited Members

Properties

SchemaResourceName

The embedded script that creates this dialect's schema, or null when this delegate has none.

protected override string? SchemaResourceName { get; }

Property Value

string

Remarks

Null on StdAdoDelegate itself, because there is no dialect-neutral DDL: the six shipped delegates each name their own script, and a delegate written outside Quartz names one or leaves provisioning unavailable. Overriding it is the whole of what a delegate has to do to support CreateIfMissing.

The name is a manifest resource name, looked for in the assembly of the delegate's own type and then in each assembly up its base chain. So a delegate of somebody else's can embed a script of its own beside itself, and one that subclasses a shipped dialect delegate to change a statement or two inherits that dialect's script rather than having to carry a copy.

Methods

GetBooleanFromDbValue(object)

Gets the boolean value from db presentation. Subclasses can overwrite this behaviour.

public override bool GetBooleanFromDbValue(object columnValue)

Parameters

columnValue object

Value to map from database.

Returns

bool

GetDbBooleanValue(bool)

Gets the db presentation for boolean value. For Oracle we use true/false of "1"/"0".

public override object GetDbBooleanValue(bool booleanValue)

Parameters

booleanValue bool

Value to map to database.

Returns

object

GetRowLimit(int)

Oracle limits rows from an enclosing select: SELECT * FROM (…) WHERE rownum <= n.

protected override SqlRowLimit GetRowLimit(int count)

Parameters

count int

Returns

SqlRowLimit
Edit this page