← Back to plugin index

Database Sequence Generator
Description

Sequence generator storing the sequence number in a database.

Type name
DatabaseSequenceGenerator
Class
com.airlock.iam.core.misc.util.report.barcode.DatabaseSequenceGenerator
May be used by
Swiss Post Barcode Generator
Properties
Sql Data Source (sqlDataSource)
Description
Defines how connections to the database are obtained.
Attributes
Plugin-Link
Mandatory
Assignable plugins
JDBC Connection Pool
Sequence Name (sequenceName)
Description
The name of the sequence. It must be a unique value in the column specified by property "Column Sequence Name".
Attributes
String
Mandatory
Example
Sendungsnummer01
Example
SEQ-A
Table Name (tableName)
Description
The name of the table where the sequence is stored.
Attributes
String
Optional
Default value
SEQUENCES
Example
SEQUENCES
Example
COUNTERS
Column Sequence Name (columnSequenceName)
Description
The name of the column holding the sequence name.
Attributes
String
Optional
Default value
NAME
Example
ID
Example
NAME
Column Sequence Number (columnSequenceNumber)
Description
The name of the column holding the sequence number. The column must be of a numeric type.
Attributes
String
Optional
Default value
STATE
Example
STATE
YAML Template (with default values) 

type: DatabaseSequenceGenerator
id: DatabaseSequenceGenerator-xxxxxx
displayName: 
comment: 
properties:
  columnSequenceName: NAME
  columnSequenceNumber: STATE
  sequenceName:
  sqlDataSource:
  tableName: SEQUENCES