Class SequenceColumnValueGenerator

java.lang.Object
org.litebridge.db.spi.generator.SequenceColumnValueGenerator
All Implemented Interfaces:
ColumnValueGenerator
Direct Known Subclasses:
DefaultSequenceColumnValueGenerator

public abstract class SequenceColumnValueGenerator extends Object implements ColumnValueGenerator
Abstract base class for generating SQL fragments to retrieve the next value from a database sequence to be used in SQL statements such as INSERT or UPDATE.
  • Field Details

    • sequenceNextValSqlFragment

      protected final String sequenceNextValSqlFragment
  • Constructor Details

    • SequenceColumnValueGenerator

      public SequenceColumnValueGenerator(String sequenceNextValSqlFragment)
      Constructs a new instance of SequenceColumnValueGenerator.
      Parameters:
      sequenceNextValSqlFragment - the SQL fragment for retrieving the next value in the sequence.
  • Method Details

    • generate

      public String generate()
      Generate a SQL fragment to retrieve the next value from a sequence.

      This fragment is meant for direct use in an INSERT or UPDATE statement. For example, to generate INSERT INTO LB.ACCOUNT(ACCOUNT_ID, ACCOUNT_NAME) VALUES (NEXT VALUE FOR sequence_name, ?), this method would return the NEXT VALUE FOR sequence_name SQL fragment.

      Specified by:
      generate in interface ColumnValueGenerator
      Returns:
      a formatted SQL string representing the next sequence value for direct insertion