Examples of org.springframework.jdbc.support.incrementer.MySQLMaxValueIncrementer

Package org.springframework.jdbc.support.incrementer

Examples of org.springframework.jdbc.support.incrementer.MySQLMaxValueIncrementer

org.springframework.jdbc.support.incrementer.MySQLMaxValueIncrementer
{@link DataFieldMaxValueIncrementer} that increments the maximum value of a given MySQL tablewith 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. @author Jean-Pierre Pawlak @author Thomas Risberg @author Juergen Hoeller

    dsControl.replay();
    conControl.replay();
    stmtControl.replay();
    rsControl.replay();


    MySQLMaxValueIncrementer incrementer = new MySQLMaxValueIncrementer();
    incrementer.setDataSource(ds);
    incrementer.setIncrementerName("myseq");
    incrementer.setColumnName("seq");
    incrementer.setCacheSize(2);
    incrementer.setPaddingLength(1);
    incrementer.afterPropertiesSet();


    assertEquals(1, incrementer.nextIntValue());
    assertEquals(2, incrementer.nextLongValue());
    assertEquals("3", incrementer.nextStringValue());
    assertEquals(4, incrementer.nextLongValue());


    dsControl.verify();
    conControl.verify();
    stmtControl.verify();
    rsControl.verify();

View Full Code Here

    given(connection.createStatement()).willReturn(statement);
    given(statement.executeQuery("select last_insert_id()")).willReturn(resultSet);
    given(resultSet.next()).willReturn(true);
    given(resultSet.getLong(1)).willReturn(2L, 4L);


    MySQLMaxValueIncrementer incrementer = new MySQLMaxValueIncrementer();
    incrementer.setDataSource(dataSource);
    incrementer.setIncrementerName("myseq");
    incrementer.setColumnName("seq");
    incrementer.setCacheSize(2);
    incrementer.setPaddingLength(1);
    incrementer.afterPropertiesSet();


    assertEquals(1, incrementer.nextIntValue());
    assertEquals(2, incrementer.nextLongValue());
    assertEquals("3", incrementer.nextStringValue());
    assertEquals(4, incrementer.nextLongValue());


    verify(statement, times(2)).executeUpdate("update myseq set seq = last_insert_id(seq + 2)");
    verify(resultSet, times(2)).close();
    verify(statement, times(2)).close();
    verify(connection, times(2)).close();

View Full Code Here

    }
    else if (databaseType == H2) {
      return new H2SequenceMaxValueIncrementer(dataSource, incrementerName);
    }
    else if (databaseType == MYSQL) {
      return new MySQLMaxValueIncrementer(dataSource, incrementerName, incrementerColumnName);
    }
    else if (databaseType == ORACLE) {
      return new OracleSequenceMaxValueIncrementer(dataSource, incrementerName);
    }
    else if (databaseType == POSTGRES) {

View Full Code Here

    this.setDataSource(ds);
    setIncrementer(this.getIncrementer(ds));
  }


  private DataFieldMaxValueIncrementer getIncrementer(DataSource ds) {
    MySQLMaxValueIncrementer incrementer = new MySQLMaxValueIncrementer();
    incrementer.setCacheSize(100);
    incrementer.setDataSource(ds);
    incrementer.setIncrementerName(getKeyspaceTableName());
    incrementer.setColumnName(COLUMN_NAME);
    return incrementer;
  }

View Full Code Here

TOP

Related Classes of org.springframework.jdbc.support.incrementer.MySQLMaxValueIncrementer

org.hivedb.management.MySqlKeyAuthority

org.springframework.batch.item.database.support.DefaultDataFieldMaxValueIncrementerFactory

org.springframework.jdbc.support.DataFieldMaxValueIncrementerTests

org.springframework.dao.DataAccessResourceFailureException

java.sql.Statement

java.sql.ResultSet

java.sql.Connection

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.