Module litebridge.db.oracle

Package org.litebridgedb.db.oracle

Class OracleDatabaseProvider

java.lang.Object

org.litebridgedb.db.spi.impl.AbstractDatabaseProvider

org.litebridgedb.db.oracle.OracleDatabaseProvider

All Implemented Interfaces:

DatabaseProvider

public 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.

Nested Class Summary

Nested classes/interfaces inherited from class org.litebridgedb.db.spi.impl.AbstractDatabaseProvider

AbstractDatabaseProvider.BindValue, AbstractDatabaseProvider.PreparedRow, AbstractDatabaseProvider.PreparedSql

Constructor Summary

Constructors

Constructor	Description
OracleDatabaseProvider()

Method Summary

Modifier and Type	Method	Description
protected void	appendLimitClause(Limit limit, StringBuilder sql)
protected String	createAlias(String alias)
protected String	createColumnIdentifier(Column column, boolean includeColumnAlias, @Nullable Select select)
protected String	createSequenceNextValueForDirectInsert(String sequence)	Generate a SQL fragment to retrieve the next value from a sequence for direct use in an INSERT or UPDATE statement, e.g. to generate "INSERT INTO LB.ACCOUNT(ACCOUNT_ID, ACCOUNT_NAME) VALUES (NEXT VALUE FOR sequence_name, ?)"
protected Map<ColumnMetaData,Object>	extractGeneratedKeys(TableMetaData tableMetaData, PreparedStatement preparedStatement)
protected org.slf4j.Logger	getLogger()	Return the logger instance for this database provider.

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

appendTable, appendTable, appendTable, createCondition, createJoin, createMathOperation, createPreparedStatementUsingConnection, delete, ensureColumnMetaData, executeSqlInsert, executeSqlUpdate, fetchTableMetaData, getColumnNames, getGeneratedPrimaryKeyColumns, getPrimaryKeyColumnNames, getTypeConverter, insert, mapOperator, prepareRow, prepareSql, prepareSql, prepareSql, prepareStatement, quoteIdentifier, select, tableMetaData, toSql, transformAlias, 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()

Method Details

createColumnIdentifier

protected String createColumnIdentifier(Column column,
 boolean includeColumnAlias,
 @Nullable Select select)

Overrides:

createColumnIdentifier in class AbstractDatabaseProvider

createSequenceNextValueForDirectInsert

protected String createSequenceNextValueForDirectInsert(String sequence)

Description copied from class: AbstractDatabaseProvider

Generate a SQL fragment to retrieve the next value from a sequence for direct use in an INSERT or UPDATE statement, e.g. to generate "INSERT INTO LB.ACCOUNT(ACCOUNT_ID, ACCOUNT_NAME) VALUES (NEXT VALUE FOR sequence_name, ?)", this method returns "NEXT VALUE FOR sequence_name".

Overrides:

createSequenceNextValueForDirectInsert in class AbstractDatabaseProvider

Parameters:

sequence - the name of the database sequence to generate the next value from

Returns:

a formatted SQL string representing the next sequence value for direct insertion

createAlias

protected String createAlias(String alias)

Overrides:

createAlias in class AbstractDatabaseProvider

appendLimitClause

protected void appendLimitClause(Limit limit,
 StringBuilder sql)

Overrides:

appendLimitClause in class AbstractDatabaseProvider

extractGeneratedKeys

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

Overrides:

extractGeneratedKeys in class AbstractDatabaseProvider

Throws:

SQLException

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