Module litebridge.db.oracle

Package org.litebridge.db.oracle

Class OracleDatabaseProvider

java.lang.Object

org.litebridge.db.spi.impl.AbstractDatabaseProvider

org.litebridge.db.oracle.OracleDatabaseProvider

All Implemented Interfaces:

DatabaseProvider

public final class OracleDatabaseProvider
extends AbstractDatabaseProvider

Oracle Database Provider for Litebridge.

OracleDatabaseProvider is a concrete implementation of AbstractDatabaseProvider designed to facilitate interactions with an Oracle database.

It uses a DefaultTypeConverter for handling type conversions between database values and Java data types.

Field Summary

Fields inherited from class org.litebridge.db.spi.impl.AbstractDatabaseProvider

columnIdentifierGenerator, deleteSqlGenerator, insertSqlGenerator, selectSqlGenerator, typeConverter, updateSqlGenerator

Constructor Summary

Constructors

Constructor	Description
OracleDatabaseProvider()	Constructs a new OracleDatabaseProvider using a default type converter.

Method Summary

Modifier and Type	Method	Description
protected ColumnIdentifierGenerator	createColumnIdentifierGenerator()	Create a ColumnIdentifierGenerator instance for the database provider.
protected SelectSqlGenerator	createSelectSqlGenerator()	Create a SelectSqlGenerator instance for the database provider.
protected SqlFunctionRegistryFactory	createSqlFunctionRegistryFactory()	Create a SqlFunctionRegistryFactory instance for the generation of a SQL function registry.
protected Map<ColumnMetaData,Object>	extractGeneratedKeys(TableMetaData tableMetaData, PreparedStatement preparedStatement)	Extract the generated primary key values from the provided prepared statement.
protected org.slf4j.Logger	getLogger()	Return the logger instance for this database provider.
SequenceColumnValueGenerator	getSequenceColumnValueGenerator(String sequence)	Retrieves a SequenceColumnValueGenerator instance for generating SQL fragments that fetch the next value from a specified database sequence.

Methods inherited from class org.litebridge.db.spi.impl.AbstractDatabaseProvider

createAliasTransformer, createDeleteSqlGenerator, createInsertSqlGenerator, createPreparedStatementUsingConnection, createUpdateSqlGenerator, delete, ensureTableMetaData, executeSqlInsert, executeSqlUpdate, fetchTableMetaData, getAliasTransformer, getColumnMetaData, getGeneratedPrimaryKeyColumns, getPrimaryKeyColumnNames, getSqlFunctionRegistry, getTypeConverter, insert, nativeSqlQuery, nativeSqlUpdate, prepareNativeStatement, prepareStatement, select, tableMetaData, toSql, update, verifySchemaAndTableExists

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

OracleDatabaseProvider

public OracleDatabaseProvider()

Constructs a new OracleDatabaseProvider using a default type converter.

Method Details

getSequenceColumnValueGenerator

public SequenceColumnValueGenerator getSequenceColumnValueGenerator(String sequence)
                                                             throws UnsupportedOperationException

Description copied from interface: DatabaseProvider

Retrieves a SequenceColumnValueGenerator instance for generating SQL fragments that fetch the next value from a specified database sequence. This is typically used in SQL statements such as INSERT or UPDATE to generate unique values from a sequence.

Specified by:

getSequenceColumnValueGenerator in interface DatabaseProvider

Overrides:

getSequenceColumnValueGenerator in class AbstractDatabaseProvider

Parameters:

sequence - the name of the database sequence from which the values will be generated. It is used to create the SQL fragment to retrieve the next value in the sequence.

Returns:

a SequenceColumnValueGenerator instance that generates SQL fragments for retrieving sequence values.

Throws:

UnsupportedOperationException - if the database provider does not support sequence-based value generation.

createColumnIdentifierGenerator

protected ColumnIdentifierGenerator createColumnIdentifierGenerator()

Description copied from class: AbstractDatabaseProvider

Create a ColumnIdentifierGenerator instance for the database provider.

Overrides:

createColumnIdentifierGenerator in class AbstractDatabaseProvider

Returns:

a ColumnIdentifierGenerator instance

createSqlFunctionRegistryFactory

protected SqlFunctionRegistryFactory createSqlFunctionRegistryFactory()

Description copied from class: AbstractDatabaseProvider

Create a SqlFunctionRegistryFactory instance for the generation of a SQL function registry.

This method may be overridden to provide a custom SqlFunctionRegistryFactory instance, allowing overriding/disabling of specific SQL functions.

Overrides:

createSqlFunctionRegistryFactory in class AbstractDatabaseProvider

Returns:

a SqlFunctionRegistryFactory implementation instance

createSelectSqlGenerator

protected SelectSqlGenerator createSelectSqlGenerator()

Description copied from class: AbstractDatabaseProvider

Create a SelectSqlGenerator instance for the database provider.

Overrides:

createSelectSqlGenerator in class AbstractDatabaseProvider

Returns:

a SelectSqlGenerator instance

extractGeneratedKeys

protected Map<ColumnMetaData,Object> extractGeneratedKeys(TableMetaData tableMetaData,
 PreparedStatement preparedStatement)
                                                   throws SQLException

Description copied from class: AbstractDatabaseProvider

Extract the generated primary key values from the provided prepared statement.

Overrides:

extractGeneratedKeys in class AbstractDatabaseProvider

Parameters:

tableMetaData - the TableMetaData object containing the metadata of the target table

preparedStatement - the executed PreparedStatement containing any generated keys

Returns:

a map of ColumnMetaData to the generated key value

Throws:

SQLException - if an error occurs while retrieving the generated keys

getLogger

protected org.slf4j.Logger getLogger()

Description copied from class: AbstractDatabaseProvider

Return the logger instance for this database provider.

Overrides:

getLogger in class AbstractDatabaseProvider

Returns:

the logger instance