Package org.springframework.jdbc.support.incrementer

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

101
102
103
104
105
106
107
108
109
110
111
                        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"));
                    }
                    else {
                        newPo.setUsingGeneratedKeysStrategy(true);
                    }
                    String metaDataTableName;
View Full Code Here
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
    dsControl.replay();
    conControl.replay();
    stmtControl.replay();
    rsControl.replay();

    OracleSequenceMaxValueIncrementer incrementer = new OracleSequenceMaxValueIncrementer();
    incrementer.setDataSource(ds);
    incrementer.setIncrementerName("myseq");
    incrementer.setPaddingLength(2);
    incrementer.afterPropertiesSet();

    assertEquals(10, incrementer.nextLongValue());
    assertEquals("12", incrementer.nextStringValue());

    dsControl.verify();
    conControl.verify();
    stmtControl.verify();
    rsControl.verify();
View Full Code Here
210
211
212
213
214
215
216
  protected void insertWithDB2Sequence(Object entity,String sequenceName,String insertSql) {
    insertWithSequence(entity, new DB2SequenceMaxValueIncrementer(getDataSource(),sequenceName), insertSql);
  }
 
  protected void insertWithOracleSequence(Object entity,String sequenceName,String insertSql) {
    insertWithSequence(entity, new OracleSequenceMaxValueIncrementer(getDataSource(),sequenceName), insertSql);
  }
View Full Code Here
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
    String pkSequence = cghead.getJformPkSequence();
    if(StringUtil.isNotEmpty(pkType)&&"UUID".equalsIgnoreCase(pkType)){
      pkValue = UUIDGenerator.generate();
    }else if(StringUtil.isNotEmpty(pkType)&&"NATIVE".equalsIgnoreCase(pkType)){
      if(StringUtil.isNotEmpty(dbType)&&"oracle".equalsIgnoreCase(dbType)){
        OracleSequenceMaxValueIncrementer incr = new OracleSequenceMaxValueIncrementer(dataSource, "HIBERNATE_SEQUENCE"); 
        try{
          pkValue = incr.nextLongValue();
        }catch (Exception e) {
          logger.error(e,e);
        }
      }else if(StringUtil.isNotEmpty(dbType)&&"postgres".equalsIgnoreCase(dbType)){
        PostgreSQLSequenceMaxValueIncrementer incr = new PostgreSQLSequenceMaxValueIncrementer(dataSource, "HIBERNATE_SEQUENCE"); 
        try{
          pkValue = incr.nextLongValue();
        }catch (Exception e) {
          logger.error(e,e);
        }
      }else{
        pkValue = null;
      }
    }else if(StringUtil.isNotEmpty(pkType)&&"SEQUENCE".equalsIgnoreCase(pkType)){
      if(StringUtil.isNotEmpty(dbType)&&"oracle".equalsIgnoreCase(dbType)){
        OracleSequenceMaxValueIncrementer incr = new OracleSequenceMaxValueIncrementer(dataSource, pkSequence); 
        try{
          pkValue = incr.nextLongValue();
        }catch (Exception e) {
          logger.error(e,e);
        }
      }else if(StringUtil.isNotEmpty(dbType)&&"postgres".equalsIgnoreCase(dbType)){
        PostgreSQLSequenceMaxValueIncrementer incr = new PostgreSQLSequenceMaxValueIncrementer(dataSource, pkSequence); 
        try{
          pkValue = incr.nextLongValue();
        }catch (Exception e) {
          logger.error(e,e);
        }
      }else{
        pkValue = null;
View Full Code Here
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
    given(connection.createStatement()).willReturn(statement);
    given(statement.executeQuery("select myseq.nextval from dual")).willReturn(resultSet);
    given(resultSet.next()).willReturn(true);
    given(resultSet.getLong(1)).willReturn(10L, 12L);

    OracleSequenceMaxValueIncrementer incrementer = new OracleSequenceMaxValueIncrementer();
    incrementer.setDataSource(dataSource);
    incrementer.setIncrementerName("myseq");
    incrementer.setPaddingLength(2);
    incrementer.afterPropertiesSet();

    assertEquals(10, incrementer.nextLongValue());
    assertEquals("12", incrementer.nextStringValue());

    verify(resultSet, times(2)).close();
    verify(statement, times(2)).close();
    verify(connection, times(2)).close();
  }
View Full Code Here
95
96
97
98
99
100
101
102
103
104
105
    }
    else if (databaseType == MYSQL) {
      return new MySQLMaxValueIncrementer(dataSource, incrementerName, incrementerColumnName);
    }
    else if (databaseType == ORACLE) {
      return new OracleSequenceMaxValueIncrementer(dataSource, incrementerName);
    }
    else if (databaseType == POSTGRES) {
      return new PostgreSQLSequenceMaxValueIncrementer(dataSource, incrementerName);
    }
    else if (databaseType == SQLITE) {
View Full Code Here
TOP

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

  • javacommon.base.BaseSpringJdbcDao
  • org.jeecgframework.web.cgform.service.impl.build.DataBaseServiceImpl
  • org.springframework.batch.item.database.support.DefaultDataFieldMaxValueIncrementerFactory
  • org.springframework.jdbc.support.DataFieldMaxValueIncrementerTests
  • org.springmodules.datamap.jdbc.sqlmap.support.ActiveMapperUtils
    • 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.