java.lang.Object | |||
↳ | org.springframework.jdbc.support.incrementer.AbstractDataFieldMaxValueIncrementer | ||
↳ | org.springframework.jdbc.support.incrementer.AbstractColumnMaxValueIncrementer | ||
↳ | org.springframework.jdbc.support.incrementer.MySQLMaxValueIncrementer |
DataFieldMaxValueIncrementer
that increments the maximum value of a given MySQL table
with the equivalent of an auto-increment column. Note: If you use this class, your MySQL
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. The table type of the sequence table should be MyISAM so the sequences are allocated without regard to any transactions that might be in progress.
Example:
create table tab (id int unsigned not null primary key, text varchar(100)); create table tab_sequence (value int not null) type=MYISAM; 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.
[Expand]
Inherited Fields | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
From class
org.springframework.jdbc.support.incrementer.AbstractDataFieldMaxValueIncrementer
|
Public Constructors | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Default constructor for bean property style usage.
| |||||||||||
Convenience constructor.
|
Protected Methods | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Determine the next key to use, as a long.
|
[Expand]
Inherited Methods | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
From class
org.springframework.jdbc.support.incrementer.AbstractColumnMaxValueIncrementer
| |||||||||||
From class
org.springframework.jdbc.support.incrementer.AbstractDataFieldMaxValueIncrementer
| |||||||||||
From class
java.lang.Object
| |||||||||||
From interface
org.springframework.beans.factory.InitializingBean
| |||||||||||
From interface
org.springframework.jdbc.support.incrementer.DataFieldMaxValueIncrementer
|
Default constructor for bean property style usage.
Convenience constructor.
dataSource | the DataSource to use |
---|---|
incrementerName | the name of the sequence/table to use |
columnName | the name of the column in the sequence table to use |
Determine the next key to use, as a long.
DataAccessException |
---|