Package org.springframework.jdbc.support.incrementer

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


                        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

Copyright © 2018 www.massapicom. All rights reserved.
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.