public class HsqlMaxValueIncrementer extends AbstractColumnMaxValueIncrementer
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
HsqlSequenceMaxValueIncrementer
paddingLength
Constructor and Description |
---|
HsqlMaxValueIncrementer()
Default constructor for bean property style usage.
|
HsqlMaxValueIncrementer(DataSource dataSource,
String incrementerName,
String columnName)
Convenience constructor.
|
Modifier and Type | Method and Description |
---|---|
protected long |
getNextKey()
Determine the next key to use, as a long.
|
afterPropertiesSet, getCacheSize, getColumnName, setCacheSize, setColumnName
getDataSource, getIncrementerName, getPaddingLength, nextIntValue, nextLongValue, nextStringValue, setDataSource, setIncrementerName, setPaddingLength
public HsqlMaxValueIncrementer()
public HsqlMaxValueIncrementer(DataSource dataSource, String incrementerName, String columnName)
dataSource
- the DataSource to useincrementerName
- the name of the sequence/table to usecolumnName
- the name of the column in the sequence table to useprotected long getNextKey() throws DataAccessException
AbstractDataFieldMaxValueIncrementer
getNextKey
in class AbstractDataFieldMaxValueIncrementer
DataAccessException