spring-framework / org.springframework.jdbc.support.incrementer / HsqlMaxValueIncrementer

HsqlMaxValueIncrementer

open class HsqlMaxValueIncrementer : AbstractIdentityColumnMaxValueIncrementer

DataFieldMaxValueIncrementer that increments the maximum value of a given HSQL table with the equivalent of an auto-increment column. Note: If you use this class, your HSQL key column should NOT be auto-increment, as the sequence table does the job.

The sequence is kept in a table. There should be one sequence table per table that needs an auto-generated key.

Example:

create table tab (id int not null primary key, text varchar(100)); create table tab_sequence (value identity); insert into tab_sequence values(0);

If "cacheSize" is set, the intermediate values are served without querying the database. If the server or your application is stopped or crashes or a transaction is rolled back, the unused values will never be served. The maximum hole size in numbering is consequently the value of cacheSize.

NOTE: HSQL now supports sequences and you should consider using them instead: HsqlSequenceMaxValueIncrementer

Author
Jean-Pierre Pawlak

Author
Thomas Risberg

Author
Juergen Hoeller

See Also
HsqlSequenceMaxValueIncrementer

Constructors

<init>

HsqlMaxValueIncrementer()

Default constructor for bean property style usage.

HsqlMaxValueIncrementer(dataSource: DataSource, incrementerName: String, columnName: String)

Convenience constructor.

Inherited Functions

isDeleteSpecificValues	`open fun isDeleteSpecificValues(): Boolean` Return whether to delete the entire range below the current maximum key value (`false` - the default), or the specifically generated values (`true`).
setDeleteSpecificValues	`open fun setDeleteSpecificValues(deleteSpecificValues: Boolean): Unit` Specify whether to delete the entire range below the current maximum key value (`false` - the default), or the specifically generated values (`true`). The former mode will use a where range clause whereas the latter will use an in clause starting with the lowest value minus 1, just preserving the maximum value.