Module litebridge.db.oracle

Package org.litebridgedb.db.oracle

Class OracleSequenceColumnValueGenerator

java.lang.Object

org.litebridgedb.db.spi.generator.SequenceColumnValueGenerator

org.litebridgedb.db.oracle.OracleSequenceColumnValueGenerator

All Implemented Interfaces:

ColumnValueGenerator

public final class OracleSequenceColumnValueGenerator
extends SequenceColumnValueGenerator

Implementation of SequenceColumnValueGenerator for Oracle databases.

This class generates SQL fragments to retrieve the next value from an Oracle sequence when used in SQL statements like INSERT or UPDATE.

Field Summary

Fields inherited from class org.litebridgedb.db.spi.generator.SequenceColumnValueGenerator

sequence

Constructor Summary

Constructors

Constructor	Description
OracleSequenceColumnValueGenerator(String sequence)

Method Summary

Modifier and Type	Method	Description
String	generate(ColumnMetaData columnMetaData)	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 (sequence_name.NEXTVAL, ?)"

Methods inherited from class java.lang.Object

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

Constructor Details

OracleSequenceColumnValueGenerator

public OracleSequenceColumnValueGenerator(String sequence)

Method Details

generate

public String generate(ColumnMetaData columnMetaData)

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 (sequence_name.NEXTVAL, ?)", this method returns "sequence_name.NEXTVAL".

Specified by:

generate in interface ColumnValueGenerator

Specified by:

generate in class SequenceColumnValueGenerator

Parameters:

columnMetaData - Column to generate a value for

Returns:

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