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

Package org.springframework.jdbc.support.incrementer

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

org.springframework.jdbc.support.incrementer.HsqlMaxValueIncrementer
Class to increment 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. @author Jean-Pierre Pawlak @author Thomas Risberg @author Juergen Hoeller @see org.springframework.jdbc.support.incrementer.HsqlSequenceMaxValueIncrementer

                        newPo.setUsingGeneratedKeysStrategy(false);
                        newPo.setIncrementer(new PostgreSQLSequenceMaxValueIncrementer(dataSource, newPo.getBaseName() + "_seq"));
                    }
                    else if ("HSQL Database Engine".equals(newPo.getDatabaseProductName())) {
                        newPo.setUsingGeneratedKeysStrategy(false);
                        newPo.setIncrementer(new HsqlMaxValueIncrementer(dataSource, newPo.getBaseName() + "_seq", "value"));
                    }
                    else if ("Oracle".equals(newPo.getDatabaseProductName())) {
                        newPo.setUsingGeneratedKeysStrategy(false);
                        newPo.setIncrementer(new OracleSequenceMaxValueIncrementer(dataSource, newPo.getBaseName() + "_seq"));
                    }

View Full Code Here

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


    HsqlMaxValueIncrementer incrementer = new HsqlMaxValueIncrementer();
    incrementer.setDataSource(ds);
    incrementer.setIncrementerName("myseq");
    incrementer.setColumnName("seq");
    incrementer.setCacheSize(3);
    incrementer.setPaddingLength(3);
    incrementer.afterPropertiesSet();


    assertEquals(0, incrementer.nextIntValue());
    assertEquals(1, incrementer.nextLongValue());
    assertEquals("002", incrementer.nextStringValue());
    assertEquals(3, incrementer.nextIntValue());
    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 max(identity()) from myseq")).willReturn(resultSet);
    given(resultSet.next()).willReturn(true);
    given(resultSet.getLong(1)).willReturn(0L, 1L, 2L, 3L, 4L, 5L);


    HsqlMaxValueIncrementer incrementer = new HsqlMaxValueIncrementer();
    incrementer.setDataSource(dataSource);
    incrementer.setIncrementerName("myseq");
    incrementer.setColumnName("seq");
    incrementer.setCacheSize(3);
    incrementer.setPaddingLength(3);
    incrementer.setDeleteSpecificValues(true);
    incrementer.afterPropertiesSet();


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


    verify(statement, times(6)).executeUpdate("insert into myseq values(null)");
    verify(statement).executeUpdate("delete from myseq where seq in (-1, 0, 1)");
    verify(statement).executeUpdate("delete from myseq where seq in (2, 3, 4)");
    verify(resultSet, times(6)).close();

View Full Code Here

    given(connection.createStatement()).willReturn(statement);
    given(statement.executeQuery("select max(identity()) from myseq")).willReturn(resultSet);
    given(resultSet.next()).willReturn(true);
    given(resultSet.getLong(1)).willReturn(0L, 1L, 2L, 3L, 4L, 5L);


    HsqlMaxValueIncrementer incrementer = new HsqlMaxValueIncrementer();
    incrementer.setDataSource(dataSource);
    incrementer.setIncrementerName("myseq");
    incrementer.setColumnName("seq");
    incrementer.setCacheSize(3);
    incrementer.setPaddingLength(3);
    incrementer.afterPropertiesSet();


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


    verify(statement, times(6)).executeUpdate("insert into myseq values(null)");
    verify(statement).executeUpdate("delete from myseq where seq < 2");
    verify(statement).executeUpdate("delete from myseq where seq < 5");
    verify(resultSet, times(6)).close();

View Full Code Here

    }
    else if (databaseType == DERBY) {
      return new DerbyMaxValueIncrementer(dataSource, incrementerName, incrementerColumnName);
    }
    else if (databaseType == HSQL) {
      return new HsqlMaxValueIncrementer(dataSource, incrementerName, incrementerColumnName);
    }
    else if (databaseType == H2) {
      return new H2SequenceMaxValueIncrementer(dataSource, incrementerName);
    }
    else if (databaseType == MYSQL) {

View Full Code Here

TOP

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

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

org.springframework.jdbc.support.DataFieldMaxValueIncrementerTests

org.springmodules.datamap.jdbc.sqlmap.support.ActiveMapperUtils

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.